Getting value error in this macro where I didn't before and I don't know how to fix it. The way the macro works is it takes the info from the data page and distributes it onto the sheets corresponding to the info in the input tables. however I am getting a code 13 error and I can't deduce the issue. PROJECT2.xlsm
Hi, sephus730,
trouble arised with sample when trying to compare Sheet 2 as Range A1 on that sheet is empty while it should show 2 for letting the formulas get the data from Sheet Input Tables. This should be the same for the other sheets as well as only Sheet 1 Range A1 was filled. Please amend the numbers for the VLookup and run your macro again.
Ciao,
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