I want to transfer 5 cells of data to 3 worksheets, Justin gave me a VBA that fransfers data to 1 worksheet but I cant workout how to transfer to 3 worksheets, I have attached a sample that works in part.
I want to transfer 5 cells of data to 3 worksheets, Justin gave me a VBA that fransfers data to 1 worksheet but I cant workout how to transfer to 3 worksheets, I have attached a sample that works in part.
Last edited by Chris Watson; 05-02-2009 at 07:23 AM.
Chris,
I have uploaded a modified macro. I created a range name, dlSheetNames on the source data sheet. To paste to a particular sheet, VBA needs to know the sheet name. As long as you record the sheet names that you want to paste data to inside the dlSheetNames range name, the macro will now paste to multiple sheets.
Thanks again Justin its perfect. Im not expert with Excel but I get by but the VBA programming I find fasinating. Im determind to learn something about VBA so ive ordered a book of Amazon "Power Programming with VBA By: John Walkenbach" I have his Excel Bible which has helped me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks