Macro to Insert multiple rows at same location multiple sheets and copying down formula
I have a workbook with about 12 different sheets
The master sheet which is named "Weight Calculation" has hundreds of rows of data. I need to insert new rows anywhere within this sheet and for these new rows to be also inserted in two other sheets ("SOL Distribution" & " In Service Distribution") but not all worksheets.
When I insert the rows (to have a dialog box come up asking which row to insert and how many rows is required) I want it to copy down any cells which contain formulas from above but to remove any constant data.
The two additional sheets listed above directly reference back to the master sheet so i need them to have the whole row copy down formula from cells above
Hopefully this makes sense
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1