ExcelBanter - Excel Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Question (https://www.excelbanter.com/excel-worksheet-functions/63738-excel-question.html)

stinch0

Excel Question

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?

Domenic

Excel Question

Enter the following formula in A1 on Sheet2...

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

Hope this helps!

In article ,
"stinch0" wrote:

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?

All times are GMT +1. The time now is 07:58 PM.