VLOOKUP in other worksheet (date)

Solved/Closed

carman - Aug 12, 2010 at 04:18 AM
carman - Aug 13, 2010 at 12:58 AM

Hello,
Attached please find the reference file.

https://authentification.site/files/23765947/sort.xls

I am doing a VLOOKUP from sheet 1 to sheet 4 using MACRO to find the date. However some of the data (mostly at the bottom) cannot be shown. What can i do to fix it?

Please help.

VLOOKUP in other worksheet (date)
Transfer data from one excel worksheet to another automatically - Guide
How do you add a username or author to a worksheet - Guide
Automatically run a macro when opening a worksheet - Guide
Vlookup if cell contains partial text - Office Software Forum
Copy worksheet multiple times and rename ✓ - Excel Forum

1 response

Answer 1 / 1

carman
Aug 13, 2010 at 12:58 AM

i found the answer for that, i forget to use absolute value in the range.
Thanks.

Similar discussions

How to specify macro for current active sheet

Comparing columns and returning value

Match partial text string in one sheet to another text string in another sheet

Using Vlookup to return insted of 00/01/1900

Automatically transfer data from one sheet to another

Similar discussions

Subscribe To Our Newsletter!