Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am trying to create a macro that will compare the data in Cells A through D on two different sheets. Then post the results on a third page. The problem I am haveing is that there will be blanks on both reports that can not be deleted. For instance on sheet 1 column A3 and A4 maybe blank but they are assinged to the DATA in B3 and B4. But sheet 2 has values for this. I have tried the VLOOP function and that does not seem to be working the way I need it too. I have tried many different ways and seem to be getting no where. I have been working on this project for about a year and I have scrapped aleast 20 different concepts. I am running out of paitence. Any Help would be greatly appreciated. *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COMPARING TWO COLUMNS OF INFORMATION, ACROSS TWO WORKSHEETS | Excel Worksheet Functions | |||
Comparing columns from 2 different worksheets. | Excel Worksheet Functions | |||
Comparing columns in 2 different worksheets, IF Function | Excel Worksheet Functions | |||
Comparing two worksheets with two columns each for duplicates | Excel Discussion (Misc queries) | |||
Comparing two columns in two different worksheets | Excel Worksheet Functions |