Put copy/paste between books in macro
Hi, I have a s/s that is the output of a query called target.xls. I have another s/s (template.xls) that is a template for how target.xls should look in terms of formatting. I want to write a macro that will make target.xls keep its data but take its formatting from target.xls. When recording a macro, I flip between both s/s, copying some columns etc from template.xls and pasting them into target.xls. However, the macro won't record such movements properly. I also tried doing all the copy/pastes and then undoing till the beginning, then starting to record and then redoing till the end. This didn't work either. Is there any way to capture the copy/pastes in the macro OR do I need to recreate the formatting in template.xls manually? Thanks! Regards, Rajat |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com