Hi,
I have a spreadsheet where I keep a list of my clients. There is a field which has filled in which days of the week I see them. I need some kind of a formula that will populate another column with all the clients I see on a Monday, Tuesday, Wednesday etc..
Get what I mean?
Thanks
In order to help you with this, a workbook with an accurate representation of your data (strip out confidential data) is necessary. Can you upload some data?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
You could use a pivot table. See my example attached, its a little crude but hopefully it's what you were thinking.
I can email the spreadsheet to anybody if it makes it easier to understand what I mean. Screenshot below... I need to column with days in centre filled in to write to another column with a list of people in on a Monday, Tues... So the column on the end could be called 'Monday' and it will automatically collate everybody with a 'Mon' present in the 'days in centre' column into it....
Thanks
Leesubberroom that Is what I am after... don't know how to do it though. Will have a play now
Thanks
Untitled.jpg
Last edited by rodduz; 10-02-2013 at 10:13 AM.
I've had a play and I can't get it to work! It kind of works. But because I have some with values of Mon, Tue and Wed etc they're all separate in the pivot table. Whereas I need just Monday, Tuesday, Wednesday, Thursday and Friday as my filters. And the client in with values for Mon, Tue and Wed to show up in the pivot table for each of those days.
if that makes sense
Last edited by rodduz; 10-02-2013 at 10:33 AM.
When you reply to the post, click "go advanced" on the bottom right, and underneath the reply you have an option to upload a file. Just make sure you remove any sensitive data before uploading. I'll try to have a look in the next few days.
Here it is... Cheers
Any joy on this?
Thanks
Take it, it can't be done? I thought anything was possible in Excel :-)
Hi,
I'm sorry about this. I could have sworn i uploaded this file a few days ago, and i havent checked since. Here it is again. I've had to change the way your data is rearranged a little to make it easier but hopefully it wont be a problem. Also, to make it more clear I've seperated to different days out in to tabs. Note that when you add more data you'll need to press the refresh buttons. Also, if you add any columns in to the "Data" tab, it will make the formula's in the tabs incorrect. Hopefully you can figure out how it all works, but the forum will help you anyway.
Hope this is what you're looking for.
That is awesome!! Thanks very much!
One thing: Is there any way I can have the learner name appear on the Monday, Tuesday etc tabs? As well as their ID? It's easier to identify who I have in if their name shows as opposed to just their ID?
Thanks again.
Forgive my ignorance... I've worked it out now.
Awesome.
Really appreciate the help :-)
No problem. If you need anymore help, just let me know.
Oh, and if you're happy, you could add me some reputation to my reply - this is the first reply i've done on here so i'm a beginner helper on the forum - everyone's got to start somewhere!
Done!
Thanks
Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.
In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.
Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi again,
The spread sheet is working great. However, I Need to add more learners to it. Is this easy to do? I need a section for 'construction workers' underneath 'customer service' in the data table and for the data associated with these learners to collate in the other tabs for each day.
Easy to change?
Thanks
Me again! Have been using this spread for ages now and it's served me very well.Originally Posted by leesrubberroom
However lately it doesn't work properly. If I refresh it doesn't collate anything into Friday? Also if I don't fill in any values for the Wednesday it comes up with an error when clicking the refresh, any ideas?
Error is: 1004 - Make sure an ending square bracket ] is not missing
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks