Excel AP Invoice Automation with VLOOKUP and Data Consolidation

Excel AP Invoice Automation with VLOOKUP and Data ConsolidationExcel AP Invoice Automation with VLOOKUP and Data Consolidation

The network for creativity

Join 1.25M professional creatives like you

Connect with clients, get discovered, and run your business 100% commission-free

Creatives on Contra have earned over $150M and we are just getting started

Back to feedPost

Somit Guha

• 16h

Accounts Payable (AP) Invoice Automation:

The project automates the Accounts Payable process by consolidating separate financial data files.

Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.

Data Analysis Database Administration Database Development Microsoft Excel

Johnson Afolabi

• 13h

Linking the summary sheet with source workbooks via VLOOKUP really cuts the manual matching step.

Somit Guha

• 6h

Correct Johnson Thanks!!👍

Samin Sami

• Sep 29

Voltline Automation, "Bone & Volt" Industrial AI Landing Page

I built this single-file static landing page for Voltline, a fictional AI-automation company, using only HTML, CSS, and Vanilla JS, zero build tools, zero npm, zero frameworks. The aesthetic is "Bone & Volt": a warm off-white canvas with graphite black and one electric-lime accent (rgb(152, 254, 0)) that pops like a circuit trace under a microscope. The vibe? Precision engineering meets retro-futurism. Monospace slash-prefixed labels, tight geometric-sans headlines, orbiting 3D primitives, and tiny "space / starfield" reveals on hover, it feels like a precision instrument, not generic SaaS.

The user can scroll through sections with subtle scroll-triggered animations, hover over geometric elements to trigger micro-visual feedback, and click the "Contact" button to reveal a minimal contact form. The 3D primitives orbit subtly on the canvas, and their rotation is synced to scroll velocity. I also added a "hover reveal" effect where tiny starfield particles drift into view on hover, a small touch of magic that feels like a digital lab under glass.

The real challenge? Making the 3D primitives rotate in sync with scroll velocity without creating jitter or stutter. I had to manually calculate scroll delta and clamp it to a smooth range, then map it to rotation speed via a simple linear interpolation. I wrote a small JS helper that tracked scroll position and velocity using requestAnimationFrame and performance, then applied that to a .rotate() method on the 3D primitives. It took me three hours of trial and error, but once I got the math right, the motion felt intentional, not robotic.🔥 😊

Completed work

UI Design Web Design CSS3 HTML5 JavaScript AI Automation

Johnson Afolabi

• Sep 30

Great job syncing the 3D primitives' rotation to scroll velocity - pulling off that level of interactivity with just HTML, CSS, and vanilla JS is impressive. The electric-lime accent really makes the retro-futuristic vibe pop.