Visual Basic

I keep a live sales log in a OneDrive-hosted workbook. In my main reporting file I want a table that refreshes automatically, pulls in only the rows whose transaction dates fall between two cells (StartDate... (Budget: $10 - $30 AUD, Jobs: Data Analysis, Data Management, Data Visualization, Excel, Microsoft Access, Microsoft Office, Visual Basic, Visual Basic for Apps)

I need a comprehensive spreadsheet that combines data from my invoices and inventory, along with a final total figure. Requirements: - Combine item descriptions and quantities, prices and amounts, dates and invoice numbers from invoices... (Budget: $30 - $250 USD, Jobs: Data Entry, Data Integration, Data Management, Data Processing, Excel, Financial Analysis, Google Sheets, Visual Basic)

I need help securing an Excel file with a password. Requirements: - Password protection to open the file - Minimum password length of 8 characters Ideal Skills and Experience: - Proficiency in Microsoft... (Budget: $30 - $250 CAD, Jobs: Data Processing, Data Protection, Excel, Excel Macros, Excel VBA, Microsoft Access, Visual Basic)

I have a set of Excel spreadsheets that contain a mix of text fields and numerical values. Your task is to enter every record from these files into the master sheet I’ll supply, keeping the original order and column structure intact... (Budget: ₹12500 - ₹37500 INR, Jobs: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Microsoft Office, Visual Basic)

My multi-sheet inventory workbook has stopped behaving: data no longer cascades from the entry tabs to the summary pages, several formulas now throw #REF! and #VALUE! errors, and the stock-on-hand totals are clearly off... (Budget: ₹1500 - ₹12500 INR, Jobs: Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Excel Macros, Excel VBA, Inventory Management, Visual Basic)

I have an existing Excel-based inventory workbook that has started to behave unpredictably. Data entered in one sheet no longer flows through to the summary pages, several formulas now return #REF! or #VALUE! errors, and the overall stock-on-hand figures are plainly wrong... (Budget: $30 - $250 USD, Jobs: Data Analysis, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Software Architecture, Visual Basic)

I’m working on an older 2011 copy of Microsoft Access and need a quick walk-through on how to locate specific words inside a single text-based table. This is a straightforward, basic search task—no VBA... (Budget: $10 - $30 USD, Jobs: Data Analysis, Data Entry, Database Management, Microsoft Access, Visual Basic, Visual Basic for Apps)

I have several interconnected Google Sheets that are starting to outgrow basic formulas. I need a specialist who can streamline data processing and automate recurring report-generation steps using Apps Script, advanced functions, and Power Queries... (Budget: $2 - $8 AUD, Jobs: Automation, Data Analysis, Data Processing, Data Visualization, Excel, Google Sheets, Software Architecture, Visual Basic)

I have two practical Excel tasks that I want wrapped up into clean, reusable templates. First, I need a professional-looking invoice sheet. It must automatically pull in client information, list each... (Budget: ₹1500 - ₹12500 INR, Jobs: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic)

I have a file ready for you that contains a mixture of numbers and text. I need every record transferred into Google Sheets and grouped logically across separate tabs rather than lumped into one long column or multiple scattered columns... (Budget: $15 - $25 USD, Jobs: Data Analysis, Data Entry, Data Integration, Data Management, Data Processing, Excel, Google Sheets, Visual Basic)

I need a Google Sheet tailored for fast, reliable entry and storage of my financial figures. The layout should guide anyone on the team to type or paste numbers without breaking anything, then automatically calculate running totals, percentages, and other basic metrics... (Budget: $50 - $100 USD, Jobs: Data Analysis, Data Entry, Data Processing, Data Visualization, Excel, Financial Analysis, Google Sheets, Visual Basic)

We’re looking for someone highly skilled in Excel to help our company build a small suite of sales documents. All of the below, we have the contractual wording already, we just need the dashboard built... (Budget: $8 - $15 AUD, Jobs: Automation, Contract Management, Data Analysis, Data Entry, Data Management, Excel, Excel VBA, PDF, Visual Basic, Visual Design)

Gemini said To get the best results from a freelancer (on sites like Upwork or Freelancer.com), you need to be very specific about the "Many-to-Many" issue you mentioned. Here is a clear, professional project description you can copy and paste: Project Title: Excel Automation: PO vs... (Budget: ₹600 - ₹1500 INR, Jobs: Accounting, Data Analysis, Data Modeling, Data Visualization, Excel, Visual Basic)

I have several Excel spreadsheets filled with raw numbers that now require thorough data entry focused on cleaning and validation. Every figure must be double-checked for accuracy, inconsistent formats need standardising, and any duplicate or obviously erroneous records have to be flagged and fixed... (Budget: ₹400 - ₹750 INR, Jobs: Data Processing, Excel, Excel Macros, Visual Basic)

I have a collection of PDFs that contain a mix of text and numerical information. Your job is to extract every field accurately and place it into a Google Sheets workbook I will share with you. The sheet... (Budget: ₹750 - ₹1250 INR, Jobs: Data Analysis, Data Entry, Data Extraction, Data Management, Data Processing, Excel, Google Sheets, Visual Basic)

I have a series of upcoming commercial construction tenders and need a quantity surveyor who can work 100 percent remotely. Your two core responsibilities will be to generate an accurate cost estimation... (Budget: $1500 - $3000 SGD, Jobs: Bill of Materials (BOM) Analysis, Bill of Materials (BOM) Evaluation, Bill of Materials (BOM) Optimization, Bluebeam, Construction Management, Data Analysis, Data Entry, Data Processing, Estimation, Excel, Project Management, Structural Engineering, Visual Basic)

I want an HSE dashboard that gives me a clear, real-time picture of our safety performance, with the main focus on monitoring safety incidents. The tool must capture and display three incident categories—Workplace... (Budget: ₹750 - ₹1250 INR, Jobs: Data Analysis, Data Processing, Data Visualization, Excel, Microsoft Access, Power BI, Tableau, Visual Basic)

I need our customer records transferred and continuously maintained inside a master Excel workbook. The task is straightforward: take raw customer details from various sources, check every field for accuracy,... (Budget: ₹12500 - ₹37500 INR, Jobs: Data Analysis, Data Cleansing, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Visual Basic)

I have a series of online databases that hold the information I need captured verbatim into a clean, well-structured spreadsheet. Every field you see on the screen—names, addresses, reference numbers and brief descriptive text—must be copied exactly as shown, with no spelling or formatting changes... (Budget: ₹750 - ₹1250 INR, Jobs: Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Database Management, Excel, Visual Basic)

I need help populating an existing Google Sheet with a fresh batch of names and addresses. All of the information will come from handwritten notes and PDFs that I will upload to a shared Drive folder;... (Budget: $15 - $25 USD, Jobs: Data Cleansing, Data Collection, Data Entry, Data Management, Data Processing, Excel, Google Sheets, Visual Basic)