Ask Your Question

how can I make a pivot table with data from several sheets ? [closed]

asked 2012-04-19 22:58:23 +0200

anonymous user


updated 2013-10-21 22:16:26 +0200

manj_k gravatar image

I have a spreadsheet with a sheet per calendar month , I need to make a pivot table with the data of the 12 sheets .How can I do ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 15:01:44.264160

1 Answer

Sort by » oldest newest most voted

answered 2012-04-26 02:38:30 +0200

mahfiaz gravatar image

You could always reference all the data from one page to gather it together.

Worksheet functions such as INDEX, VLOOKUP, HLOOKUP, MATCH, OFFSET are usually helpful in similar cases.

edit flag offensive delete link more

Question Tools


Asked: 2012-04-19 22:58:23 +0200

Seen: 2,020 times

Last updated: Feb 26 '14