Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2021, 10:04 PM
Sayad Sayad is offline Excel Spread Sheet Windows 10 Excel Spread Sheet Office 2019
Novice
Excel Spread Sheet
 
Join Date: Apr 2021
Posts: 1
Sayad is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-23-2021, 06:46 AM
Steve Kunkel Steve Kunkel is offline Excel Spread Sheet Windows 10 Excel Spread Sheet Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 04-23-2021, 08:51 AM
wiganken wiganken is offline Excel Spread Sheet Windows 10 Excel Spread Sheet Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

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.
Reply With Quote
Reply

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
Excel Spread Sheet Simple Spread Sheet TThomas Excel 1 04-07-2016 09:01 PM
Excel 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
Excel Spread Sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 AM.


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