Hey, I am doing an invoice and booking "system" using excel 2000.
How it works: You fill out a form, (in the process, filling out customer details, eg name, address, phone # etc... and selecting items to rent) and then calculate the total price (certain discounts and deposits apply). This I have done.
Now what I need to do is export certain data from the invoice into a data table in another sheet (using a macro). I know what data to export and where I want it. The trouble I'm having is:
I want to copy the data from certain cells, then paste it into the corresponding field within a table in the other sheet. The table starts out as 1 row. Each booking has an order number. Obviously this starts at one. The macro should copy all the data (the current method is, to select the cell, right click, copy, go to new cell right click, paste special, "values") from the appropriate cells (the data in the invoice is in different tables, it isnt all adjecent) and then in the other sheet, it should create a new row and insert the data (theres about 5-6 fields). The new table needs to sort all entries by the order number (displaying the most recent booking at the top).
Each customer has a unique ID #. Another thing I would like to do once the macro is done, is on the invoice sheet, automatically set the order number as 1 more than the last in the bookings table.
This should be possible, and I know it wouldn't be extremely difficult, but I need help with this quite urgently. I hope not to sound rude or impatient but a speedy response would be much appreciated. Thanks in advance
If you need any more info to help understand what is needed, just ask
Thanks.