Hi all, very basic Excel user here. I have a staff activity planner that I use, with activities broken down into categories by colour (example attached). It's a bit clunky, and life would be a lot easier if a) I could have each cell as a drop down menu to select the category and b) I could run reports by colour, as in X number of days undertaking activity Y.
Is either of the above possible, and if so any pointers on how I could do it? Thanks in advance!TeamTracker.JPG
Hi and welcome to the forum
Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
File now attached.
As pointed out in my original post, very basic excel user, so clearly wasn't trying to make other people type out my data. There are no
formulas being used, it's all manual input as this stage, and in terms of a result, I'm only after numerical totals of each colour so
as to avoid manually counting cells. What that looks like I have no idea, again as pointed out originally my knowledge of excel is still
very basic, so as a result am happy to be lead on what an effective output would look like.
ok.To start, we will need to know the color code of each color you wish to total. You will have to assign these as in order to count them, we will need to know which ones you wish to account for. Look at this link to learn about color codes.
http://dmcritchie.mvps.org/excel/colors.htm
then let us know which ones you are using. Consistency is important here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks