Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combine Data from several worksheets
I'm a novice using Excel 2000. How do I combine data from several worksheets
into one worksheet. Data is in 2 columns. Column A is list of webpage urls. Column B shows number of hits for each url in the list. All urls are not listed in every worksheet. I have 12 months of data & need to see if I can do a lookup or macro to search the worksheets, list all urls on one worksheet and display number of hits for each url for each month in a separate Column. Current worksheets look like this... Column A Column B URL 350 What I want to display would look like this... January 2008 February 2008 (etc. for each month) URL 350 275 -- JaeJ |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Combine Data from several worksheets
JaeJ wrote:
I'm a novice using Excel 2000. How do I combine data from several worksheets into one worksheet. Data is in 2 columns. Column A is list of webpage urls. Column B shows number of hits for each url in the list. All urls are not listed in every worksheet. I have 12 months of data & need to see if I can do a lookup or macro to search the worksheets, list all urls on one worksheet and display number of hits for each url for each month in a separate Column. Current worksheets look like this... Column A Column B URL 350 What I want to display would look like this... January 2008 February 2008 (etc. for each month) URL 350 275 I imagine there are several ways to do this but a very non technical way would be to add two helper cols in each sheet for Month and Year. Simply copy it down each column. You can then cut and paste each of the sheets into one sheet, sort by URL then year then month. Once you have the data in one sheet you could also use a pivot table. gls858 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two worksheets, combine (merge data) | Excel Discussion (Misc queries) | |||
How do I combine data from 4 worksheets? | Excel Worksheet Functions | |||
Can you combine data from 2 worksheets into 1 chart? | Charts and Charting in Excel | |||
Any way besides cut/paste to combine data in many worksheets (sam. | Excel Discussion (Misc queries) | |||
Combine Data from 2 worksheets | Excel Discussion (Misc queries) |