Excel Question

S

stinch0

I'm trying to create a spreadsheet with multiple pages. I want to be able to
populate cells on page 2 with info on page 1. Ex.. If box A1= "yes" then
send A2 information to page 2 box A1. Any ideas?
 
D

Domenic

Enter the following formula in A1 on Sheet2...

=IF(Sheet1!A1="Yes",Sheet1!A2,"")

Hope this helps!
 
Top