|
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? |
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? |
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? |
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? |
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com