Thread: Macros pulling info from other worksheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dennis.mccarthy@us.atlascopco.com is offline
external usenet poster
  
Posts: 16
Default Macros pulling info from other worksheets
On Dec 7, 1:01 pm, wrote:
How can I have the macro / vba prompt me for the name of the workbook
and sheet each time I run it? Both the active sheet and the one I
would be pulling from will be open, but the one I am pulling from will
change in name and its sheet names will be different each time.

Thanks

PS using Excel 2007
Reply With QuoteReply With Quote