Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet where have a set model and then I have three columns of
variable data. The three variables need to be put into the designated input cells for the model to produce an answer. I need some help writing a macro which takes the three variables in one go and copies the values into the correct cells, then copies the answer into a fourth column next to the variables, then the macro should move down a row and repeat with the new variables from that row. For example, copy P5 into E11, copy Q5 into E14, copy R5 into E19 the take the answer from cell E20 and paste into S5, then drop down so that copy P6 into E11, copy Q6 into E14, copy R6 into E19 the take the answer from cell E20 and paste into S6 - repeat down to row 2000. Any help would be greatly appreciated! Thanks in advance Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |