i have an excell spread sheet with multipule sheets open. i need to select certain rows of information, copy the info and tell that information where to appear on another sheet or multipule sheets.
i was trying the if command. =if g4>0,"a4:d4", which gets me the info i need but how do i tell it to go to another
cell in another sheet?