etpeterson
New Member
- Joined
- Jan 19, 2005
- Messages
- 18
I h ave a workbook with 16 worksheets. In worksheets 2-16 I need to get a value in worksheet 1 and then paste it into each worksheet. This needs to be done within a large subroutine so I don't want to do this iterativley. Currently, my macro selects WS1, gets the value and then selects WS2 and pastes the value. I would like my subroutine to get the value without having to actually select the worksheet. That way as I create the individual worksheets, I can say, "get data from cell B10 in WS1 and past it in the current worksheet." Then when the next worksheet is created, I can execute the same code.
Please Help!
Thanks,
Eric
Please Help!
Thanks,
Eric