| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filer and Copy
I need to figure out how to filter and copy exactly (all formats) to another
ws within the same workbook. It also needs to know to paste it after the last row data (Which is basic statement that need to appear within the ws along withthe pasted data). The number of rows with change. However, I want to assign the macro to a button. So, everytime the original ws is update. THe user can initate macro via button to file in the page with information. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filer and Copy
Hi Curt
You can find a example here to start with http://www.rondebruin.nl/copy1.htm Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl "Curt" wrote in message ... I need to figure out how to filter and copy exactly (all formats) to another ws within the same workbook. It also needs to know to paste it after the last row data (Which is basic statement that need to appear within the ws along withthe pasted data). The number of rows with change. However, I want to assign the macro to a button. So, everytime the original ws is update. THe user can initate macro via button to file in the page with information. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filer and Copy
Hi Ron,
It's definitely a start. However, I need to filter by a specific criteria and copy only the rows that meet it. "Ron de Bruin" wrote: Hi Curt You can find a example here to start with http://www.rondebruin.nl/copy1.htm Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl "Curt" wrote in message ... I need to figure out how to filter and copy exactly (all formats) to another ws within the same workbook. It also needs to know to paste it after the last row data (Which is basic statement that need to appear within the ws along withthe pasted data). The number of rows with change. However, I want to assign the macro to a button. So, everytime the original ws is update. THe user can initate macro via button to file in the page with information. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filer and Copy
See
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Curt" wrote in message ... Hi Ron, It's definitely a start. However, I need to filter by a specific criteria and copy only the rows that meet it. "Ron de Bruin" wrote: Hi Curt You can find a example here to start with http://www.rondebruin.nl/copy1.htm Post back if you need more help -- Regards Ron de Bruin http://www.rondebruin.nl "Curt" wrote in message ... I need to figure out how to filter and copy exactly (all formats) to another ws within the same workbook. It also needs to know to paste it after the last row data (Which is basic statement that need to appear within the ws along withthe pasted data). The number of rows with change. However, I want to assign the macro to a button. So, everytime the original ws is update. THe user can initate macro via button to file in the page with information. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value from the top of an auto filer list. | Excel Discussion (Misc queries) | |||
| Filer rows in Excel | Excel Discussion (Misc queries) | |||
| Filer dates | Excel Discussion (Misc queries) | |||
| using filer command in excell it locks up my computer | Excel Worksheet Functions | |||
| Filer within Pivot Table | Excel Discussion (Misc queries) | |||
Hybrid Mode
