I am having trouble refering to more than one sheet in an If/Then statement.
I am looking to do
If sheet2(cell1)>100 then sheet1(cell1)=sheet2(cell1)
Else sheet1(cell1)=sheet2(cell2)
I am having trouble refering to more than one sheet in an If/Then statement.
I am looking to do
If sheet2(cell1)>100 then sheet1(cell1)=sheet2(cell1)
Else sheet1(cell1)=sheet2(cell2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks