I have a number of spreadsheets (12) that feed a summary sheet. The 12 sheets derive their static information from the summary, e.g. item names, dates, etc. While data is input into the 12 sheets.
I am trying to create a macro that will add a row, for a new item, in all of the sheets. Once the row is added I need to copy the formula from the previous row. The added row is not the last row of the spreadsheet.
Thank you for your help.
If the added row is not the last row, where will the row be added?
Will it be the same row number in all the sheets?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The added line will be at the end of a section of each spreadsheet. The line will be in the same place for the 12 data pages, but it is different for the summary sheet.
Originally Posted by arlu1201
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks