adamcooke148
New Member
- Joined
- Jan 12, 2015
- Messages
- 1
Hi,
What I need is a macro that can copy and paste values back and forth and then work down a list of values. I cannot get some basic macros to do it and am stumped; VBA isnt my forte.
I have 2 active sheets in my spreadsheet; Sheet 1 contains some formulae dependent on a certain cell that generates an output, sheet 2 contains a list of data.
The macro would copy a value from sheet 2 cell C2 and paste it into sheet 1 $B$8. Sheet 1 $B$8 does not change throughout the macro. This value has a vlookup linked to it to pull through values that the formulae use. This generates answers in cells B20 and B22 on sheet 1 and i need these values then need to be copied and pasted over to sheet 2 cells G2 and H2 respectively.
Instead of doing this all manually, the macro would need to repeat the process and work down the list in Sheet 2 from C2 to C288.
Any help would be greatly appreciated!
Many Thanks,
What I need is a macro that can copy and paste values back and forth and then work down a list of values. I cannot get some basic macros to do it and am stumped; VBA isnt my forte.
I have 2 active sheets in my spreadsheet; Sheet 1 contains some formulae dependent on a certain cell that generates an output, sheet 2 contains a list of data.
The macro would copy a value from sheet 2 cell C2 and paste it into sheet 1 $B$8. Sheet 1 $B$8 does not change throughout the macro. This value has a vlookup linked to it to pull through values that the formulae use. This generates answers in cells B20 and B22 on sheet 1 and i need these values then need to be copied and pasted over to sheet 2 cells G2 and H2 respectively.
Instead of doing this all manually, the macro would need to repeat the process and work down the list in Sheet 2 from C2 to C288.
Any help would be greatly appreciated!
Many Thanks,
