Copy multiple worksheets with cell reference to to original worksheets in same workbook

**santanuKD** · 06-07-2019, 03:32 AM

Hi -

I want to Copy 3 worksheets i.e. A, B & C multiple time (count defined in "Summary" worksheet cell H6).
In Original B has formula that takes data from A and similarly C has formula that takes data from A.
Similarly when the B_New file is copied it should take data from A_New but no A.

Please check the macro I am using and suggest any correction.

Please Login or Register  to view this content.

**Pepe Le Mokko** · 06-07-2019, 03:39 AM

Code tags added by OP

**santanuKD** · 06-07-2019, 03:47 AM

Done

Will follow the same in future.

**Pepe Le Mokko** · 06-07-2019, 03:48 AM

Thanks
and BTW, do not quote entire posts unnecessarily. They are just clutter and make the thread hard to read.
Use the " Quick Reply" button instead.
Thanks

**dmcgov** · 06-07-2019, 07:44 AM

just an fyi, where is this sheet in the workbook?

Please Login or Register  to view this content.

Copy multiple worksheets with cell reference to to original worksheets in same workbook

LinkBack

Thread Tools

Rate This Thread

Display

Copy multiple worksheets with cell reference to to original worksheets in same workbook

Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

Re: Copy multiple worksheets with cell reference to to original worksheets in same workboo

Thread Information

Users Browsing this Thread

Similar Threads

copying worksheets without keeping the reference cell for a formula in the original worksh

[SOLVED] Copying Formulas Between Worksheets While Keeping Reference to Original Worksheet

Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets

[SOLVED] Copy of 1 cell into multiple worksheets in the same workbook

Copy of 1 cell into multiple worksheets in the same workbook

Bookmarks

Bookmarks

Posting Permissions