Macro - Taking the value of a cell and finding it on another sheet

**mrrobward** · 04-25-2012, 09:56 AM

Hi,

I have searched Google but cannot locate an answer.

I have a workbook, one worksheet has "house numbers" which are for example 1550 - This would change each day
I need the macro to look in cell A7 to take the value (whatever it may be) and find it on the other worksheet, and then copy and paste values in cell A8/A9/A10 into worksheet 2

I would need this to repeat on the next row untill no further data.

Any ideas?

Please Login or Register  to view this content.

**royUK** · 04-25-2012, 10:00 AM

Please use Code tags not Quote tags, I've changed them this time.

**royUK** · 04-25-2012, 10:07 AM

It depends how the data is laid out but you should be able to use VLOOKUP

**aldek** · 04-27-2012, 03:40 PM

I am looking for an answer to this question too. Vlookup is great for a handful of items or for a few columns, but with hundreds of columns and thousands of rows, this is far too complicated. Thanks!

**AlvaroSiza** · 04-27-2012, 04:23 PM

See attached and respond with results. Obviously this is just a small sample from what I could take from your original post. It was not clear to me how the data was aligned on the DPS List worksheet, as you specified that you wanted the data from RR to populate A8:A10, but then continue on until no data. I made the assumption that the RR data to be grabbed is aligned horizontally, and that you also wanted it horizontal after moving to "List". We can revise it if I'm wrong.

DPSRRToList.xlsm

Please Login or Register  to view this content.

**mrrobward** · 07-09-2012, 11:11 AM

AlvraSiza, this is EXCATLY what I need. Just need to add a little more complex to it.

I've attached the document (minus personal details)

Basically, I need to take the infomation from DPS RR to DPS List and update - There will be duplicates on DPS RR but they will be placed, going downwards in date order so at the end, is the most recent changes. I need to take the value on column A on DPS RR and find on DPS list and update with the information from DPS RR in columns F & G & H & I and then repeat untill no further data exsists.