Daily Sports Stats Magic

£10-20 GBP

Geschlossen

Veröffentlicht

vor 4 Monaten

£10-20 GBP

Bezahlt bei Lieferung

I just need some help with some really basic code. I'm basically pulling in football data from the web and the "URL" tables that have been created change by a vlookup function with the idea that it would then pull in another teams data when the web URL is changed and the data refreshed. So far so good. It all works fine the first time round and then when it changes I get the following error: "[Expression. Error] The column 'For Bournemouth Date' of the table wasn't found." I have managed to trace it back to the code in the advanced editor below: Code: (URL) as table => let Source = [login to view URL]([login to view URL](URL)), Data0 = Source{0}[Data], #"Changed Type" = [login to view URL](Data0,{{"For Bournemouth Date", type date}, {"For Bournemouth Time", type time}, {"For Bournemouth Round", type text}, {"For Bournemouth Day", type text}, {"For Bournemouth Venue", type text}, {"For Bournemouth Result", type text}, {"For Bournemouth GF", [login to view URL]}, {"For Bournemouth GA", [login to view URL]}, {"For Bournemouth Opponent", type text}, {"For Bournemouth Att", [login to view URL]}, {"Pass Types Live", [login to view URL]}, {"Pass Types Dead", [login to view URL]}, {"Pass Types FK", [login to view URL]}, {"Pass Types TB", [login to view URL]}, {"Pass Types Sw", [login to view URL]}, {"Pass Types Crs", [login to view URL]}, {"Pass Types TI", [login to view URL]}, {"Pass Types CK", [login to view URL]}, {"Corner Kicks In", [login to view URL]}, {"Corner Kicks Out", [login to view URL]}, {"Corner Kicks Str", [login to view URL]}, {"Outcomes Cmp", [login to view URL]}, {"Outcomes Off", [login to view URL]}, {"Outcomes Blocks", [login to view URL]}, {"Match Report", type text}}) in #"Changed Type" Obviously the error occurs when I change it to say Bristol City because the code it is looking on the web for Bournemouth. Could anyone help me so that "For Bournemouth Date" (and all the others) pull in the data with whatever the column header is from the web source rather than looking for what is between the quotation marks? At this point I could even just take them to point for a cell reference - Sheet1 Cell A1 for date, Cell A2 for Round etc... and create the "For (Team from Cell reference) Date" there.

Excel

Excel VBA

Projekt-ID: 37696325

Über das Projekt

13 Vorschläge

Remote Projekt

Aktiv vor 2 Monaten

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

13 Freelancer bieten im Durchschnitt £18 GBP für diesen Auftrag

@merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

£15 GBP in 7 Tagen

4,8

(147 Bewertungen)

5,7

@mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

£20 GBP in 1 Tag

5,0

(17 Bewertungen)

4,0

@Sindustrus

I am an expert in python, c programming, excel and matlab as I am mechanical engineer by profession. I also have experience in report and research writing and have recently written two submitted master dissertations in English language. I have experience in latex writing as well. Also I have Presentation making and article writing experience, biology writing, Video editing and videography are also my add up skills.

£15 GBP in 7 Tagen

4,1

(4 Bewertungen)

1,7

@carlitanjuguna05

Hello! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includes Excel and Excel VBA, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.

£25 GBP in 2 Tagen

0,0

(0 Bewertungen)

0,0

@ifra54

hi client i am ifra yaqoob i complete BSCS recently i am experienced in data entry,typing,copy and paste,excel sheet and other related job i can do your task immediately and fast feel free to ask Regards

£15 GBP in 2 Tagen

0,0

(0 Bewertungen)

0,0

@vipin965

. I developed a great Proficiency in using excel give a one change i saw i have done graet performance

£10 GBP in 1 Tag

0,0

(0 Bewertungen)

0,0

@kaviyarasusmart

As a badass in process automation, I'm no stranger to dealing with complex data structures and ensuring the utmost precision in my code. I understand that your current script is resulting in a mismatched URL, causing headaches and errors in the team data fetching process. Using tools like Power Automate and UiPath, I can guarantee you a seamless and error-free solution. My extensive expertise with Excel, especially VBA, will come to play here to tailor-make a script that natively fetches team data based on web source headers without being tangled up in quotation marks. Consider me your go-to-guy for all your data extraction needs. With an expertise in web scraping, I've honed my skills to retrieve raw data efficiently and deliver actionable insights effectively. Alongside my sharp attention to detail, I can implement processes that align directly with your sheet layouts and cell referencing system, assuring you accurate output each time. Ask me about tweaking those 'For Bournemouth Date' cells to get values from Sheet1 Cell A1 'date' - you got it! Your project has efficiency at its core, something we both share a passion for. Let's optimize your code together and make it a dream to work with regardless of how many times you change URLs or fetch different team data

£15 GBP in 7 Tagen

0,0

(0 Bewertungen)

0,0

@tayyarjaffar680

I've got plenty of experience in handling data, and I'm really good at using Google Sheets. I pay close attention to details and make sure everything is accurate. I've done this kind of work before and know how to organize information efficiently. You can count on me to get the job done well and on time. Let's make your project a success together!

£15 GBP in 2 Tagen

0,0

(0 Bewertungen)

0,0

@elvis50

I have got the skills and qualities required for the jo being that i have worked as MIS where by i was preparing payroll and data at Altruist Kenya.

£15 GBP in 7 Tagen

0,0

(0 Bewertungen)

0,0

@jchongsg

Good day. Yes - the ultimate solution you require is likely an indexed mapping table so that you can maintain a snapshot of the URL tables. I can help you with that - just send me a chat

£20 GBP in 7 Tagen