Check out some similar questions!
How to link one sheet data to another in excel
[ 1 Answers ]
I have prepare one monthly work hours report. First I create two excel sheet One sheet for employees hours entry sheet Another one sheet for consolidated sheet. If they enter hours entry sheet then update consolidated automaticaly(becoz I link in 2 sheets) But my questions I created hours...
Linking of Excel sheets and updating the data from one sheet to all the sheets
[ 5 Answers ]
Hi guys! I have a problem. I want all of your help in solving the problem. For the purpose, I have created a sample sheet and enclosed: The sample sheet contains four worksheets in it. The first worksheet titled “schools performance” is the master sheet and all the next three work sheets (sub...
Change imported excel data from table structure to plain data
[ 2 Answers ]
Hello, I have an excel spreadsheet that contains some imported tables. The tables contain close to 1 million records each. The tables come from an Access query that I import using Data --> Get External Data --> From Access. The problem is, the import sets the data up as an excel table which...
Eliminate data in sheet 1 from sheet 2 in excel
[ 1 Answers ]
I've got 4000 names in Sheet 1 and I've got 200 names is Sheet 2. The names of 200 person in Sheet 2 also contain in Sheet 1. I would like to ask how can I eliminate names in Sheet 1 (4000 names) based on names in Sheet 2 (200 names). View more questions Search
Add your answer here.
|