问题描述
我有一个worbook名称''student''它有1到60张。我选择了所有床单的第B2号单元格。我想改变所有1-60张的B2单元格中的公式。
sheet1单元格B2中的公式是= [sub.xlsx] Sheet1！$ B $ 2
$ 2 $ b在sheet2中公式应该更改= [ sub.xlsx] Sheet1！$ B $ 3
$ 3 $ b在sheet3单元格B2中公式应该改变= [sub.xlsx] Sheet1！$ B $ 4
$ b Sheet4单元格B2中的$ b公式应该更改= [sub.xlsx] Sheet1！$ B $ 5
$ 5 $ b在sheet5单元格B2中公式应该更改= [sub.xlsx] Sheet1！$ B $ 6
这样做这个工作簿中有多少张
就像链接单元格一样，即按=然后输入，但这是一个很有意义的工作。
a代码为此而烦恼但却没有工作
如此提供代码或公式
非常非常感谢提前
I have a worbook name ''student'' it has 1 to 60 sheets. I have selected cell No.B2 of all sheets. I want to change formula in B2 cells of all 1-60 sheets.
The formula in sheet1 cell B2 is =[sub.xlsx]Sheet1!$B$2
in sheet2 the formula should change =[sub.xlsx]Sheet1!$B$3
in sheet3 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$4
in sheet4 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$5
in sheet5 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$6
do this how many sheets in this workbook
its like as link cells i.e press = then enter , but its a boresome work.
a code frovided for this but it was not worked
So plese provide a code or formula
Very Very thanks in Advance
推荐答案
这篇关于在shet = ets上添加链接或更改公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！