Spreadsheet Number 1. I have the sheet set up but I my OFFSET formula is not working correctly. The spreadsheet has a master sheet that collects data into one sheet that is easily analyzed. The bulk of the data is pulled straight from the one worksheet but I need to be able to pull in every other row for one data set - then I need to pull in the same row for data that matches the dates on the row above but has corresponding data in the row below starting in column Y that needs to pull into the master sheet and the dates need to line up.
- EXAMPLE DOC: 11-20-2018 WCHS 51790 REVMAN - need to pull data rows in the data tab into the Master Review sheet - the offset formula comes in as I need date from every other row starting on column Y but it needs to match up with the date and DOW...etc data in the previous row.
For that same spreadsheet - I need to pull in day by day data from multiple sheets from a horizontal format to a vertical format. - November tab) I need row 13 to pull into the Master Review tab to match up with the dates in a vertical format on the Master Review Tab. This one also needs to start pulling data from the date that I am starting with defined by the beginning date on the data tab - so in the example it would be starting to pull data from row 13 beginning on 11/20 - this report will only pull for a monthly window and I do not want data from past dates to come into the master tab.
Next spreadsheet - I have a crazy ugly report that when pasted into a "converter is supposed to produced a clean version with raw data that can be used to create further analysis with Pivots or graphs. The VBA in the converter is giving me a runtime error 91 Object variable with block variable not set and I do not know how to fix it. When i hit debug - I get this " intColRoomType = [login to view URL]" - Guest List Converter file and Arrivals by date taken - arrivals by date taken is the file that is pasted onto sheet2 of the guest list converter.
Next - I have a spreadsheet that I paste into a workbook that has variable columns with merged headers that often end up in different columns each time the original report is pulled - I am looking to find a formula that would find specific column headers and pull data from the subsequent rows regardless of column location - also -needs to work if a column is not present in that particular run of the report. -11-20-2018 QIBO NC790 RevMan - TTL7DV Tab Data into Segment 7DV Tab tab - there are many times when there are many more columns - with market segments and for each market segment there is current column and a change column and then to the far right in the green area - there is a new section called ADR OTB that correlates with each segment and has a current and a change column - all of that data needs to pull into the Segment 7DV tab properly
Next I would like to be able to easily send the master data sheet only as an email attachment without having to copy the sheet and save it as a new workbook each time. 11-20-QIBO NC790 Revman - Master Review Tab - that is the one that I would like to be able to email with just one or two clicks