Create refreshable Power Query from two spreadsheets

Only for registered members Canada

1 day ago

Default job background
Hello · I have a need for a refreshable power query. I have one spreadsheet with a tab called MASTERDATA with several columns of data. · Two specific columns are: · InvoiceID and Inv Date. (Dates are pre=populated through 2024. Dates from 2024 to today have the InvoiceID, but no ...
Lorem ipsum dolor sit amet
, consectetur adipiscing elit. Nullam tempor vestibulum ex, eget consequat quam pellentesque vel. Etiam congue sed elit nec elementum. Morbi diam metus, rutrum id eleifend ac, porta in lectus. Sed scelerisque a augue et ornare.

Donec lacinia nisi nec odio ultricies imperdiet.
Morbi a dolor dignissim, tristique enim et, semper lacus. Morbi laoreet sollicitudin justo eget eleifend. Donec felis augue, accumsan in dapibus a, mattis sed ligula.

Vestibulum at aliquet erat. Curabitur rhoncus urna vitae quam suscipit
, at pulvinar turpis lacinia. Mauris magna sem, dignissim finibus fermentum ac, placerat at ex. Pellentesque aliquet, lorem pulvinar mollis ornare, orci turpis fermentum urna, non ullamcorper ligula enim a ante. Duis dolor est, consectetur ut sapien lacinia, tempor condimentum purus.
Get full access

Access all high-level positions and get the job of your dreams.



Similar jobs

  • Work in company Remote job

    Google Sheets/Excel Tracking Spreadsheets

    Only for registered members

    We are seeking an expert to develop two professional tracking spreadsheets using Google Sheets or Excel. · A clean and well-structured spreadsheet is required that is easy to use and accurate for non-technical users. Google Sheets is preferred due to its cloud-based collaboration ...

    $20 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Excel Expert Needed for Data Population and Verification

    Only for registered members

    We are seeking an Excel expert to assist us in populating cells in a spreadsheet and performing a data verification check across two sheets. · ...

    $50 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Google Apps Script for Data Management

    Only for registered members

    I need a Google Apps Script to manage data from a spreadsheet. · ...

    $20 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Spreadsheet Creation for Legal Case Management

    Only for registered members

    We are seeking a detail-oriented freelancer to create a comprehensive spreadsheet that tracks pending legal cases and their statuses. · ...

    $5 - $12 (USD) per hour

    5 days ago

  • Work in company Remote job

    Fix/Advise Clay spreadsheet lead pipeline, Add AI enrichment

    Only for registered members

    A lead pipeline for apartment buildings needs to be fixed and simplified using AI enrichment. · Stabilize and simplify the current pipeline. · Dedupe current leads in the spreadsheet. · Implement AI enrichment to find additional information for each lead. · ...

    $30 - $75 (USD) per hour

    2 weeks ago

  • Work in company Remote job

    Writer/editor to extract emotional/tonal information from BG3 game dialogue

    Only for registered members

    Help with mapping BG3 dialogue to adjectives describing tone of speaker for ML research project on emotional dialogue. · ...

    $7 - $15 (USD) per hour

    2 weeks ago

  • Work in company Remote job

    Automate the population of fields in Indesign doc with excel spreadsheet

    Only for registered members

    I have about 10 excel spreadsheets of data including columns for title, date, authors, description etc. I have an Indesign template that I want to populate with the data from my spreadsheet. · ...

    $30 - $60 (USD) per hour

    6 days ago

  • Work in company Remote job

    Google Apps Script for Data Management

    Only for registered members

    A Google Apps Script to manage data from a spreadsheet. · ...

    $5 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Financial Analyst Needed for Profit

    Only for registered members

    We are seeking a skilled financial analyst to assist with the creation of a comprehensive profit and loss statement. · ...

    $20 - $70 (USD) per hour

    1 month ago

  • Work in company Remote job

    Spreadsheet Cleanup and Design

    Only for registered members

    This job requires cleaning up a spreadsheet to make it more readable. The task involves adding graphics or charts on a separate tab for better understanding. Additionally, hygiene SRP numbers need to be included for every month. · ...

    $40 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Python Script Development for Shopify Product Upload

    Only for registered members

    This is the process. · 1. we receive invoice for product purhcases · 2 we run ai scripts in deepseek, attaching the invoice we received from supplier · 3. deepseek produces output from the data in the invoice into format that we use to paste into google spreadsheet. · The python ...

    $65 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    WordPress Web Developer Needed for Simple Website Integration

    Only for registered members

    We are seeking a skilled WordPress web developer to create a straightforward website that allows for easy referencing from an Excel spreadsheet.Create Hyperlinks for an excel Spreadsheet to link to the specific sections of text that have been extracted from the PDF. · The ideal c ...

    $15 - $30 (USD) per hour

    4 weeks ago

  • Work in company Remote job

    Merge and Purge Spreadsheets for Data Cleanup

    Only for registered members

    We are looking for a detail-oriented freelancer to assist with merging and purging two spreadsheets. · A keen eye for detail and strong organizational skills are essential for this project.Microsoft Excel · Spreadsheet Software · Data Entry · ...

    3 weeks ago

  • Work in company Remote job

    Merge and Purge Spreadsheets for Data Cleanup

    Only for registered members

    We are looking for a detail-oriented freelancer to assist with merging and purging two spreadsheets. · A keen eye for detail and strong organizational skills are essential for this project. · Microsoft Excel · Spreadsheet Software · Data Entry · ...

    $100 - $0 (USD) budget

    3 weeks ago

  • Work in company Remote job

    Analyst needed for spreadsheet work

    Only for registered members

    Analyst needed for spreadsheet work. · Perform line-by-line comparisons of two or more financial spreadsheets to identify variances, · Clearly document all differences, · ,Trace and validate the source and rationale for changes, · ,Reconcile discrepancies and recommend appropriat ...

    $100 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Untitled job post

    Only for registered members

    We are looking for an experienced automation specialist to build a simple reliable integration between Odoo and Zapier. · We want to create sales orders in Odoo from a spreadsheet (Google Sheets or Excel) with multiple rows combined into one single order. · All orders must be cre ...

    1 month ago

  • Work in company Remote job

    Cross reference 2 spreadsheets and query data

    Only for registered members

    I'm looking for someone to help with a basic data-cleaning and filtering task using two spreadsheets that I will provide. · ...

    $50 - $0 (USD) budget

    1 month ago

  • Work in company Remote job

    Media Contact Spreadsheet Support

    Only for registered members

    I am seeking a detail-oriented freelancer to assist with the creation and organization of a media contact spreadsheet. · ...

    1 month ago

  • Work in company Remote job

    Optimize Excel Sheet/Budget to make it easier to use

    Only for registered members

    I have a cash flow and profitability forecast for an operating business with separate tabs for inputs revenues and expenses I need to simplify the model so the data-entry and assumptions section is more intuitive allows for additional line items to be added easily and still rolls ...

    3 weeks ago

  • Work in company Remote job

    Data Extraction from Amazon Monthly Statement to Excel

    Only for registered members

    We are seeking a detail-oriented freelancer to extract data from our Amazon monthly statements and organize it into an Excel spreadsheet. · Accurately transfer numbers and text into the supplied structured format. · ...

    $3 - $10 (USD) per hour

    2 weeks ago