Search results

Glad to hear that it's on the right track... Please don't be intimidated. They are well worth the time it takes to get started. I'm a beginner myself with VBA. Rather than post an explanation of the code here, I've inserted line-by-line explanations in the file and attached it for your...

Welcome to the forums! I propose rethinking your request a little: What if you change your Main Worksheet to display only one column displays at a time...this will function as your "input" worksheet, but it is also the master worksheet where all the data resides. All the columns are hidden...

Welcome to the forums! It is a little difficult to understand your request; see attached -- perhaps this is what you want? If you have something different in mind, may I suggest that you manually create the outcome you want to see, and then we'll see if we can mimic that outcome with some kind...

I was able to pass the column headers through to the dashboard as you requested but at the same time, I omitted Columns I and J because the duplicate dates are a problem I don't have a solution for at this time. See attached. I think you'll still be able to add and edit employee information as...

Something like this? =IF(AND(COUNT(I2:N2)>1,COUNT(I2:N2)<6),TRUE,FALSE)

Note that when you simply enter a month abbreviation (like Oct or Dec) in your table, Excel treats this as a text string instead of recognizing it as a date, so it doesn't show up on the Dashboard. You'll actually have to assign a date in order for it to get passed through. Also note -- when...

Hello again -- I'm working on passing the column headers through -- and I've got it working for the Quarterly Reviews. I'm having a problem passing through the column headers from Columns F - J through -- and here's the the rub -- some people have the same date in more than one column. For...

Regarding your formula failing to pull through Item 12. Look at the $A1 part of the formula I've put in bold below: =IFERROR(INDEX('Del Note'!B$18:B$63,SMALL(IF('Del Note'!$A$18:$A$63<>0,IF('Del Note'!$A$18:$A$63<>"",-17+ROW('Del Note'!$A$18:$A$63))),ROW($A1))),"") I notice that you've...

No need to apologize for the work -- I volunteered to help because it looked like a good challenge. My lengthy explanation is only offered to help describe the logic behind the formula, so you can make it your own. Don't hesitate to ask if you need even more help; I want to make this...

Sorry about my delayed response -- personal and work obligations prevented me from giving this the attention as soon as I wanted to... Your request is taking some reworking of the formatting and calculations; I've decided to break the data sets into three groups (Licenses, Annual Reviews, and...

Brian, There are several issues affecting your application of the solution I provided. I'll try to address them one at a time. 1. One reason my suggestion is resulting in an error in your template invoice is the formatting differences between your original sample file and your actual...

My original path -- with the SUMPRODUCT formula -- works well for matching values or binary options, but it becomes much more cumbersome with ranges like >78 and <=90. Now that we've got new criteria, I don't think my solution is going to be the best fit. The direction Chihiro's has gone will...

That's a curveball! :) I've modified mine accordingly. See attached. All best!

Brian, See attached. Give this a test and see if it does what you're wanting.

Welcome to the forums! See attached; I've tried to create what you're asking for...but this is pretty preliminary. Is it doing what you want?

Asheesh, My formula solution is identical to yours, but if you check the results when compared with the raw data, you'll find that it creates mis-information: for example, the email address your formula returns for Caller No. 1 actually corresponds to Caller No. 4 in the raw data...It should...

Skyh3ck: See attached. I had to do about an hour of data scrubbing to get this to work; next time you need urgent help on short notice, please try to make sure that your data is consistent and error free. All best.

Hello Sky. Can you process a few of these emails manually and then post the Excel file so we can see what you want as a final result? Thanks.

I'm glad to give it some thought, here are a few suggestions: 1. Start it in a new thread on the Dashboard forum. It makes the forum more useful to future users if we keep each topic in a separate thread. 2. See if you can find a reference (sample) format that you want your dashboard to...

Right-o! That's the best part of a true dashboard -- it automatically updates from the source data you maintain. The Calculations sheet is simply an intermediate sheet where the data is crunched before it hits the Dashboard. That way, the important formulas don't live on the Dashboard where...

I've made one more round of modifications in order to accommodate the addition of new employees. I think you now have the capacity for ~107 total employees (and ~245 licenses) in the attached spreadsheet. If you want to add or change an employee's name, go to the employee list tab and make...

I'd propose that a pivot table is a much faster and concise way to provide the data you're requesting....AND....no formulas required! It just takes about 30 seconds to set up. Very simple. See attached.

In Cell D2: =IF(C2="","",COUNTIF(B:B,C2)) Drag to fill other cells. Conditional Formatting applied to make cells orange as in your sample file. See attached. All best.

I didn't have time to work anything up yesterday, but I was able to get back to it today for a little bit... See attached. I've got the "Quick Summary" on the right side of the dashboard (although it isn't very quick -- there are 71 items in the next 90 days...) Functionally, it achieves what...

Joe, I'm still not sure I understand exactly what you want, so I've proposed three different formulas based on the sample you provided...See attached file. If none of these are what you want, I'll need you to further expand your example so I can see a longer time period (say 10-15 years with...