Vlookup Macro

**vijanand1279** · 01-05-2011, 12:10 PM

I am looking for a Vlookup macro between two sheets. But every time the rows in sheet 2 will differ. So looking for a vlookup with dynamic range...

Regards,
Vijay

**Richard Buttrey** · 01-05-2011, 12:12 PM

Hi,

In the Excel Application create a dynamic range name for the rows. See here http://www.contextures.com/xlnames01.html#Dynamic if you need help to do this.

Then just use the dynamic range name in your macro code.

Regards

**vijanand1279** · 01-05-2011, 12:23 PM

Hi,

I am looking for a macro to copy and paste the formula till the last row.
I am trying to concatenate column and A and B and the formula entered in column C should get copied and pasted till the last row in column B.

Regards,
Vijay

**Richard Buttrey** · 01-05-2011, 01:15 PM

Hi,

Untested but

Please Login or Register  to view this content.

Change the sheet ref as appropriate.

Please note that this is nothing to do with a VLOOKUP. Your original post didn't describe the actual requirement.

Rgds

**Cutter** · 01-05-2011, 01:16 PM

Duplicate post:

http://www.excelforum.com/excel-gene...-last-row.html

**vijanand1279** · 01-05-2011, 01:31 PM

The formula on the Column C is copied and pasted only the last row but not on all the rows untill last rows.

[SOLVED]

**Richard Buttrey** · 01-05-2011, 01:43 PM

Hi,

That's exactly what my solution does.

If you think any different then please upload an example workbook showing a before and after position which shows exactly what you want, otherwise we are destined to go round in circles.

Rgds

**royUK** · 01-05-2011, 01:44 PM

Will you read the Forum Rules

**vijanand1279** · 01-06-2011, 10:49 AM

Originally Posted by Richard Buttrey

Hi,

Untested but

Please Login or Register  to view this content.

Change the sheet ref as appropriate.

Please note that this is nothing to do with a VLOOKUP. Your original post didn't describe the actual requirement.

Rgds

Thank you. This helps

REgards,
Vijay