VBA code Error: find the records that match the criteria in a specified cell and copy

Thank you, fortis!!! for guiding me on this board..

Originally Posted by xlbiznes

Post a sample sheet with your code.

Pls find the code that i just try to modified.I'm struggling to find the attachment icon to attach my real sheet, could you guide me...this is my first post

Please Login or Register  to view this content.

Pls find the sheet in attachment

The pro is in column 3, not 1.

Please Login or Register  to view this content.

AB33, I tried as you suggested, but have same issue. the code seems to run but unable to do the work of pulling the data of that reference column through the cell. however, i'm sending you that same sheet with the suggested modifications, and run the code from its sheet2 instead of thisworkbook sheet in VBA writing panel.

Pls find the attachment for the file once again..

Thank you for the efforts...

Please Login or Register  to view this content.

Hi,

The problem is still not resolved, i just modified the code and tried but not solved it. could you pls look into this issue..

the vba code is as below:


Pls find the file copy in attachment...

Thank you for the efforts...

Please Login or Register  to view this content.

Ab33,

Are you able to run the program? pls send me the copy of the file..

Yes, I can.
I am not sure in which line of column AA you want to start copying in to. I have two codes. The first code follows your code, i.e. In to next empty row plus 3, but the problem with the code is that the code jumps 3 times every time it copies.
The second code copies in to next empty row starting at row 22. You can change the starting row from 22 to what ever number you wish.

AB33, Thanks for your efforts, however, I'm getting the error: Run-time error '1004': Application-defined or object-defined error.

Abb, pls look into this error, i maybe missing any variable defining in this code... we reach some extent to this solution.. your code is atleast selecting the drop down value row.. but not able to copy because of the application defined error.
I hope you may resolve this... Thank you once again for your nice work..


pls test it once again the below code:

Please Login or Register  to view this content.

Originally Posted by AB33

Yes, I can.
I am not sure in which line of column AA you want to start copying in to. I have two codes. The first code follows your code, i.e. In to next empty row plus 3, but the problem with the code is that the code jumps 3 times every time it copies.
The second code copies in to next empty row starting at row 22. You can change the starting row from 22 to what ever number you wish.

meer ali,

You must have changed the variables. I do not normally use integer as a variable.
Where is the error on the attached? Could you please attach the sample with the code you are getting the error on?

Great work AB33!!!! Thank you for your Generous efforts... But the 2nd code finddata1() is not working, it shows the error as: "variable not defined"... however, pls find the attached file in attachments & code within it.

Please Login or Register  to view this content.

"variable not defined"...
Because you have changed the variables.
If you have Option Explicit at the top, all variables used in the code ought to be defined, otherwise you get an error.

I have just added NR to the dim statement.

Please Login or Register  to view this content.

I'm trying one more for inventory, just coded the userform, but have some errors in it..

ABB, can we put the hyperlink into the userform window, so that when press a button say "browse" then a new window will come up and attach a file into it and and when click update, the data normally saved into the sheet as a excel record and the photo path is saved as hyperlink. when clicked on that link the photo will be pulled from the path from where it is stored.