Excel IF Formulas & Date Filters

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

gevans

Thread Starter
Joined
Aug 26, 2004
Messages
99
As you can see by the attached, I have:
1 – (Sheet 1) Main Database – strictly for data entry
2 – (Sheet 2) Ombudsman Report – formatted to carry over certain data from sheet 1
3 – (Sheet 3) Summary – a quick reference page (this one works fine)
4 – (Sheet 4) Customer Service Sheet – similar to sheet 2 – carries over certain data from sheet 1

There are 2 things I need to complete this:
1 – I want to be able to add a “date” filter on column C for a date range on sheet 2. When I try this, all the records disappear. I’ve tried to use the same filter on sheet 4 & it works fine –

2 – Currently, sheet 4 includes all the records from the main database (sheet 1). I want it to include “Closed” records only (based on column 'O' in sheet 1 – main database)
 

Attachments

Joined
Feb 20, 2006
Messages
2,255
Can you explain clearly what you are doing to obtain these results. A sort of step by step comment of menu choices used and are you copying data into each sheet, so that we can see what you are doing. That will help to decide on the correct way forward.

Thanks
 
Joined
Feb 20, 2006
Messages
2,255
OBP
I think thsi particular spreadsheet is a dual problem and whilst some of it lends itself to Access, I am not convinced yet, that this should go down the access route.

What is this, are you on Access commission LOL :)
 

OBP

Joined
Mar 8, 2005
Messages
19,896
Villan, I don't think anything other than the very simplest "Database" should be in Excel because Access is designed for manipulating data and Excel is for Calculation and Presentation.
 
Joined
Feb 20, 2006
Messages
2,255
Exactly, but I think this spreadsheet is also trying to deal with calculation. Anyway I was only joking with you - did you not notice LOL :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top