Forum Discussion
Compare data- plz help asap
hi all, im new to excel and need help very urgently with my data I have 2 sets of data open on 2 separate tabs and i must combine them to compare -->through a chart then make a graph, however w...
however when i tried to paste data set #1 to data set #2 as a second sheet it does not do anything other than say "pasting in progress"
If you are creating a second sheet--as you appear to be doing--there's no need to copy and paste. To combine them into a single workbook, just follow these steps:
- have both sheets open
- right click on the tab name (bottom on sheet)
- select "move or copy"
- in the dialog box, select the name of the other sheet in the space under "To book:"
- and click "OK"
But then you're still left with how you're going to do the comparing.....so if you need help with further steps, come back with more info. And if it's possible without disclosing confidential information, you could help us help you by posting a copy of the workbook on OneDrive or GoogleDrive, with a link pasted here that grants edit access.