detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
I have a workbook with two sheets: [Lead Template] and [CSV]
I need to reference [Lead Template] cells onto [CSV] for all populated rows and columns on [Lead Template]
I am using this formula on [CSV] and I can copy it down and across but that would bloat my file
I feel like something like this might work but I'm not quite sure how to bring this all together
I'm hope to make this passive or when [CSV] is selected or has focus
I need to reference [Lead Template] cells onto [CSV] for all populated rows and columns on [Lead Template]
I am using this formula on [CSV] and I can copy it down and across but that would bloat my file
Excel Formula:
=IF(ISBLANK('Lead Template'!A1),"",'Lead Template'!A1)
I feel like something like this might work but I'm not quite sure how to bring this all together
I'm hope to make this passive or when [CSV] is selected or has focus
VBA Code:
lRow = Cells(Rows.Count, 1).End(xlUp).Row
lCol = Cells(1, Columns.Count).End(xlToLeft).Column
=IF(ISBLANK('Lead Template'!A1),"",'Lead Template'!A1)