Forum Discussion
Consolidate Data in excel
While consolidate data from two different worksheets, after adding one data range, second worksheet is not opening for selecting second data range. First sheet coming up! how can I move to second she...
I think we need a bit more information in order to be able to answer. How are you doing this consolidation in the first place, for example? Are the two data ranges in the same workbook, different sheets, or different workbooks altogether? That kind of stuff. And if you can post copies of the spreadsheets--so long as they contain no confidential info--that too would help us help you.
Thanks for your response...
No, two data ranges in two different worksheets.
In attached 3 sheets, I want to consolidate data available in Mechanical and Electrical sheets into Consolidate sheet, where data against each TAG under Mechanical and Electrical sheets will come together and move on...
If you need any more data or input pl. revert