we cannot hard-code the cell
Answers
Answer:
Log in Sign up
By using our site, you acknowledge that you have read and understand our Cookie Policy, Privacy Policy, and our Terms of Service.
Home
PUBLIC
Stack Overflow
Tags
Users
FIND A JOB
Jobs
Companies
TEAMS
What’s this?
Free 30 Day Trial
How to change these hard-coded cell references to dynamic references?
Ask Question
Asked 2 years, 6 months ago
Active 2 years, 6 months ago
Viewed 202 times
0
I have this spreadsheet:

and I have the following formula, which gets me exactly the results I need:

The problem I have is with the cell references being hard coded. I need it all to be dynamic, because the information I'm targeting is based on the date. Today I need the information in rows 23-28. tomorrow it could be rows 5-10 or rows 30-40.
How can I look through the entire column A to find today's date, and then display only the rows of information pertaining to that date? I can do it with hard-coded row numbers, but I can't figure out how to do this with dynamic row numbers.
It simply means using specific figures or amounts in an Excel formula rather using referenced or calculated values. The easiest example to demonstrate hard coding is using a simple Sales Tax calculation.