#1
|
|||
|
|||
Excel Spread Sheet
Hi All
I want to prepare single spread sheet showing money given to multiple sub contrator and expenses incurred by them on multiple site can someone help |
#2
|
|||
|
|||
Have you checked out the built-in templates that come with Excel? Depending what version you're using, when you open Excel, it opens a window that shows your most-recent spreadsheets. Along the top are some templates you can choose. On the right is a little link that has "more templates..." There's a bunch in there.
|
#3
|
|||
|
|||
The spreadsheet is more accurately called a 'workbook' and it can contain as many 'worksheets' (tabs) as you need. You could create a worksheet for each contractor and on that sheet include the 'money given' and 'Expenses incurred' with a reference to the 'Site' it was spent on.
In this way each contractor's finance is kept separate but, if you want to keep a total of the 'money given' by yourself, then create a worksheet for yourself and reference the 'money given' totals in the other tabs. |
Tags |
excel 2000 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you import data from another spread sheet? | SoMany | Excel | 9 | 02-04-2021 08:09 AM |
Simple Spread Sheet | TThomas | Excel | 1 | 04-07-2016 09:01 PM |
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 |
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? | ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
Condensing a spread sheet | hawkeyefxr | Excel | 4 | 08-22-2012 05:17 AM |