Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Microsoft Excel Challeneges


  • Please log in to reply

#1
LSEactuary

LSEactuary

    Member

  • Member
  • PipPip
  • 79 posts
Hi,

I need to create a spreadsheet for my project (don’t worry it’s not homework). I have put as much as I can together but there are a few challenging things that I am stuck on and I need your technical expertise. I have attached the Excel file as well as a detailed Word file explaining exactly what’s going on (if you want some background).

This is what I need to add onto my spreadsheet – but I’m not sure how to do this. I have tried googling for hours but I haven’t found anything useful because these are quite particular requests.

- Password protection on each sheet (with different passwords per ‘person’ thaty they can customize). The main sheet should be only accessible by a certain ‘moderator’
- The line should highlight a certain colour when it’s a certain ‘type’ e.g. complete = blue.
- Anything you type (per row) into any ‘persons’ sheet should automatically type into the main sheet and change colour of course. The main sheet changes should override any other changes.
- I need a timer so if an issue isn’t resolved in 24 hours it turns a certain colour.

I just need the basic formulas etc and Ill extend it to suit my needs. (So please post really accurate instructions or an excel file or something please)

Thanks in advance!

Attached Thumbnails

  • 0.png
  • 2.png
  • 1.png

Attached Files


Edited by LSEactuary, 23 March 2011 - 02:24 PM.

  • 0

Advertisements


#2
LSEactuary

LSEactuary

    Member

  • Topic Starter
  • Member
  • PipPip
  • 79 posts
One other thing....

If you type a row of data in sheet 2/3/4..... then it should automatically type in Sheet 1 (the main sheet). So if you change something in sheet 3 (for example) it should change in sheet 1 (including colours). And preferably in sheet 1 they should sort themseleves by sheet

e.g.

Sheet 2
[data]

Sheet 3
[data]

etc

Alternatively - you can use Access for this project. Not sure if it will be more useful though...

Edited by LSEactuary, 23 March 2011 - 03:35 PM.

  • 0

#3
devper94

devper94

    Member

  • Member
  • PipPipPip
  • 817 posts
If you have such high requirements, then I believe that Access is what you want. However, I can't help you with that; I don't use Microsoft Office and I don't have an Access equivalent installed.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP