Question

we cannot hard-code the cell

Answer 1

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.