In the example I have a 2 column reference where data in column E is correlated to column F. I need the data in Column F to show up anytime data from Column E is entered in a separate worksheet if possible.
Is it possible to enter data in Column A of Sheet 1 that pulls the correlated data from column B in reference Sheet 2 and enters it into Column B of Sheet 1?
I tried using a simple function in a single sheet but it obviously doesn't do what I need, it just continues as a list.
Last edited by jorricha; 08-04-2018 at 12:38 PM. Reason: I figured out the excel formula but now looking for VBA
Just checking that it is a VBA solution you want, not a formula?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
VBA would be better but a function would work. Just looking for functionality. I don't have a copy of the sheet as Im not at work, but currently uses a macro that takes data from certain columns and pastes it in the correct columns. However, there is not a reference in that data for one of the columns. So If I create a 2 column reference that will have a few thousand rows, I just want to be able to have column b of the reference post to column b of the working sheet when column a of reference sheet is entered into column A of working sheet. Column A=Plan ID Column B=Plan Description for example. Sorry for the long reply.
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 I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks for the rep!
How about a sample book?
I attached to my original post, workbook2, i figured out the excel function, just sorta looking for a VBA way.
I can't open the file, it says "invalid extension"
Uploaded xls, try that 1
Put this code in your sheet1 module:
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