L
limjn
Dear all, as I am not an Excel Macro/VBA/Programming expert, therefore
need your idea in this scenario.
Assuming you define sets of rows and columns, in order of number
1,2,3,4,5,6,7....respectively (I don't follow the Excel numbering), s
*Row No. 1* will intersect with *Column No. 1* at a cell. Is i
possible to create a function that will autocreate a new worksheet wit
a name based on what I input in that cell, so in this case, the nam
will be 0101 (to represent row 1 and column 1) and the new workshee
should also has a name 0101?
If this is possible, the next question would be can I transfer th
values in cells in the parent worksheet to the newly created worksheet
I inputted beforehand all the values in parent worksheet, then if th
new worksheet is "autocreated", I expect some values to be "pulled
there.
Please give me some guidance on all these, thanks
need your idea in this scenario.
Assuming you define sets of rows and columns, in order of number
1,2,3,4,5,6,7....respectively (I don't follow the Excel numbering), s
*Row No. 1* will intersect with *Column No. 1* at a cell. Is i
possible to create a function that will autocreate a new worksheet wit
a name based on what I input in that cell, so in this case, the nam
will be 0101 (to represent row 1 and column 1) and the new workshee
should also has a name 0101?
If this is possible, the next question would be can I transfer th
values in cells in the parent worksheet to the newly created worksheet
I inputted beforehand all the values in parent worksheet, then if th
new worksheet is "autocreated", I expect some values to be "pulled
there.
Please give me some guidance on all these, thanks