I have 2 worksheets with exactly the same type of data, ie name, dates, amounts, etc under the exact same headings. I want to compile the data from both worksheets onto one sheet, how can i do this? I know how to use pivot tables but couldnt figure it out, i've never used powerpivot as i use excel 2010, but couldnt figure it out. Same with vlookup, which i often use, i cant find a way of compiling 2 sets of similar data, can anyone help?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Compile data from different worksheets on same file
- Thread starter dvp
- Start date
