Copy and Paste non-contiguo data to another sheet

I need some help on how to make a storage button.

So basically, theres a sheet in the spreadsheet called "Invoice" and it has all the details like Costs, Customer ID, Product ID"

I need this information so when you press the button it gets automatically entered into a "invoice database" page so in a row it has like Customer ID, Product ID, Costs and it gets put under the columns it falls under.

You could do this with a Macro, but the tricky thing is making it so when you press the button again it goes onto the next row. Otherwise it will just keep over-writing the first row.

So making it when you press the button it, writes to the row. Then if you press again, it writes the row below it.

Anyone know how to do that? If you wish to speak on MSN just pm me

Thanks!

Check out this code, change the range to meet your requirements

Please Login or Register  to view this content.

Here is a very simple example, but it should work in your case

Click the button, the ranges will be copied to the next sheet

Change the A65536 to a D65536