Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using autofilter to ADD data not delete data
Hello This forum has been a great help to me and i have learned a whole bunch and recently learned how to write VBA code for an autofilter array to delete things out of my spreadsheet. Now I want to add things to my spreadsheet with the same function. Basically filter one column for some critieria that would only pop up in the first row and then copy that criteria down until it's the end of my data. However i would be doing this for multiple spreadsheets and the "end range" will change. So is it possible to write the VBA so it stops copying when it recognizes there is no more data to the left/right of it? Any help would be greatly appreciated. Let me know if i need to supply any of my code. Thanks Jim -- jim_0068 ------------------------------------------------------------------------ jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822 View this thread: http://www.excelforum.com/showthread...hreadid=534251 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using autofilter to ADD data not delete data
Still looking for help on this one. -- jim_0068 ------------------------------------------------------------------------ jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822 View this thread: http://www.excelforum.com/showthread...hreadid=534251 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
new data with autofilter on | Excel Worksheet Functions | |||
using autofilter data | Excel Worksheet Functions | |||
Excel - data autofilter, then data sort how do you view all | Excel Discussion (Misc queries) | |||
If data is returned then delete data | Excel Worksheet Functions |