Hi,

I am new to macros and I am not quite understanding them, I need to create a macro that will:
1)Copy the first 5 columns from a workbook starting from Row A5 and down to the last row of data, from first worksheet in the workbook.
2)Paste the copied columns into a Result workbook on first worksheet
3)The pasted data in the Result Workbook needs to be 5 columns to right for each time I use the macro, its continuous data that runs
across. For EX: the first 5 columns will be dumped into Columns A-E, and the next time I extract from another workbook the data is dumped into column F-J and so forth.
4)Create button so that when I press it i can prompt user to enter the name of the workbook to select for extracting data from.

any ideas?

thanks.