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
Excel vba add worksheet - Guide
Grade formula in excel worksheet - Guide
How to automatically transfer data between sheets in Excel - Guide
Screenshot of excel worksheet - Guide

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

Copy range data in a column to new column.

Copy Worksheet to another Workbook (unopened)

Excel Macro/Code help: Creating sheet for each name in column of another sheet

range of numbers

Similar discussions

Subscribe To Our Newsletter!