Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup across multiple worksheets
I have been supplied with multiple worksheets containing data that I would
like to pull together. New to Excel I'm not sure whether this can be easily achieved, whether Vlookup is the correct function or a macro would be required - any suggested solutions would be gratefully received. Each worksheet simply contains a list of names in column A with a Y/N value in Column B e.g. users who like Apples. The supplied worksheets however contain different numbers of users/rows ranging from 10 to 1000. I wish to create a "master" spreadsheet which lists a Y/N value against each user's name for the column heading i.e fruit identified in subsequent columns. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup across multiple worksheets
Can't you just <copy the data from the second and subsequent sheets
and <paste that data at the bottom of the data in Sheet1 to end up with contiguous data in Sheet1? You can then delete all the other sheets and then have a formula like this in C1: =COUNTIF(B:B,"y") to count all the Y entries in column B. Hope this helps. Pete On Apr 27, 10:26*am, Rich$r wrote: I have been supplied with multiple worksheets containing data that I would like to pull together. New to Excel I'm not sure whether this can be easily achieved, whether Vlookup is the correct function or a macro would be required - any suggested solutions would be gratefully received. Each worksheet simply contains a list of names in column A with a Y/N value in Column B e.g. users who like Apples. The supplied worksheets however contain different numbers of users/rows ranging from 10 to 1000. I wish to create a "master" spreadsheet which lists a Y/N value against each user's name for the column heading i.e fruit identified in subsequent columns. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup across multiple worksheets
Rich$r,
Read "Data across multiple worksheets" at http://www.smokeylake.com/excel/excel_truths.htm. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Rich$r" wrote in message ... I have been supplied with multiple worksheets containing data that I would like to pull together. New to Excel I'm not sure whether this can be easily achieved, whether Vlookup is the correct function or a macro would be required - any suggested solutions would be gratefully received. Each worksheet simply contains a list of names in column A with a Y/N value in Column B e.g. users who like Apples. The supplied worksheets however contain different numbers of users/rows ranging from 10 to 1000. I wish to create a "master" spreadsheet which lists a Y/N value against each user's name for the column heading i.e fruit identified in subsequent columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup on multiple worksheets? | Excel Discussion (Misc queries) | |||
Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
VLOOKUP on multiple worksheets | Excel Discussion (Misc queries) | |||
Vlookup multiple worksheets | Excel Discussion (Misc queries) | |||
vlookup multiple worksheets | Excel Worksheet Functions |