| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compile list of same cell from multiple worksheets
I need to extract data from (for example) C2 in numerous worksheets in the
same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#2
|
|||
|
|||
|
Hi
see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#3
|
|||
|
|||
|
Thank you, I have no knowledge of VB I have saved your links and was
wondering if you have any other links/sites that would be helpful for learning VB. PCakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#4
|
|||
|
|||
|
Hi
Start here http://www.mvps.org/dmcritchie/excel/getstarted.htm Download my Google Search add-in There is also a list with favorite websites in the add-in http://www.rondebruin.nl/Google.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... Thank you, I have no knowledge of VB I have saved your links and was wondering if you have any other links/sites that would be helpful for learning VB. PCakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compile list of same cell from multiple worksheets
Ron,
Is this possible to do from several workbooks in a folder to a summary workbook? Interesting problems I have.... Pcakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compile list of same cell from multiple worksheets
Hi PCakes
See http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... Ron, Is this possible to do from several workbooks in a folder to a summary workbook? Interesting problems I have.... Pcakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compile list of same cell from multiple worksheets
Ron,
Thanks for the direction, this works great, however I need to do this but have several rows copies and placed by row in my summary. E.g. data from A31-M36 Is that possible to do with this macro? You have been so helpul! PCakes "Ron de Bruin" wrote: Hi PCakes See http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... Ron, Is this possible to do from several workbooks in a folder to a summary workbook? Interesting problems I have.... Pcakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compile list of same cell from multiple worksheets
Hi PCakes
See http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Pcakes" wrote in message ... Ron, Thanks for the direction, this works great, however I need to do this but have several rows copies and placed by row in my summary. E.g. data from A31-M36 Is that possible to do with this macro? You have been so helpul! PCakes "Ron de Bruin" wrote: Hi PCakes See http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... Ron, Is this possible to do from several workbooks in a folder to a summary workbook? Interesting problems I have.... Pcakes "Ron de Bruin" wrote: Hi see http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "PCakes" wrote in message ... I need to extract data from (for example) C2 in numerous worksheets in the same workbook and list them in a summary worksheet in Column A. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
| Is there a template to compile a list of users for multiple accou. | Excel Discussion (Misc queries) | |||
Linear Mode
