Unanswered: Reference Last Data Cells in Columns in another Workbook
I have a monthly Excel report I'll call "Report" that I want to reference cells in another workbook "ExternalWB". ExternalWB will have data added to it each month and the current month row is the last data row of Sheet1. There are several cells in Report, Sheet1 tab, that I want to reference the very last data row for columns C, D, E, F in ExternalWB.
I need help with a formula and/or technique to do this.
=countif(C:C,">0") will give a number of cell that are not blank
then we can do a =Index(C:C,countif(C:C,">0"),0)
ill also used the Offset() but that a bit hard to explan
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.