123.xlsxi am try create a macro to search a keyword and use number of cell data below the keyword as a range for autofill. Then search another keyword and autofill the data the keyword but autofill till the range u set it. i attach a example of it
Please Login or Register to view this content.
Last edited by chriskingkiller; 12-06-2013 at 08:34 PM.
Hi, chriskingkiller,
IŽd narrow the area to search down form all cells (which includes all those which are blanks) to ActiveSheet.UsedRange or any Column:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks