I have 2 sheets
First one has the source ISBN numbers for books. It is only 1 column say column A and say 40 rows
The second sheet is the destination sheet where macro supposed to look for the data located on A2 on the source file in the destination sheet.
Once it locates this value in the destination sheet it supposed to move 2 columns to the right and add "1" to the end of the text in this cell.
Since there are several rows(40) I guess it needs to be loop.
Please help
Thanks
couldnt if(countif>0) not work?
if not supply sample data
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
nmdgfsdfsdfsdfd
Last edited by misterno; 05-25-2015 at 09:41 PM.
Below is the source file where all data is located in the A column. Macro supposed to pick each cell one by one and look it up in the following file named destaination file
source file.JPG
below is the destination file where macro supposed to look up for the value located in A1 of the previous file, then move 2 columns right and add "1" at the end of the text in the cell.
I guess I need a loop because there are more than 40 values in the first file
destination file.JPG
still looks like you can achieve this with normal vlookup formula
But there are more than 40 values in the source dataOriginally Posted by humdingaling
You don't expect me to have 40 vlookups do you?
I don't know how to do loops
still not sure why you think it is so complicated you require loops to achieve what you are doing
unless your data setup isnt how i imagine you would set things up but to avoid misinterpretation Attach a sample workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
ps even if you require loops you would need to provide sample workbook in order for some one to advise you how to code it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks