Extract data from one sheet to another
Solved/Closed
phanikr
Mazzaropi
- Posts
- 1
- Registration date
- Friday June 17, 2016
- Status
- Member
- Last seen
- June 17, 2016
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Extract data from one sheet to another
- How to extract data from one sheet to another in excel using vba - Guide
- I need a macro that can extract data - Forum - Excel
- Extract data from pivot table to another sheet vba - Forum - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
1 reply
Mazzaropi
Jun 17, 2016 at 03:07 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Jun 17, 2016 at 03:07 PM
phanikr, Good afternoon.
The VLOOKUP function is very good for this job.
Put the function in spreadsheet 1 and search the same name on the worksheet 2.
The names don't need to be in the same order.
Capture the worksheet phone number 2 and bring to a spreadsheet 1.
Please, tell us if it worked for you.
If you prefer, save your file at a free site, www.speedyshare.com and put a link to download here.
It's easier to help you.
I hope it helps.
The VLOOKUP function is very good for this job.
Put the function in spreadsheet 1 and search the same name on the worksheet 2.
The names don't need to be in the same order.
Capture the worksheet phone number 2 and bring to a spreadsheet 1.
Please, tell us if it worked for you.
If you prefer, save your file at a free site, www.speedyshare.com and put a link to download here.
It's easier to help you.
I hope it helps.