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

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