Hello, I have a multi part question I was hoping some one could help me with. I have an existing Excel workbook that has a master spreadsheet and many subsequent data spreadsheets.
I need to append a new column(s) into the master spreadsheet. Then I need to loop through each of the data spread sheets and pull information to fill in the new column (i.e., A2 of each spread sheet). In some cases I would like to manipulate the information I pull before I write it into the new column (i.e., A2-B2). Each row of the master spreadsheet corresponds with the name of the data spreadsheet - the first cell of each row in the master spreadsheet is the name of a data spreadsheet.