Hello,
How do I reference a sheet with spaces titled "enter data" , specifically cell h2 ? I will be deleting rows from the enter data sheet so this is why I need to use indirect. Below is the formula I am using now and it works fine but not when I delete rows from the enter data sheet.
='enter data'!H2
I tried =indirect('enter data'!H2) but this does not work
Hi there,
I think you need:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
Or
which is non volatile.Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Trevor's solution is a much better proposition
WBD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks