Below is the link to the file I am trying to use (one Sheet is value-only)
https://drive.google.com/open?id=1cdRPGcB48PHmPJu5C-FmNYhqoImoCuoZ
I am trying to copy the first cell with a value on 'FBE Graph' Column B to 'FBE Graph' Cell I10
then copy 'FBE Graph' Cells I14:I32 to 'Summary' Cells Q26:Q44
then copy 'FBE Graph' Cell C3 to 'Summary' Cell Q4
then call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell C4
then copy 'FBE Graph' Cell D3 to 'Summary' Cell Q4
the call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell D4
then copy 'FBE Graph' Cell E3 to 'Summary' Cell Q4
then call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell E4
I want this to repeat for all of 'FBE Graph' Column B
The final product should be 'FBE Graph' Cells C4:E34 populated with the outputs of 'Summary' Cell Q18
Thank you!
https://drive.google.com/open?id=1cdRPGcB48PHmPJu5C-FmNYhqoImoCuoZ
I am trying to copy the first cell with a value on 'FBE Graph' Column B to 'FBE Graph' Cell I10
then copy 'FBE Graph' Cells I14:I32 to 'Summary' Cells Q26:Q44
then copy 'FBE Graph' Cell C3 to 'Summary' Cell Q4
then call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell C4
then copy 'FBE Graph' Cell D3 to 'Summary' Cell Q4
the call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell D4
then copy 'FBE Graph' Cell E3 to 'Summary' Cell Q4
then call outside macro 1
then call outside macro 2
the copy 'Summary' Cell Q18 to 'FBE Graph' Cell E4
I want this to repeat for all of 'FBE Graph' Column B
The final product should be 'FBE Graph' Cells C4:E34 populated with the outputs of 'Summary' Cell Q18
Thank you!