Does anyone have any idea how I would start to setup an excel spreadsheet for allocating carparks to employees.
At my work we have 3 car parks that are shared between 40 people. Evey 2 weeks - the car park is allocated to another person to use for the next 2 weeks. I have tried to set one up but failed totally.
I need to have the ability to add new staff names and remove staff names of people that have left. New employees go to the end of the list.
And the abiltiy to set the date eg: Week commencing 02 April 2007.
Any assistance/advise would be appreciated.
I'm trying to create a simple (if possible) calendar system that can be
updateable by others down the road. I'm limited to Excel, maybe Access, due
to office protocol, at least for the time being. Is it possible to somehow
reference a list of events on a given date and have it displayed on the
appropriate calendar date? Or is there some other way to set this up, again
within Excel and/or Access only? Any thoughts would be appreciated! Thank
you!
Janet
I have the following on a spreadsheet:
Row 1, Coumn A to Z is populated with some values.
In row 2, I want every 3rd value to be red from row 1, but the values should not be in corresponding columns.
A2 to = C1, B2 to = F1, C2 to = I1, and so on.
How can I drag a formula accross a spreadsheet, without to link it manually; or any other way?
In Excel 2003 I was wondering what the best way to set up and organize the following data used to check avg prices:
Current Column headers:
Product, Vendor 1/Price, Vendor 2/Price, etc. (up to 5 vendors possible, but not all will have data points)
Based on information collected I will average prices, but I may not use all data points in the average.
Now for the question: Is there a way to consolidate the information ?
So if I have 3 products with different vendors
Product 1 Vendor 1 Vendor 2 Vendor 3 (used Vendor 2 and 3 for avg)
Product 2 Vendor 1 Vendor 2 (used vendor 2)
Product 1 Vendor 1 Vendor 2 Vendor 3 Vendor 4 Vendor 5 (used avg of vendors 2, 3, and 4)
I will see in a separate summary table the following
Product 1 Vendor 2 Vendor 3
Product 2 Vendor 2
Product 1 Vendor 2 Vendor 3 Vendor 4
Please let me know if you need any additional information.
Thanks
I want to setup a password to protect a spreadsheet in Office 98 Excel from
someone to access it.
Can anyone help?
Please can anyone help me answer any of these questions:
How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help
How do you format a cell to have dollar signs next to the numbers?
How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?
How do you rename a sheet?
Can I delete the sheets that I don't need? If so how?
How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A
How do you add up all the contents of column D and make the answer show
up in column C?
Thanks in advance!
abi
I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.
Hi,
I work at a research center and I am trying to set up a spreadsheet with all the investigators, the years they submitted applications for a specific grant, the title of the application,etc. I want to be able to sort the spreadsheet by the name of the investigator and be able to see all the applications he's submitted. The trouble is, each investigator has submitted a different number of applications (some have submitted just one, others have submitted over 5) I don't want all titles of each project in just one cell, so I have set up the spreadsheet like this:
Investigator | Year Submitted | Title of Project | Funded | Etc...
John Smith....|........2006..........|.......EHS Study......|....Yes
....................|........2009..........|........EHS Study 2..|...No
Jane Smith....|........2004..........|........Artery Study...|...No
Jonathon.......|........2005..........|........Heart Study....|....Yes
....................|........2006..........|........Brain Study....|.....No
Hope that makes sense. If anyone has any tips on how to set up a spredsheet like this so I can sort by investigator name, please let me know! I would greatly appreciate it!
I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone
