Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Move equations from line to line automatically
I need to create a excel template to import information into a MRP system.
Specificelly for cabinet doors Pricing is done by the square foot so I need to keep trac of the total price. The problem is the order can be as little as one door or it can be thousands of doors. I would like to see HEIGHT WIDTH STYLE QUANTITY SQ FT PRICE TOTAL So that the total would always appear below the last door entered. I am using Office 2003.Is this possible? |
#2
|
|||
|
|||
You can do it either of two ways: the easy way, or the slightly harder way.
The easy way is to move your TOTAL to above the header values, with a formula like =SUM(H3:H3000) where column H has your prices, starting in row 3. Then it doesn't matter how many you get. The slightly harder way is to write a macro to put in the SUM at the bottom: you can incorporate this into your data import routine, or run it manually. Something like this: Sub PutSum() Range("H65536").End(xlUp)(2).Formula = _ "=SUM(H3:H" & Range("H65536").End(xlUp).Row & ")" End Sub HTH, Bernie MS Excel MVP "Kingsobes" wrote in message ... I need to create a excel template to import information into a MRP system. Specificelly for cabinet doors Pricing is done by the square foot so I need to keep trac of the total price. The problem is the order can be as little as one door or it can be thousands of doors. I would like to see HEIGHT WIDTH STYLE QUANTITY SQ FT PRICE TOTAL So that the total would always appear below the last door entered. I am using Office 2003.Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and automatically move cells | Excel Discussion (Misc queries) | |||
Excel: is it possible to move column contents into a line | Excel Discussion (Misc queries) | |||
Let Excel shade every 3 line automatically | Excel Discussion (Misc queries) | |||
After scanning a barcode how can I automatically move to the next. | Excel Discussion (Misc queries) | |||
How do i move the filters from the columns on line one to the col. | Excel Worksheet Functions |