| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data from worksheet in folder a to worksheet in folder b
I'm sure this would take VBA but I need to copy the values in cells B1, D1,
K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Hi drose
You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Thanks Ron de Bruin,
I got the macro to run and copy the data over but only if I selected the folder and then the worksheet to be copied. Is there a way that the macro would detect whenever a new worksheet is added to this folder and then would copy only from the new worksheet? Thanks, Drose "Ron de Bruin" wrote: Hi drose You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Hi drose
It is possible to do this You can adapt example 2 on the same page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... Thanks Ron de Bruin, I got the macro to run and copy the data over but only if I selected the folder and then the worksheet to be copied. Is there a way that the macro would detect whenever a new worksheet is added to this folder and then would copy only from the new worksheet? Thanks, Drose "Ron de Bruin" wrote: Hi drose You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Hi Ron de Bruin
I just learning VBA so I'm sure it's me. I am using the example 2 and I can get it to copy what I need but only if when I run the macro, I select the folder and then the work book to be coppied. Can I have it when I select run... go find the Folder and search for new workbook and if found then copy automatically to summary worksheet? If this is in example 2 please let me know where so I can try and see what I'm doing wrong. Once I get this working the other thing I need is for it to copy data from 15 work books and then skip 5 rows and copy the next 15 work books etc... The 5 rows skipped have formulas in them to calculate mean, Std. Dev., etc. Thanks so much for all your help, Drose "Ron de Bruin" wrote: Hi drose It is possible to do this You can adapt example 2 on the same page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... Thanks Ron de Bruin, I got the macro to run and copy the data over but only if I selected the folder and then the worksheet to be copied. Is there a way that the macro would detect whenever a new worksheet is added to this folder and then would copy only from the new worksheet? Thanks, Drose "Ron de Bruin" wrote: Hi drose You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Hi Ron de Buin,
I actually now realize that what I should of been saying is that I need to copy from workbooks in a folder that are used as forms with data on them in the cells mentioned and copy these cells to a summary workbook. Any help with code would be greatly appreciated. Thanks, drose "Ron de Bruin" wrote: Hi drose It is possible to do this You can adapt example 2 on the same page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... Thanks Ron de Bruin, I got the macro to run and copy the data over but only if I selected the folder and then the worksheet to be copied. Is there a way that the macro would detect whenever a new worksheet is added to this folder and then would copy only from the new worksheet? Thanks, Drose "Ron de Bruin" wrote: Hi drose You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy data from worksheet in folder a to worksheet in folder b
Hi Drose
Yes it is possible what you want but I have no time on this moment to change the macro for you. I flag this thread and try to get back to you next week(end) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... Hi Ron de Buin, I actually now realize that what I should of been saying is that I need to copy from workbooks in a folder that are used as forms with data on them in the cells mentioned and copy these cells to a summary workbook. Any help with code would be greatly appreciated. Thanks, drose "Ron de Bruin" wrote: Hi drose It is possible to do this You can adapt example 2 on the same page -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... Thanks Ron de Bruin, I got the macro to run and copy the data over but only if I selected the folder and then the worksheet to be copied. Is there a way that the macro would detect whenever a new worksheet is added to this folder and then would copy only from the new worksheet? Thanks, Drose "Ron de Bruin" wrote: Hi drose You can start with this macro that create links for you http://www.rondebruin.nl/summary2.htm If you want to do it for all worksheets in each workbook post back -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "drose" wrote in message ... I'm sure this would take VBA but I need to copy the values in cells B1, D1, K1, D4, E4, F4, I4, J4, K4 for each worksheet put into folder A to a worksheet (column A through I) in Folder B. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get data from all workbooks in a folder. Paste into my worksheet. | Excel Programming | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
| Check if folder exists, if yes just copy sheet in to folder? | Excel Programming | |||
| How to save a single worksheet as worksheet name in new folder?? | Excel Programming | |||
| Create Folder / Copy Folder / Replace | Excel Programming | |||
Linear Mode
