Combine data to fixed product id

G

Guest

Need a worksheet in excel which will combine data from different worksheets ,

Example Sales by month

Product Jan Feb March
ab-1000 100 129 140
ab-2000 50 20 30
ab-3000 40 10 50
 
K

Kletcho

You could try using a pivot table and using the multiple consolidation
ranges option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match 2 set data and combine to 1set 2
How to combine amount in manys sheets into 1 summary sheets 2
Countifs or a pivot 1
Combine multiple cells into one cell. 3
Help required to code a '% of total' column 1
Automatically merging 2 data sets that share some values 5
Converting A Quarterly Dataset to Weekly Dataset 5
Finding data in an area that changes 8

Top