brendanwov
asked on
Listing data in different sheets according to values in master sheet
Hello Experts!
My question will likely be child's-play for an Excel expert. Any help you could provide would be greatly appreciated.
I have a monthly budget on Sheet 1. In Column A, I list the names of all my monthly expenses (e.g. cell phone, electric, water, etc). In Column B I list the day of the month the bill is due (e.g. 1, 17, 31, etc).
I want to create two new sheets. In the first new sheet I want to list all the bills which are due between the 1st and the 15th of the month. In the second new sheet I want to list all the bills which are due between the 16th and 31st of the month.
I attempted to do this in Apple's iWork Numbers using simple IF statements, but I hate all the whitespace. Please see the attached image.
Does anybody have a good suggestion on how to do this?
Let me know. Thanks!
Brendan
Picture-2.png
My question will likely be child's-play for an Excel expert. Any help you could provide would be greatly appreciated.
I have a monthly budget on Sheet 1. In Column A, I list the names of all my monthly expenses (e.g. cell phone, electric, water, etc). In Column B I list the day of the month the bill is due (e.g. 1, 17, 31, etc).
I want to create two new sheets. In the first new sheet I want to list all the bills which are due between the 1st and the 15th of the month. In the second new sheet I want to list all the bills which are due between the 16th and 31st of the month.
I attempted to do this in Apple's iWork Numbers using simple IF statements, but I hate all the whitespace. Please see the attached image.
Does anybody have a good suggestion on how to do this?
Let me know. Thanks!
Brendan
Picture-2.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rob,
thanks for the assistance. apologies for not following your script.
I must admit, I am not able to discover how you defined the "crit1/2"; "filter1/2" and "Data" variables (or what appear to be variables). What am I missing?
It appears the advanced filter will move me along quite well, adding code to allow moving records to sequencing rows may be a challenge.
attached is what I have so far.
thanks for the assistance. apologies for not following your script.
I must admit, I am not able to discover how you defined the "crit1/2"; "filter1/2" and "Data" variables (or what appear to be variables). What am I missing?
It appears the advanced filter will move me along quite well, adding code to allow moving records to sequencing rows may be a challenge.
attached is what I have so far.
Nothing attached and I think you have commented on the question I pointed you towards as an example rather than your own.
Attach your sample to your question and I will take a look. I will advise that I am quite pushed for time at the minute and even worse next week with a new starter in the office.
Thanks
Rob H
Attach your sample to your question and I will take a look. I will advise that I am quite pushed for time at the minute and even worse next week with a new starter in the office.
Thanks
Rob H
no worries on timing. this is a work in process.
I realized my mistake and attempted to post with file in the appropriate dialogue sequence.
thanks again.
I realized my mistake and attempted to post with file in the appropriate dialogue sequence.
thanks again.
ASKER