imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
Hi! I have a spreadsheet set up with each month on it. Each month has a column with $0.00 in it for our services each month. My question is, can I hide the information in the other columns and only display the current months charges. I do not want to hide the other columns, just the information in them. Below is an example:
Jan Feb Mar Apr
5.00 0.00 0.00 0.00
3.00 0.00 0.00 0.00
1.00 0.00 0.00 0.00
8.00 0.00 0.00 0.00
I only want to display the information where charges appear. I would like to hide the 0.00 for the other months until that month is current. I have formulas figuring those amounts (0.00). Maybe even set it up where only an amount shows up if there is a charge and if not, it remains blank. I hope this helps. Thanks a million!
Scott
Jan Feb Mar Apr
5.00 0.00 0.00 0.00
3.00 0.00 0.00 0.00
1.00 0.00 0.00 0.00
8.00 0.00 0.00 0.00
I only want to display the information where charges appear. I would like to hide the 0.00 for the other months until that month is current. I have formulas figuring those amounts (0.00). Maybe even set it up where only an amount shows up if there is a charge and if not, it remains blank. I hope this helps. Thanks a million!
Scott