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
Hyperlink in excel to another worksheet - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - 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

Automatically transfer data from one sheet to another

Copy Worksheet to another Workbook (unopened)

Excel Macro - Set and autofill a range?

Copy range data in a column to new column.

Similar discussions

Subscribe To Our Newsletter!