I am trying to do a sheet clean and would like column a in sheet "inp" to drive a vlookup to column b in sheet "inp" with all data driven from sheet "m" referenceing a2:h650. can someone help? ive already got the vlookup working successfully just want to clean it up a bit
Attach a sample workbook (not a picture or pasted copy). 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 then scroll down to Manage Attachments to open the upload window.
If posting code please use code tags, see here.
Thsnk youfor your response. Im enclosing a snippet using genrci data. i need the vba to do vlookup for a long range of data
How about
Please Login or Register to view this content.
thank you very much. is there a way to make it work without clicking a button however? just as info is posted into column a?
How are the values getting into column A?
is it via formula,manually entered, pasted in ?
Another one
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
If you want to activate the macro when entering data in column "A" in sheet "inp" then in sheet's code put
Please Login or Register to view this content.
To close the loop put next macros in sheet 'inp" code, it will prepare the data when openning the tab and refresh when new value in column "A"
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks