Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-30-2018, 12:59 AM
ArviLaanemets ArviLaanemets is offline Linking Invoices to spread sheet Windows 8 Linking Invoices to spread sheet Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

How to do it, and how easy/difficult is to do it, depends on your source data.

when you have a sheet e.g. Invoices, where you have a table with a row for every invoice, and a sheet e.g. InvoiceRows, where you enter every invoice row info as separate row (and then you have a report sheet, where you select an invoice number, and the report is filled with invoice data which you can print out or print to PDF-file), then it is easy. More than that - you can have on sheet Invoices a calculated column which calculates invoice totals from sheet InvoiceRows. And you can have reports to for monthly/yearly sales, or for sales by articles, etc.

when you have a template where you enter certain invoice data in design for printout, and mayby every invoice on separate sheet or as separate file, then it is possible, but I thing the result is not worth the work you will have (not only designing the summary table, but also updating the design continuously).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Invoices to spread sheet Data from a specific row in a spread sheet into a form JohnnySTI Excel Programming 13 01-24-2018 01:20 PM
Linking Invoices to spread sheet Simple Spread Sheet TThomas Excel 1 04-07-2016 09:01 PM
Linking Invoices to spread sheet Using combobox to pass data from an Excel spread sheet to text boxes on userform Stewie840 Word VBA 14 12-17-2015 10:13 PM
changing the spread sheet location on embeded pie chart otuatail PowerPoint 1 03-04-2014 07:20 AM
Condensing a spread sheet hawkeyefxr Excel 4 08-22-2012 05:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft