I have a spread sheet that I need to select a range of cells The goal is to create this selection based on the the last position of data on the first column, I now how to do this with rows but unable to to do this with this situation.
Thanks Please let me know if you need futher clarification.
Please a see the table below.
J K L M N
Symbol Company Name Last High Low Volume High Low
lwin
lwin THIS IS THE AREA NEED TO SELECT THE SELECTION SHOULD START K3 & END ON COLUMN Z BASED ON THE LAST CELL REFERENCE THAT HAS DATA FROM COLUMN J , THIS WILL CHANGE EVERY DAY.
lwin
lwin
lwin
lwin
lwin
lwin
LAST CELL REF
Thanks Please let me know if you need futher clarification.
Please a see the table below.
J K L M N
Symbol Company Name Last High Low Volume High Low
lwin
lwin THIS IS THE AREA NEED TO SELECT THE SELECTION SHOULD START K3 & END ON COLUMN Z BASED ON THE LAST CELL REFERENCE THAT HAS DATA FROM COLUMN J , THIS WILL CHANGE EVERY DAY.
lwin
lwin
lwin
lwin
lwin
lwin
LAST CELL REF