Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to COPY FORMULA BETWEEN RANGES
I have a vlookup under inventory, orders & POs, I need to copy and paste it
to the end of that range, then go to the next section and paste. This need to continue through many different ranges, and the number of rows could change. Any ideas. I did name the ranges ie "tissue", and "paper towels", maybe there is a way to copy formula from 1st row throughout all range names, but that still leaves the remaining rows in the first range. Any help would be appreciated Paper Products - WASHROOM TISSUE Proteus Open Open Description Inventory Orders P.O.s 11375 RESPONSE 241 1154 1100 11440 RESPONSE 14800 ECO SOFT Paper Products - PAPER TOWELS Proteus Open Open Description Inventory Orders P.O.s RK600E ROLL - BROWN SK1850A SINGLEFOLD-BROWN -- Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
How do I copy formula but only increment certain ranges? | Excel Discussion (Misc queries) | |||
Macro to Copy Var. Ranges to Var. Rows | Excel Discussion (Misc queries) | |||
how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
Using macro/vba to copy varying ranges of rows | Excel Discussion (Misc queries) |