Extract date-based data; from single rows w/ date range to multiple rows w/ single dates

**QuiXver87** · 04-06-2016, 05:46 AM

Hi, appreciate if anyone can give some advise on this. Have searched the web but to no avail.
I have attached a sample of the raw data and desired outcome.

Hope this is feasible; preferably with use of formulas, but welcome VBA too.
Thanks.

**JohnTopley** · 04-06-2016, 07:02 AM

VBA solution

Please Login or Register  to view this content.

Extract date-based data; from single rows w/ date range to multiple rows w/ single dates

LinkBack

Thread Tools

Rate This Thread

Display

Extract date-based data; from single rows w/ date range to multiple rows w/ single dates

Re: Extract date-based data; from single rows w/ date range to multiple rows w/ single dat

Thread Information

Users Browsing this Thread

Similar Threads

Extract values from a range based on a single criteria and display in a single list

[SOLVED] Need a formula to sum for a date with multiple rows into a single row

Select multiple rows and cells based on a single date

Lookup values in multiple columns based on a date range, return single value per criteria

Indexing Data From a Single Row into Multiple Rows Based a Number of Columns

[SOLVED] Date Filter based on Cell Input - single date or range of dates

Delete multiple rows of data based on criteria in a single cell

Bookmarks

Bookmarks

Posting Permissions