| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding rows of different info from separate worksheets into summar
I have 12 monthly worksheets of catalogue item information on rows. I want to
build a summary worksheet that summarizes one of the columns (qty sold) by month. Problem is, when I run my VLookup to find the cat.#, invariably the catalogue has changed from month to month and returns incomplete information. how can I build my catalogue list in the summary worksheet from the associated monthly worksheets and get all of the cat.#'s that have come and gone through out the year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Adjusting # of rows between 2 worksheets | Excel Worksheet Functions | |||
| Auto adjusting # rows between 2 worksheets | New Users to Excel | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Adding rows to an array | Excel Worksheet Functions | |||
Threaded Mode
