Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MOving Data to the next line
Hi All
I have a spreadsheet template that I use as a Purchase Order. There is information on that sheet that I want to be transfered to a table. I do not want the data over written when using the template again, I want the next line to be used for the same data but now with the second time I have used the template... HEre is a list of the information that I am currently capturing on the Purchase Order Template. VENDOR NAME VENDOR NUMBER ACCOUNT CODE CENTRE CODE D/C Cost per unit Discount Quantity AMOUNT DESCRIPTION Value Vat (gst) TOTAL AMOUNT REQUEST DATE Midas 123456 152 Invcontrol D R 3.00 0% 500 R 1,500.00 11MM Socket R 1,500.00 R 210.00 R 1,710.00 09/16/2009 Any tips or guidliens would be greatly appreciated. Thanks Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Moving line to a column | Excel Discussion (Misc queries) | |||
Moving data labels around with VBA (and adding a line between two | Charts and Charting in Excel | |||
Moving a line of data when information is entered in a specific cell. | Excel Discussion (Misc queries) |