| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel populate fields in one worksheet to another?
My boss wants me to create a form in either Excel or Access. He first wanted
Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
In Sheet2
A1 =Sheet1!A1 "AngelaD" wrote: My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
If you want the entry made in Sheet1 cell A1 to also appear in Sheet2 cell
A20, enter this formula in Sheet2 cell A20: =IF(Sheet1!A1="","",Sheet1!A1) Biff "AngelaD" wrote in message ... My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
THX for replying so fast...forgive my adolescence in Excel, but could you
indulge me in explaining a little more what you mean by and what I need to do with: In Sheet2 A1 =Sheet1!A1 "Teethless mama" wrote: In Sheet2 A1 =Sheet1!A1 "AngelaD" wrote: My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
OK that makes sense. I am sure I will ask more questions.
"T. Valko" wrote: If you want the entry made in Sheet1 cell A1 to also appear in Sheet2 cell A20, enter this formula in Sheet2 cell A20: =IF(Sheet1!A1="","",Sheet1!A1) Biff "AngelaD" wrote in message ... My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
It worked, but how can I get it to populate an entire column? For example, if
I want to add some one in A200, and I want that same exact info in another sheet updated in A200 (worksheet 2) how can I make that happen? "T. Valko" wrote: If you want the entry made in Sheet1 cell A1 to also appear in Sheet2 cell A20, enter this formula in Sheet2 cell A20: =IF(Sheet1!A1="","",Sheet1!A1) Biff "AngelaD" wrote in message ... My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can excel populate fields in one worksheet to another?
Sheet2
A1 =IF(Sheet1!A1="","",Sheet1!A1) Select A1 and drag all the way down to A200 "AngelaD" wrote: It worked, but how can I get it to populate an entire column? For example, if I want to add some one in A200, and I want that same exact info in another sheet updated in A200 (worksheet 2) how can I make that happen? "T. Valko" wrote: If you want the entry made in Sheet1 cell A1 to also appear in Sheet2 cell A20, enter this formula in Sheet2 cell A20: =IF(Sheet1!A1="","",Sheet1!A1) Biff "AngelaD" wrote in message ... My boss wants me to create a form in either Excel or Access. He first wanted Excel because most people have excel on their computer. But I said Access because I thought it was easier. Anyway, he wants me to create a form. There are multiple forms for different purposes but sometimes require redundant information. How can you populate fields in one worksheet and have it updated also in another worksheet (within the same workbook)? Would this be easier to do in Access? Help is much appreciated! Angela |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import specific fields only from excel to database | Excel Discussion (Misc queries) | |||
| Problem importing excel worksheet in Word and or Power point | Excel Discussion (Misc queries) | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Hierarchical Worksheet Tabs??? New Excel feature? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
