Question about Microsoft Excel for PC
I have 4 worksheets with Names in column 1 and data in all the others. All 4 worksheets do not have all the same names. Just a few. I need one worksheet with certain individuals in column 1 and their corresponding data in the following columns but don't want to do this manually. I need a formula that will capture each person's data in each of the 4 worksheets and place it on their individual rows. So in the end I will have 5 worksheets with main worksheet that automatically updates as I update the other 4 worksheets.
I would rename all the tabs to something unique and re-do the refs. You can also refer to the sheets as members of the workbook's collection of sheets but if someone re-arranged the sheets, it'll break the formulas. You can lock the workbook so that people can't rearrange the worksheets but that will probably mess up other stuff.
Posted on Mar 10, 2008
You can add a reference from the worksheet 1 to all other worksheets
Is it OK?
Posted on Mar 09, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 15, 2010 | Microsoft Windows XP Professional
Oct 31, 2008 | Computers & Internet
May 01, 2009 | Computers & Internet
Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)
Dec 21, 2008 | Microsoft Excel for PC
May 20, 2008 | Microsoft Excel for PC
Apr 29, 2008 | Microsoft Excel for PC
Feb 03, 2008 | Microsoft Excel for PC
Jan 09, 2008 | Computers & Internet
Jan 07, 2008 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
237 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: