If last cell in column A is Greater than column B Then Offset Column A

Hi Again,

I have a spreadsheet that does a lot of offsetting and removing if certain criteria is not met and I have a summary macro that runs along the bottom of the spreadsheet.

The issue I am having is that the summary should offset by two rows to the last cell of column D or column G dependent on which is the lowest cell row in mentioned columns.

For example if the last cell in column G is in a lower row than the last cell in Column D then offset the summary of Column G and vice versa.

I have looked around but I can't seem to find anything so I can't supply a starting code, sorry.

Does anyone have a suggestion?

A sample workbook is the best option here, can you provide a copy

Hi nigelog,

Unfortunately I can't as it is a huge workbook and has a lot of confidential information. I can supply screenshots of the different scenarios though?

Does this help?

Special Instruction Summary should offset from column D

Capture1.JPG

Special Instruction Summary should offset from column G

Capture2.JPG

Hi,

I think I have found the solution from Ron de Bruin if anyone is interested

Please Login or Register  to view this content.

Please Login or Register  to view this content.

https://www.rondebruin.nl/win/s9/win005.htm