Hello,
I have a data sheet having about 50000 rows. Sheet 1-Column 'A' have invoice numbers. Invoice numbers are duplicated for different material in invoice populated in Sheet1 -column 'B'. Please help me writing a VBA function for extracting data from sheet1 column 'A' based on 10 different invoice numbers in sheet2-column 'A'.
I am no good with VBA. However, it would be a help to others if you supplied us with a SAMPLE sheet - NOT 50,000 rows, however.
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks ! I am enclosing the sample data file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks