Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I need to create a workbook that will import a text file every month. Once
imported I need to do a formula. Let me see if I can explain.Col a has my numbers, I need to take the first 400 from A, and put the remainder in col C, but only if col a is 400 and if it is less that 400 take the contents on A and put in B. This is billing at different rates. A B C 2000 400 1600 400 400 0 395 395 0 1000 400 600 -------------------------------- 3795 1595 2200 Total of A should equal B+C Where do I need to start? I know very very little about macros and formula programming in Excel. TIA Gerald -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |