View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
supamari0 supamari0 is offline
external usenet poster
 
Posts: 6
Default Macro to copy data from one workbook to another

Hi,

I need to create a macro that opens up a specific excel file. This file has
data that is split into twelve different columns (one for each month). I need
this macro to create a msgbox that allows the user to select the month and
then copy all the data in that row to the other document.

Anyone have any ideas on this one?

Thanks in Advance!