Can I hide these based on other cells value?

Hi,

What's the overall aim of this workbook?
By that I don't mean how does the current design work but what information do you want to capture and what result do you want.

It strikes me that the existing design may not be the most efficient way of doing what you want to do but it's difficult to comment without knowing the end goal and what you start with or add and when.

Originally Posted by Richard Buttrey

Hi,

What's the overall aim of this workbook?
By that I don't mean how does the current design work but what information do you want to capture and what result do you want.

It strikes me that the existing design may not be the most efficient way of doing what you want to do but it's difficult to comment without knowing the end goal and what you start with or add and when.

I'm dividing sheets into months after I get the jan->feb

Trying to get a months total, based of days.


Heres an updated version, final will, ofcourse have all months.

DATASHEET.xlsx

Originally Posted by Pete_UK

Maybe you could put the week number in an adjacent column (e.g. put 1 in J1 and copy down to J50, then =J1+1 in J51 and copy this down to the bottom), and then apply autofilter to column J to select the week you are interested in.

Hope this helps.

Pete

That's not really what I'm trying to do at all.

The problem is, I have 20 slots available x2 - thats 40 rows in each week, but there's no need for them to be visible if the row doesnt have an account present.
So if no account is in DATA, the row needs to be hidden.

Originally Posted by Hansemand

I'm dividing sheets into months after I get the jan->feb

Trying to get a months total, based of days.


Heres an updated version, final will, ofcourse have all months.


I'm dividing sheets into months after I get the jan->feb

Trying to get a months total, based of days.

Hi,

I return to my original point. You're telling us what you do now but not what the essence of your requirement is. For instance do you really want separate monthly sheets all the time or is the essential to be able to see any monthly sheet whenever you wish at the click of a button?

I believe you'e making the same mistake that I see time and time again. You are mixing up the two elements of data capture and final reporting. The two require quite different treatments.

A lot of people start by designing the form that they expect to see as the final report or which at first glance seems the best way of capturing data, and then wonder why it's so difficult to subsequently analyse and summarise or extract information from it afterwards.

You should always capture data in a simple two dimensional table and worry about reporting information from it afterwards. Without exception doing this you will always be able to easily obtain management information. Rarely is this the case if you start the other way round.
You will also throw open the whole wonderful world of the powerful Pivot table functionality.

So before you get too far with this I'd create a single sheet database that contains the following columns

Date
Account ID *
Colour i.e. Green/Yellow *
Value

The * values could be Validation drop down cells from which you could pick values. The way I normally arrange these things is to have a single data entry row above the database in which the new values are entered, then a button which runs a macro that adds the new record to the database.