Visual Basic Jobs

Several workbooks need to be transformed into a cohesive set of data-driven tools that handle advanced analysis, automate repetitive steps, and present results in polished, consulting-grade dashboards ready for client-facing digital products. The core of the assignment combines three focus areas: in-depth data analysis, VBA-powered macros, and interactive dashboard design. Deliverables • Dynamic dashboards that update instantly from raw data, using slicers, pivot tables, and charting best practices. • Reusable VBA macros (well-commented) to clean, reshape, and export data in one click. • A modular financial planner and calculator suite that plugs into the dashboards for scenario modelling. • Documentation sheet summarising workflow, key formulas, and how to e...

I’m building out a new health & wellness platform and need fresh, engaging content writing to kick things off. The focus is purely on content writing—no design or development elements—so you can pour all of your energy into crafting well-researched, reader-friendly articles that inspire better living. Here’s what I have in mind: 800–1,000-word pieces that blend evidence-based information with a conversational tone. Use reputable sources—clinical studies, government guidelines, peer-reviewed journals—yet explain the science in a way anyone can follow. I’ll supply a shortlist of starting topics (think gut health, stress management, sleep hygiene, balanced nutrition), and I’m open to your suggestions as we go. Deliverables • 5 a...

I have a batch of printed documents whose full text must be keyed into a single, well-structured Excel workbook. Every word, line break, and piece of punctuation in the originals has to appear exactly the same in the sheet, so accuracy takes priority over speed. The workbook should follow this simple layout: • Column A – Document number (sequential) • Column B – Full text content Please protect any special characters, maintain original capitalisation, and avoid introducing extra spaces or returns. Before sending the final .xlsx file, spot-check your own work against the prints to ensure no omissions. Delivery is complete when I receive the error-free Excel sheet along with a brief note confirming the page count and any illegible areas you encountered.

As per g sheet and agreed mods

I have a batch of printed documents whose full text must be keyed into a single, well-structured Excel workbook. Every word, line break, and piece of punctuation in the originals has to appear exactly the same in the sheet, so accuracy takes priority over speed. The workbook should follow this simple layout: • Column A – Document number (sequential) • Column B – Full text content Please protect any special characters, maintain original capitalisation, and avoid introducing extra spaces or returns. Before sending the final .xlsx file, spot-check your own work against the prints to ensure no omissions. Delivery is complete when I receive the error-free Excel sheet along with a brief note confirming the page count and any illegible areas you encountered.

I have a spreadsheet that mixes numbers, text, and dates, and those dates appear in several different styles (e.g., 12/03/23, 3-12-2023, March 12 2023). I need the entire file cleaned so every date follows one clear format that I will specify once we start. While working through the file, please also check that any transformations you apply do not disturb the numeric or text fields. Deliverables: • A cleaned Excel workbook with all dates converted to the agreed-upon format • A brief change log noting any assumptions or edge cases you encountered

I have several batches of customer information that need to be keyed into a spreadsheet—either Excel or Google Sheets, whichever you are most comfortable with. The source files are already organised; I simply need the details transferred accurately and formatted consistently. Your job is straightforward: • Enter each customer’s name, email, phone number, and address into the provided sheet. • Double-check for typos and obvious inconsistencies before saving. • Keep the file structure exactly as supplied so my reporting formulas continue to work. I will share the first batch right after we agree to start. Turnaround on a small test set will help confirm we are on the same page; after that, I’ll release the remaining data in similar chunks. Accuracy matters...

Tenho um sistema legado em VB6 e preciso de uma rotina que, a partir de um caminho fixo no disco, envie um único arquivo diretamente para o meu Google Drive usando a API do Google, sem depender do site nem do aplicativo oficial instalado. O que preciso: • Código-fonte em VB6 (módulo ou classe) que aceite o caminho do arquivo e faça o upload para a raiz do meu Drive. • Orientação passo a passo para gerar um token de acesso válido no Google Cloud Console. Ainda não defini se usarei conta de usuário ou de serviço, portanto conto com sua ajuda para escolher a melhor opção e configurá-la. • Pequeno exemplo de uso integrado ao meu projeto atual, com instruções claras d...

I need an expert to automate data entry tasks in a spreadsheet. The ideal freelancer should have: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience with automation tools (e.g., macros, scripts) - Strong attention to detail - Ability to deliver clean and efficient solutions Please provide examples of past work and relevant experience.

I have several Excel workbooks that need to be populated with mixed data—text as well as numbers—sourced from three places: • scanned documents • websites • existing spreadsheet files The sheets are already structured; your task is to transfer the information into the correct columns, keep the formatting consistent, and run a quick spell-check or value scan where it makes sense. Because these files will be used only for internal reference, perfect precision is not essential; accuracy below 95 % is acceptable as long as no fields are left blank and obvious errors are avoided. Deliverables: • Completed Excel files with all rows filled in • A short note highlighting any unreadable scans or missing source data If you are comfortable workin...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

I’m looking for a well-structured Excel workbook that mirrors the screenshot I’ll share and streamlines our daily paperwork at the forecourt. The sheet has to accommodate two MPDs with eight nozzles in total—four dispensing Petrol (MS) and four Diesel (HSD). I’ll key in the opening and closing meter readings manually, so the template must automatically calculate volume sold, deduct any testing quantity, and extend totals, all driven by a per-litre rate I can change each day. Colour-coded sections are important to me: one colour for MS, another for HSD, and a clearly separated collection panel. The collection area needs columns for Cash, Paytm, PhonePe, Swipe Card, DG, Credit, Coin and Tiffin, with a grand total that feeds into a Status/Difference line comparing mon...

I’m looking for a well-structured Excel workbook that mirrors the screenshot I’ll share and streamlines our daily paperwork at the forecourt. The sheet has to accommodate two MPDs with eight nozzles in total—four dispensing Petrol (MS) and four Diesel (HSD). I’ll key in the opening and closing meter readings manually, so the template must automatically calculate volume sold, deduct any testing quantity, and extend totals, all driven by a per-litre rate I can change each day. Colour-coded sections are important to me: one colour for MS, another for HSD, and a clearly separated collection panel. The collection area needs columns for Cash, Paytm, PhonePe, Swipe Card, DG, Credit, Coin and Tiffin, with a grand total that feeds into a Status/Difference line comparing mon...

I need a reliable pair of hands to extract information from a batch of existing digital files and place it into a clean, well-organised spreadsheet. Because everything is already in digital form, there’s no handwriting to decipher—just precise, line-by-line transfer of the data exactly as it appears. You’ll receive the source files, a destination template (Excel or Google Sheets—whichever you prefer), and straightforward field-by-field instructions. The job is simple but accuracy is critical; these numbers feed directly into automated reports, so every character must match the original. Deliverable • A fully completed spreadsheet containing all records from the supplied digital files, validated for accuracy. I’ll start you off with a small test batch...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I have a collection of physical forms that capture a blend of text and numerical information. I need every field transcribed with 100 % accuracy into a well-structured Excel workbook so I can sort, filter, and run quick summaries when the data is back on my screen. You will receive high-resolution scans of each form. Your task is to key the data directly into a single Excel file, following the column layout I will provide. Please preserve all original spellings, numeric formats, and any special characters that appear on the forms. Deliverable • One clean .xlsx file containing every record from the supplied forms, ready for immediate analysis. I will spot-check the sheet for consistency and input errors, so attention to detail is vital. If this sounds straightforward to you ...

I have three-to-four separate Excel workbooks (about 100 MB total) that track related data streams. I need a single, clean Excel dashboard that automatically pulls, merges and refreshes those numbers whenever the source files are updated. Here’s what I’m expecting: • One master .xlsx file that uses native Excel tools—Power Query, PivotTables, slicers or any technique you find best—to connect to each source workbook, consolidate the data and present it in a set of well-designed charts, tables and KPIs. • All links set up so that a simple Refresh brings in new data without breaking formulas, formats or visuals. • Clear, in-file notes (or a short PDF guide) explaining where the connections live and how to add or remove a source file in the futur...

I have a short, 250-word paragraph that I copied from another website into Microsoft Word. Since pasting it, I’m seeing odd, non-printing artefacts—little dots, stray spaces or other markers popping up after many words. I’m not sure exactly what they all are, but every trace of them has to disappear before I move the text over to IMDb. Any method that gets the job done is fine with me—manual inspection, Word’s built-in “Show/Hide ¶” tools, a quick VBA macro or an external script. All I care about is receiving a document that looks identical on the surface yet contains no hidden characters or formatting glitches underneath. Deliverables • A cleaned .docx (or .rtf) with every unwanted marker, extra space and formatting code removed &b...

I have a set of printed documents that must be keyed into a digital format with perfect accuracy. This is strictly offline data entry—I will send you scanned copies of each page, and I need every field transferred exactly as shown into my pre-formatted Excel sheet. Consistency and attention to detail are critical because the information will feed directly into our internal database once I review your file. You may use Excel, LibreOffice Calc, or Google Sheets (offline mode) as long as the final deliverable is returned as an .xlsx file with the original layout intact. Before we begin, I will provide a brief sample page so you can confirm column alignment and naming. Once that is approved, you can proceed with the remaining pages. I would appreciate progress updates halfway throu...

Saya membutuhkan bantuan menulis konten yang langsung mendorong penjualan produk dan jasa saya. Fokus utama pekerjaan ini adalah menghasilkan teks yang persuasif, ringkas, dan mudah dipahami calon pembeli. Ruang lingkup – Menyusun beberapa konsep konten; saya terbuka apakah itu artikel blog singkat, caption media sosial, atau deskripsi produk, selama terbukti mampu mengonversi pembaca menjadi pelanggan. – Melakukan riset singkat untuk memahami nilai jual unik dan pain point audiens. – Mengoptimasi judul, call-to-action, serta struktur paragraf agar menarik perhatian sejak kalimat pertama. – Menyerahkan konten final siap unggah dalam format Word atau Google Docs. Kriteria keberhasilan – Teks jelas, bebas plagiarisme, dan memakai bahasa Indonesia yang alami. &...

My workbook already asks SerpApi for data the moment I type a model number in the “Model” sheet, and Power Query pushes the results into the “Result” sheet. Two nagging issues stop it from being production-ready: 1. The cache sheet that should store the API response has stopped working, so every look-up now triggers a new, slow call instead of re-using the last fetch. 2. On the “Result” sheet the sale price reaches the correct cell, but the regular (full) price column stays empty. I need someone who understands Power Query, Excel data model, and REST/API connections (SerpApi in particular) to: • Diagnose and restore the caching logic so the workbook re-uses previously fetched JSON. • Update the query/transform steps so the full price fi...

I have an Airtable account, I need an Airtable pro who can turn my draft template into a fully functioning workspace to replace a google spreadsheet I have been using. The final base has to feel as familiar as a spreadsheet, yet still take advantage of Airtable’s relational power for contacts and their interactions. What I’ll hand over: • My existing spreadsheet/template in .csv / Airtable format • A short outline of the data I’m already tracking What I need from you: • Import and refine the template into a clear, spreadsheet-style Airtable base • Set up tables, linked records, key fields and filtered views so I can find customers in seconds • Light automation—think simple formulas, look-ups or single-step triggers—only wher...

I have over ten existing price templates that all follow the same column structure, but each one serves a different customer tier and that data needs to be inputted into the most up to date price template. I need them merged into one clean, well-organized master workbook in Excel. Your task is straightforward: enter the current pricing data exactly as provided, consolidate every template into a single sheet, and add a clear tier reference so that I can filter or pivot by customer level later. Accuracy is critical—formulas, cell formats, and any hidden calculations from the originals must carry over without corruption. If a lookup table or a dynamic named range will keep things tidy, please set that up for me. Deliverables: • One master Excel file containing every price poi...

I maintain a master price sheet (the “source” workbook) and a client-facing quote sheet (the “destination” workbook). I need the destination file to pull prices automatically from the source file through standard Excel formulas rather than macros or Power Query, so the link remains transparent and easy to audit. Inside the destination sheet the user must be able to customise a quote through: • dropdown lists that drive item selection • checkbox selections that add or remove optional services As users make choices, the relevant rows—or whole quote sections—should appear via simple drag-and-drop or copy-down actions, with all pricing fields updating instantly from the source workbook. Future maintenance is also critical. New products or pr...

Dispongo de una hoja de OpenOffice Calc donde, en cada fila, una celda contiene la URL de la foto original de una prenda almacenada en mi servidor. Quiero un macro (VBA para OpenOffice Basic) que, apoyándose en cURL, tome esa URL directamente desde la celda, recupere la imagen y genere seis nuevas composiciones: 1. Prenda en modelo – vista frontal – ambiente rural 2. Prenda en modelo – vista frontal – ambiente urbano 3. Prenda en modelo – vista frontal – ambiente de playa 4. Prenda en modelo – vista posterior – ambiente rural 5. Prenda en modelo – vista posterior – ambiente urbano 6. Prenda en modelo – vista posterior – ambiente de playa Requisitos clave • El macro debe ejecutarse desde Calc...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I have a current excel spreadsheet that i record my options trades in. I didnt' design the spreadsheet. I want to recreate the current excel spreadsheet with a couple extra things. This should be a fairly easy job since I already have the excell workbook done and just need to recreate it with a couple changes. Please let me know if this is a project you could take on. Again, this should be fairly easy with the right designer.

My current inventory spreadsheet has thousands of rows that need to be turned into a concise, interactive view so anyone on the team can spot key patterns instantly. The core task is to build, inside Excel, a robust pivot table (or connected set of pivot tables) focused strictly on data summarization of this inventory data. What I need from you is a clean-structured pivot solution that: • Refreshes flawlessly when new inventory records are added • Lets users slice results by any existing field (SKUs, warehouse, date received, etc.) without breaking formulas • Keeps the raw data untouched, with the summary living on a separate, well-labeled sheet • Includes clear, in-sheet notes so someone with intermediate Excel skills can maintain it later Please hand ove...

I need a secure Android banking app built from the ground up for Arab Bank. The core scope is clear: users must be able to manage their accounts, transfer funds, and pay bills effortlessly from their phones. To make this happen, I’ll supply API documentation for our core-banking system along with brand guidelines and sample data. Your task is to design and code the full mobile experience—clean UI, solid architecture, and encrypted communication throughout. Performance, accessibility, and regulatory compliance (PCI-DSS level practices) are non-negotiable. Deliverables • Fully functional Android app (latest stable SDK) • Source code in Git, well-commented and neatly structured • UI/UX assets (Figma or similar) • Integration layer that consumes our ...

I have a batch of numerical records that capture daily financial transactions. I need each entry checked for accuracy, consistency, and basic logic errors before the data moves into our reporting system. The work is strictly on transactions—no invoices or budget reports are involved. You will review the figures against a reference sheet I’ll supply, spot any mismatched totals, duplicate IDs, or impossible values (such as negative credits), and then return a clean file plus a brief discrepancy log. Excel or Google Sheets will be fine for the task; if you prefer to script quick checks in Python or SQL that’s welcome as long as the final deliverables remain in spreadsheet form. Deliverables • Corrected transaction spreadsheet • Separate log outlining every c...

has been praised as “digital gold,” criticized as a speculative bubble, embraced as a hedge against inflation, and dismissed as volatile and risky. Whether viewed as revolutionary or controversial, Bitcoin has undeniably reshaped conversations about money, technology, and financial sovereignty. The Origins of Bitcoin Bitcoin was introduced in 2008 through a whitepaper titled “Bitcoin: A Peer-to-Peer Electronic Cash System” by an anonymous individual or group using the name Satoshi Nakamoto. In January 2009, the Bitcoin network officially launched with the mining of the first block, known as the “genesis block.” The whitepaper proposed a radical idea: a decentralized digital currency that would operate without a central authority such as a government o...

I want a fully-automated habit-tracking spreadsheet built in Google Sheets (Excel compatibility is a plus). It has to handle well over 20 simultaneous habits and let me log results quickly from desktop or mobile. Each entry should immediately update daily and weekly summaries, calculate streaks, and feed clear visual progress charts so I can spot trends at a glance. Beyond the raw tracking, I need space to set individual goals for every habit and have the sheet flag me—through conditional formatting or lightweight Apps Script email/push reminders—whenever I fall behind. Any formulas, scripts, or named ranges you add should be clean, documented, and easy for me to extend later. Please deliver: • A Google Sheet template pre-loaded with sample data, fully functioning dashbo...

I have id information in excel spreadsheet need to gather evidence for those ids from one portal and save the evidence (screenshot) in share folder

I need a summary report created using data from my spreadsheet. The focus should be on top-performing categories, presented as totals by month. Requirements: - Utilize existing spreadsheet data - Highlight top-performing categories - Present data as monthly totals Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets) - Experience in report generation - Strong attention to detail and accuracy

I need an interactive Excel dashboard that turns my raw sales data into clear, weekly insights. The primary focus is tracking sales performance, so the layout must highlight both our overall sales volume and how that volume breaks down by region. Data will be refreshed every week. With that in mind, the file should be structured so I can drop in a new data dump and see the visuals update automatically—no manual re-linking or reformatting. Slicers or simple drop-down filters for date ranges and regions are welcome as long as they stay intuitive for non-technical users. Deliverables • One Excel workbook containing: – Dynamic tables feeding all charts – At least two visuals: a headline KPI card for total volume and a region-level comparison (bar, map, or s...

I need a comprehensive weekly reporting spreadsheet on Microsoft Excel for my team across Operations, Technical, and Commercial departments. The spreadsheet should track: - Tasks Delivered and Completed - Tasks Not Delivered and Reasons - Complaints answered - Outstanding tasks - etc Additionally, it should outline tasks for the next 3 and 6 months, along with any relevant comments or notes. And also make it pretty with colours The ideal candidate should have: - Proficiency in Microsoft Excel - Experience in creating structured, user-friendly reporting spreadsheets - Attention to detail and strong organizational skills

I have a straightforward data-entry job focused purely on spreadsheet management. I will provide the raw data along with the existing workbook; your task is to organise the information, enter any missing figures, verify accuracy and return a clean, fully-updated spreadsheet that matches the current structure. Accuracy is the priority, so please be comfortable with common spreadsheet functions (sorting, filtering, basic formulas) and able to spot inconsistencies quickly. Once the file is complete and double-checked, simply send back the updated version along with a brief note outlining any assumptions or issues you discovered. If you thrive on tidy rows and reliable data, this should be a quick win for both of us.

I'm looking for an experienced Power Automate developer to help automate some repetitive tasks. The goal is to save time and increase productivity. Key requirements: - Automate tasks primarily using Microsoft Office Suite and Cloud Storage Services - Focus on spreadsheet updates and document generation - Built-in manual trigger within Excel to generate a suite of documents. Ideal skills and experience: - Proficiency in Power Automate - Experience with Microsoft Office Suite, particularly Excel and Word - Familiarity with various cloud storage services - Strong problem-solving skills and attention to detail Please provide examples of similar work done and your approach to this project.

I have a growing set of customer records that must be brought into a single, reliable Microsoft Excel workbook. The work involves three clear steps: • Data entry – transfer raw customer details I provide (names, contact info, purchase history, notes) into a structured Excel template. • Data cleaning – de-duplicate, standardise phone and email formats, and flag any incomplete fields so our CRM import runs smoothly. • Basic analysis – add pivot tables and simple charts that highlight total customers by segment, recent purchase frequency, and any notable trends you spot. Everything has to stay inside Excel—no outside tools—so a solid command of formulas, data validation, conditional formatting, and pivot tables is essential. I will review the...

I need a clean, well-structured spreadsheet that focuses solely on customer purchase history, limited to the dates of each transaction. No contact details, product names, or amounts are required—just an accurate record of when every purchase occurred. Please organise the data in either Excel or Google Sheets, whichever you prefer. A separate row per transaction, with columns for Customer ID (or name if that is all that is available) and Purchase Date, will keep things straightforward. Consistent date formatting (YYYY-MM-DD) is essential so the file can be filtered or pivoted later without extra cleanup. Once complete, share the file and I’ll run a quick spot-check against our raw system export to confirm everything lines up.

I'm looking for an Excel expert to create a comprehensive dashboard for managing construction projects. The dashboard should track the following key metrics: - Project Progress - Budget vs Actual Costs - Resource Allocation - Baseline vs Actual Progress - Remaining Works - Milestones - Risks The ideal freelancer should have: - Advanced Excel skills - Experience in project management, particularly in the construction industry - Ability to create user-friendly and visually appealing dashboards - Strong analytical skills to ensure accurate data representation Please provide samples of previous work.

I have several Excel workbooks that need to be transformed into clear, interactive visuals built in Power BI. The priority is comparative analysis: I want end-users to see how figures stack up against one another across products, time periods, or any other relevant dimension we identify together. At this stage I’m concentrating purely on visual exploration rather than a full narrative report or enterprise-wide dashboard, though I appreciate designs that could scale in that direction later. You will receive the raw Excel files along with a brief that highlights the main metrics to compare. I expect you to model the data inside Power BI, choose the most effective visual types, and apply slicers or drill-through where they add value. Please keep the visuals clean, performance-friendly,...

I have several months of raw sales transactions in Excel that need to be cleaned, organized, and transformed into formal financial reports. The source sheets include order dates, SKUs, unit prices, discounts, tax, and payment method details; nothing is yet summarized or categorised. Your job is to: • Tidy the data (remove duplicates, standardise date and currency formats, flag anomalies). • Build an Income Statement that automatically rolls up revenue, COGS, gross margin, operating expenses, and net profit. • Build a Balance Sheet driven by the same dataset, updating assets, liabilities, and equity as new rows are added. Both reports must stay fully formula-based—no hard-typed totals—so that I can paste next month’s sales and instantly refresh the f...

I have a collection of single-column scanned text documents that I need converted into a clean, fully searchable Excel file. The pages are almost entirely typed, but a handful contain small handwritten notes that must be captured as well. Your task is to run accurate OCR, transfer every line of typed text into logically structured spreadsheet columns, and add the handwritten snippets in a separate field or clearly mark them so I can review later. No fancy layout reproduction is necessary—clarity and searchability are what matter. Deliverables • One Excel workbook containing all extracted text, ready for filtering and formulas • Handwritten content entered or flagged in its own column • A quick quality check to ensure the spreadsheet matches the source scans Plea...

I have several Excel workbooks that already contain raw customer information, but they’re scattered across different tabs and follow no consistent structure. I need someone to consolidate every record into a single, clean master sheet, standardise the column headers, and ensure all values (names, phone numbers, email addresses, addresses, etc.) are formatted uniformly. Accuracy is critical, so I will be checking for duplicates and incomplete fields. You are free to rely on functions such as VLOOKUP/XLOOKUP, Power Query, or pivot tools—whatever speeds up the process without compromising quality. When you finish, I expect one tidy .xlsx file ready for import into our CRM plus a short note outlining any assumptions, data issues you encountered, and how you resolved them. If th...

I’m sitting on a sizeable customer-data workbook and need a sharp pair of hands to turn it into something clean, consistent, and instantly insightful—all within Excel. Here’s what I’m looking for you to do: • Data cleaning and organizing: remove duplicates, fix inconsistent labels, standardise formats, and flag any obvious outliers. • Pivot tables and charts: build dynamic pivots that let me slice results by region, segment, and purchase date, then link them to clear, presentation-ready charts. • Advanced formula implementation: craft robust formulas (INDEX-MATCH, SUMIFS, array functions, whatever is best) so key metrics update automatically when I drop in fresh data. Everything should stay inside one well-structured workbook with named ranges, ...

I have several CSV files—course lists (with numbers, requisites, labs and any concurrent pairings), faculty-preference forms in Excel, student-preference forms in Excel, and a record of which courses each instructor has previously taught. From those inputs I need a standalone scheduling tool that will: • read the CSVs directly (no manual re-formatting) • assign flexible time slots and days to every course, pairing each section with a qualified instructor such that each instructor either teach Mon/Wed or Sun/Tue/Thur but not both. • export the finished timetable as a single CSV laid out exactly like the sample I will share, showing day, start/end time, and instructor name • automatically flag overloads (any instructor teaching more than two courses) and anyone...

I need a set of automated dashboards in Google Sheets that continuously pulls data from our recurring CSV exports and turns it into a live view of company performance. The two figures I must see at a glance are Revenue and Net Profit, with the option to slice by product line and date once the basics are stable. Here is what the finished workbook should let me do: • Drop the latest CSVs into Drive and watch the data model update without manual copy-pasting. • View clean, interactive charts and tables that refresh on schedule or at the click of a button. • Export or share the P&L dashboard with teammates while keeping formulas locked down. Please build whichever mix of formulas, pivot tables, named ranges, or Apps Script you feel is best to keep refresh times f...

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...