ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   need help with invoicing (https://www.excelbanter.com/new-users-excel/104603-need-help-invoicing.html)

DUN RITE ROOFING

need help with invoicing
 
I do construction, and I have all my invoices on my computer in excel. Is
there a way to import the job totals and labor into another worksheet. from
all my invoices I have and will have in the future?

oldchippy

need help with invoicing
 

DUN RITE ROOFING Wrote:
I do construction, and I have all my invoices on my computer in excel.
Is
there a way to import the job totals and labor into another worksheet.
from
all my invoices I have and will have in the future?

Hi Dun Rite Roofing,

The answer is yes, play around with something like this

Open your spreadsheet, say Invoice1.xls. Then open a new spreadsheet,
click cell A1 on your new spreadsheet, then =, then click on the
"Totals" on your Invoice1.xls, press enter.

You now have the total in your new spreadsheet

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=570925



All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com