I would like based on a IF condition to move the contents of a row in one
sheet to another sheet, effectively copying the contents of an existing sheet
to the new location in the new sheet.
I need for the copy to be conditional within an IF Statement. I'm trying to
move cells from three different rows to a single row based on the contents of
a third cell.
Hi,
You didn't provide and example what will really helps however try
=If(a1="Yes",A3+A4+A5,"")
A1 is the cell that you want to compare with
A3,4 & 5 are the 3 cells to summarize
If A1 is different to yes it will leave a blank space
I would like based on a IF condition to move the contents of a row in one
sheet to another sheet, effectively copying the contents of an existing sheet
to the new location in the new sheet.
What I'm trying to do is based on a variable in Sheet one move a row of data
from sheet1 to sheet2 based on informatin in sheet1. The above example would
move 17 cells to this location on sheet2 from C1 to C17.
What I'm trying to do is based on a variable in Sheet one move a row of data
from sheet1 to sheet2 based on informatin in sheet1. The above example would
move 17 cells to this location on sheet2 from C1 to C17.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.