Hi All,
I have a named range ("Priority") which sits in cells K10:K21.
Of these 12 cells I need to know how many are used so that I can set that value as how many times I paste the "EEName" from this sheet to another sheet.
So if there are 6 lines filled out in "Priority" I need to copy "EEName", move to the Submissions tab, and paste the EEName 6 times into the next available cell in column A.
The closest I think I can get is without using the named range.
When I finally find that value I think I can use this to paste it:![]()
Please Login or Register to view this content.
Anyone know how to finish what I started?![]()
Please Login or Register to view this content.
Thanks in advance... unfortunately I can't upload anything from work. Total lockdown.
Bookmarks