Microsoft Office Forums - View Single Post - [Solved] Comparing between 2 worksheets and retreiving data if a match

Thread: [Solved] Comparing between 2 worksheets and retreiving data if a match

View Single Post

Old

02-16-2017, 10:57 AM

FUGMAN

FUGMAN is offline

FUGMAN uses Windows 10

Windows 10 FUGMAN uses Office 2016

FUGMAN uses Office 2016

Office 2016

Banned

The original poster

Join Date: Feb 2017

Posts: 55

FUGMAN is on a distinguished road

Default

NoSparks

Thank you for your reply.
I tried the macro with the following results.
fndLastName.Offset(0, 1).Resize(1, 19).Copy Sheets("Input Data").Range("H1")Run time errorSubscript out of range

Reply With Quote