Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |