![]() |
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
How do you import data from another spread sheet? | SoMany | Excel | 9 | 02-04-2021 08:09 AM |
![]() |
TThomas | Excel | 1 | 04-07-2016 09:01 PM |
![]() |
Stewie840 | Word VBA | 14 | 12-17-2015 10:13 PM |
![]() |
ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
Condensing a spread sheet | hawkeyefxr | Excel | 4 | 08-22-2012 05:17 AM |