Visual Basic para aplicaciones Jobs

I need a robust yet easy-to-maintain Excel workbook (Office 365) that holds my full annual budget, then pulls in Simplifi monthly actuals via the CSV files the app exports. Once the file is dropped in, I want the sheet to refresh and immediately show me how my Income and Expenses are tracking against plan, both month-by-month and year-to-date. You can take advantage of Office 365 tools such as Power Query, dynamic arrays, PivotTables, slicers, or whatever you feel delivers the cleanest solution, as long as I’m left with a single file I can use without any extra add-ins. Deliverables: • An unlocked Excel workbook with: – a clear input area for my annual budget figures – a simple “Import CSV” or “Refresh” action that loads the Simplifi...

I need help standardising the text in an Excel workbook. Several columns are filled with names, product titles, and location fields that now appear in random mixtures of upper- and lower-case letters. Every entry should read in proper Title Case—first letter of each word capitalised and the rest in lower-case. The job is straightforward but must be done with precision. A quick PROPER() formula works for most cells, yet I also expect you to catch exceptions such as “USA”, “eBay”, or common abbreviations that shouldn’t be converted blindly. You are free to rely on formulas, Power Query, or a small VBA macro; just make sure the method is repeatable so I can apply it to future files. Deliverables • My original spreadsheet returned with every relevan...

I’m looking to streamline a set of financial spreadsheets by introducing reliable, well-structured macros. The files contain strictly financial data—no customer or inventory information—so the code must handle numbers, formulas, and summary reports with speed and accuracy. Here’s what I need: • A macro-enabled workbook (.xlsm) that performs the repetitive steps I currently execute by hand: importing monthly figures, cleaning and reformatting them, updating consolidated sheets, and producing a printable summary. • Clear, in-cell or separate comments so I can follow the logic and maintain it later. • Brief usage notes explaining any buttons or shortcut keys you add. Acceptance criteria: 1. One-click execution completes without errors on Excel 2019...

I have a backlog of invoices, receipts and bank statements, all supplied as searchable and non-searchable PDFs. From each document I only need two categories of information pulled out: • the dates and amounts that appear on every page • the full itemised lines (description, quantity, unit price, line total) Customer names or addresses are not required this time, so the workflow can stay tightly focused on these data points. Ideally you will set up an OCR pipeline—Tesseract, ABBYY FlexiCapture, Amazon Textract, or a custom Python script with OpenCV—anything you are comfortable with that gets reliable accuracy. The final output should land in a neatly structured CSV or Excel workbook that I can import straight into my accounting software. Acceptance criteria &...

I have a collection of Word documents that contain only text, and I need every piece of that content moved into an Excel workbook while keeping the original formatting exactly intact. Paragraph breaks, bullet points, bold or italic emphasis—whatever is on the page now must look the same once it lands in the spreadsheet. You will receive the Word files as soon as we start. Your job is to create or populate an Excel file so that: • Each document’s text sits in its own clearly-labeled sheet (or in designated columns/rows if you have a better layout idea). • All formatting remains preserved; no auto-stripping to plain text. • The final workbook opens cleanly in the latest Microsoft 365 desktop version without warning dialogs or broken styling. Feel free to use...

I need an experienced Excel specialist to build a polished sales report that pulls together total sales figures in a clear, decision-ready format. The raw data will come to you in spreadsheet form, and I’d like you to transform it into an easy-to-read report using advanced formulas, pivot tables, and, where helpful, charts or conditional formatting. My priority is accuracy and a layout that lets managers grasp overall performance at a glance. If you prefer Power Query, Power Pivot, or VBA to streamline the workflow, feel free to incorporate them—just keep the final file self-contained so any user can refresh the numbers without extra add-ins. Deliverable: one Excel workbook that includes the cleaned data, automated calculations for total sales, and a well-formatted summar...

I have an Excel worksheet in which every text entry is stored in all-lowercase. I need that text transformed to clean, ALL UPPERCASE values throughout the file while preserving every other aspect of the sheet—cell positions, formulas, dates, and numeric data must remain untouched. Please return a new .xlsx with: • Every previously lowercase string converted to uppercase. • No broken formulas or altered cell references. • The original file name appended with “_UPPER”. A quick turnaround is appreciated, and a short note on the method you used (formula, Power Query, VBA, etc.) will help me verify repeatability in future updates.

I need a tidy-up pass on an existing Excel workbook. Two things have to happen: 1. Every date column must have the month-and-year extracted into its own field (for example, “15/04/2024” should become “Apr-2024”). Please preserve the original date values so the sheet continues to calculate correctly. 2. Text columns contain stray leading or trailing spaces. Those spaces have to be trimmed so that look-ups and pivots work properly, while leaving all other characters intact. Feel free to use formulas, Power Query, or a lightweight VBA routine—whatever is quickest and still keeps the file fully editable in Excel 2016 or later. Send me back: • The cleaned workbook with both the original and the newly formatted columns visible • A short note (or work...

I have an existing Excel workbook that first needs to be put in order, then turned into a concise, pivot-table-driven dashboard. Here’s the scope: • Data cleanup – Remove every duplicate row without losing legitimate repeats – Correct all data formats (dates, numbers, text) so they behave consistently in formulas and pivots – Fill or clearly flag missing values to keep the dataset analysis-ready • Dashboard creation – Build a refreshable pivot-table dashboard that summarises the cleaned data at a glance – Include filters or slicers so I can drill down instantly – Keep the layout simple and presentation-ready on one tab Deliverables will be a single Excel file that contains: 1. The original raw data (un...

3D Interior & Exterior Visualization for Modern Villa – ₹6,000 Fixed Budget Project Title 3D Interior + Exterior Renders for a Multi-Level Villa – ₹6,000 Fixed Budget Project Description I am looking for a skilled 3D architectural/interior designer to create attractive and realistic 3D visualizations for my villa based on the attached architectural floor plan. The project consists of Ground Floor, First Floor, Second Floor and Terrace. The floor plan includes living, dining, kitchen, bedrooms, bathrooms, lounges, walk-in closets, home office, terraces, sit-out, utility and parking areas. I am looking for someone who can convert the 2D plan into a beautiful, modern and practical 3D home design, rather than simply producing basic CAD-style renders. What I Need 1. Inte...