dear all,
I was struggling with some data extraction and would like to seek every pros help in here.
My data contains some logos in column B (coming with numbers i.e 190, 197, 590) and sales record ($).
I would like to copy, say, when the logo meets with the number 190, i would like to copy all the below sales records until they is no more blank cells below.
Would that be difficult?
Thanks for all help in advance!
Last edited by nch1107; 06-06-2012 at 10:36 PM.
After copying What to do?
after copying I would need the data transferring to a new sheet.
anyone able to help on this?
Pl see the attached file with macro.
The text entered is searched in worksheet and respective region is copied.
Re: Copying all sales record below when meeting certain criteria until the next criteria
thanks mate, i saw the input box but there appears nothing after typing e.g. GO: 190
can you please elaborate a bit on the search criteria? Thanks a lot!
I got a single entry when I used one criteria to search and when I typed enter it listed out the result, but is it possible to copy all the results related to that criteria? because there would be 30 days for one of my excelsheet. thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks