how to combine........

[Guest]

hiiiiiiiii friends how are u ........ hope u all doing well.
i have been working in an organization and i keep the data in different
worsheet for each month and name them with the concern month such for january
i have january Excel worksheet; but sometime my boss wants me to give him the
Sale report for a specific months such as january , febuary , march and
april. so i copy and past in a new worksheet. i need how to combine many
excel worksheet data in one worksheet without copying and pasting...
thankx in advance.

 

[Guest]

Hi,

First insert a new sheet and select cell A1. Go to the menu: Data -
Consolidate. Then go to the January sheet. Select the data by clicking on
the grey letters like A, B, C. The selection will be shown in the reference
cell. Add it. Then go to the February sheet. Add it. Like that you can
select the sheets required and add. Use labels as per your data like top
rows or left columns. Say OK. You can create a link also to source data, if
you check it.