can excel populate fields in one worksheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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?
 
Sheet2
A1 =IF(Sheet1!A1="","",Sheet1!A1)
Select A1 and drag all the way down to A200
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
can excel add worksheets based on cell population in another works 3
Different Passwords for different worksheets in one workbook 8
data from excel worksheet update with another excel worksheet 8
Populating Cells from One Worksheet to Another... 2
Duplicate cell information from one worksheet to another: 1
Populating a form 2
looking for a function that will populate opening a worksheet or t 2

Back
Top