Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy worksheets within a workbook
I have a Master worksheet which I copy to add NEW worksheets within the WB. I use Control+A, Control+C, Control+V. This does a great job with formats/formulas, except for LINKS to a Summary Sheet in this WB. My Master worksheet has seven links to the Summary sheet (Summary sheet is just Rows/Columns) which are not copying. Possibly I might need a VBA code to copy these links. i.e., in Master w/s, copy $M$75 to F9 in Summary sheet, repeating $D$75 to H9, $F$73 to I9, $H$73 to J9, $J$73 to K9, $L$73 to L9, and $M$71 to M9. As NEW w/s's are added these links should copy to the next blank row in the Summary sheet, i.e., NEW w/s goes in Row 10, next new w/s goes in Row 11,....... There will be possibly upwards of 100 new w/s's. At present I'm entering the seven links manually. Lots of work and confusing. I'm using Excel 2007 Any help for me? Bob M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for copy data from all worksheets of a workbook to single sh | Excel Discussion (Misc queries) | |||
how to copy only values and formats of worksheets to new workbook | Excel Worksheet Functions | |||
Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
How do I copy multiple worksheets into a new workbook? | Excel Worksheet Functions |