Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rookie VBA'er seeks help!
In order to try and reduce the size of an analytical
workbook I have,I'm trying to write some VBA to copy and paste VLOOKUP equations dependent upon the number of cells in another column. For example, I have a column of for example, 5000 numbers(there could be as many as 30,000 numbers) in column E, starting in E2. The equations to be copied run in row 2, columns F through M. The lookup array exists from A2 to D1000. The task is this: 1) Determine the base row of data in column E. 2) Copy the equations from F2 through M2 3) Paste the equations from F3 to the base row of column M, as determined from Task 1. I've been able to get bits and pieces to work, but when I jam them together, I'm lost, especially in Task #3. Any help would be greatly appreciated. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rookie needs help | Excel Worksheet Functions | |||
Can you do multiple goal seeks at the same time? | Excel Discussion (Misc queries) | |||
newbie seeks excel help - please!! | New Users to Excel | |||
Beginner seeks help with IF statement | Excel Worksheet Functions | |||
Newbie Seeks VLOOKUP help | Excel Programming |