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

Completed Posted 5 years ago Paid on delivery
Completed

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

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #18206638

About the project

18 proposals Remote project Active 5 years ago

Awarded to:

srijanagrawal21

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 USD / hour
(25 Reviews)
3.8

18 freelancers are bidding on average $19/hour for this job

dgled

I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's ( More

$25 USD / hour
(90 Reviews)
7.1
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$20 USD / hour
(127 Reviews)
7.0
periyannas

Ok Sure

$20 USD / hour
(118 Reviews)
6.4
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$22 USD / hour
(105 Reviews)
6.2
usmanhassan123

MBA accounts and finance. phd in statistics and economics having seven years of experience in Excel development. Excel vba and macros.

$25 USD / hour
(83 Reviews)
6.2
akritisood94

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

$22 USD / hour
(79 Reviews)
5.5
Taisho

Hello, I'm a full-time VBA developer, who knows how to handle formulas and other basic Excel stuff as well. I am proficient in troubleshooting existing VBA code and created dozens of files which utilize sending e More

$15 USD / hour
(65 Reviews)
5.3
jasalaz100

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

$16 USD / hour
(32 Reviews)
4.8
Sunil986020

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

$24 USD / hour
(2 Reviews)
2.5
mythtaker672

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

$16 USD / hour
(2 Reviews)
2.1
shadymustafa

.......................................................................................................................................................................................................................... More

$16 USD / hour
(0 Reviews)
0.0
sayanprogrammer2

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

$15 USD / hour
(0 Reviews)
0.0
euniceokoth6

hi i have vast experience using excel spreadsheets,please consider me for the job as i can see it requires someone with such experience

$22 USD / hour
(0 Reviews)
0.0
webscraper24

"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

$15 USD / hour
(2 Reviews)
0.0