Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
JOSAMUEL
Posted - 07/23/2021 : 1:48:30 PM Hi all,
I have 10 workbooks for example in a project with the workbooks named as 1 till 10. Now I need to add a column in all of the 10 workbooks. However, when I'm adding, the column added in the workbook named 1 should have the number 1 in all the rows, and the column added for the workbook named 2, should contain the number 2 in all the rows. likewise, it should go on until file 10th file. Any idea how to do this?
Thanks in advance.
JOSAMUEL
1 L A T E S T R E P L I E S (Newest First)
snowli
Posted - 07/23/2021 : 6:11:54 PM I suppose you mean book long names are 1 to 10 since book short names can't start with number.
Then suppose you only have 1 sheet in book, try this