Return whole row depending if 1 cell is within date range

**rjwillshear** · 11-02-2018, 02:59 PM

Hi everyone,

I have inherited a truly awful system in work so am trying to come up with a replacement despite my limited knowledge.
The attached image is a spreadsheet I have made to log equipment and associated costs per job.

On one tab will be a continuous log of all the records for the year. On another tab, rows from a specific date range that I want to autofill from the continuous log.

I have been able to make a formula that identifies if a date falls between the date range, but I am useless at getting it to return a whole row of data.

Can anyone help?

Thanks in advance

Untitled.png

**JeteMc** · 11-09-2018, 11:10 AM

Hello rjwillshear and Welcome to Excel Forum.
It might help us, in our efforts to help you, if you could upload the workbook from which the screen shot in post #1 is taken.
To upload a workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to desensitize the data.
Let us know if you have any questions.

Return whole row depending if 1 cell is within date range

LinkBack

Thread Tools

Rate This Thread

Display

Return whole row depending if 1 cell is within date range

Re: Return whole row depending if 1 cell is within date range

Thread Information

Users Browsing this Thread

Similar Threads

return value if date is between two other dates, depending on the year of another cell

[SOLVED] return value if date is between two other dates, depending on the year of another cell

[SOLVED] Return date depending on day of month

[SOLVED] reference date time range, return the value into all cell that match datetime range

[SOLVED] Return a number depending on the date in another cell

return cell depending on date

Formula needed: Return cell value in a range depending on other cell values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions