I need help with a few spreadsheets - one is a VBA code that seems incorrect - one is an offset fromula that is not cooperating , one is possibly solved by a VLOOKUP but I want to be certain - another is to email a single sheet from a wkbk
$15-25 USD / hour
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
Project ID: #18206638
About the project
Awarded to:
Hello, Hope you are doing well. I can help you in your project with offset, Vlookup and mail can be sent automatically through outlook or directly from webmail About me & what I can provide - • 5 Yrs. of Experienc More
18 freelancers are bidding on average $19/hour for this job
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
MBA accounts and finance. phd in statistics and economics having seven years of experience in Excel development. Excel vba and macros.
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S More
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com More
I have extensive experience in VBA. I am professional in excel , excel formulas and VBA to automate the process. I am highly experienced in pulling data from DB , WEB or from Web Api to excel or any other format like More
Computer Engineer with 5 years of professional Excel/Access/Outlook VBA experience doing projects for co-workers who have zero VBA Experience I can create a macro within Excel to create the Outlook email I'm a fu More
.......................................................................................................................................................................................................................... More
HI I am Xpert P. I am senior Developer and I am Expert in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. I have completed 200+ based projects in programming with 100% client satisfaction .I ha More
hi i have vast experience using excel spreadsheets,please consider me for the job as i can see it requires someone with such experience
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just se More