Search results

Yes, it'll unlock any VBA projects you have open at the time of running (add-ins, hidden workbooks, etc.)

We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel.

Since you've already got a filter applied in a way (you're checking for visible cell), then I'd just add another criteria to the filter to hide the cells with 0 and blank. Then it's a simpler copy & paste.

Hi trividha, You'll get more responses if you start a new thread rather than tacking onto an older one (especially one from 2015).

It acts as a counter. The COLUMNS function returns a number indicating how many columns are in the given range. So, at first, this evaluates to 1. When you copy one cell to the right, the range becomes $A1:B1, which then evaluates to 2, then 3, etc. This is so that the SMALL function is being...

Put this array formula in AC6 =IFERROR(INDEX(4:4,SMALL(IF(COUNTIF($C$7:$Q$7,$C$4:$AA$4)=0,COLUMN($C$4:$AA$4)),COLUMNS($A$1:A$1))),"") NOTE: Confirm as an array using Ctrl+Shift+Enter, not just Enter. Copy cell to the right as desired.

A quick search of our forums: https://chandoo.org/forum/threads/remove-password.23208/

@zrs As Alan has discovered, please remember in the future to post links to cross posts, as it saves everyone some time.

If 'Alfie' was in B1, you can INDEX the column you need via something like =INDEX(emp_table, , MATCH($B$1, emp_table[#Headers], 0)) Plugging that into your original formula =sumifs(INDEX(emp_table, , MATCH($B$1, emp_table[#Headers], 0)),emp_table[[Weeknum]:[Weeknum]],$A2)

I'd suggest running an Adv Filter. It's designed so that you have a data table, criteria range, and output range. You can also sepcify unique records only. It's easy enough to do manually, but if you want to use VB: https://www.contextures.com/exceladvancedfiltervba.html

Rollover chart with two series

Formula in D3: =IF(MEDIAN(D$8,$A3,$B3)=D$8,$C3,"No Estimate")

As the only way to do this would be via VBA, I'll move the thread.

Your setup is confusing. It looks like you're trying to use the labels in col A to figure out which sheet to grab, but the sheets have the non-descriptivate labels of "Data entry (7)" rather than "Data entry QBQ". IMO, I'd change the workbook design. First, get all the raw data on a single...

In the future, please remember to post links to your cross-posts. https://www.mrexcel.com/forum/excel-questions/1093994-autopopulate-column-after-dropdown.html

Hi @SharadSalvi Welcome to our forum. However, you'll get more help if you start your own thread, rather than tacking on to someone else's previously solved thread.

Welcome to the forum! Your attached file is hard to understand as it only has one sheet with info. Is that in the desired output, or how the input looks? It currently looks like the layout of a PivotTable. Please clarify what you have vs. what you want.

Note that that message is specifically there to avoid people using malicious code to send email w/o users knowing. Bypassing it could be considered annoying to some users. That said, you could get around it by either a) Just having the email be Show, rather than Send, and let user manually...

Missing commas between the arguments of AdvancedFilter. Also, line breaks need a " _" after them to show the code continues. Finally, when listing out argument names, you use ":=", not just "=". Cleaned code: Sub FilterDataraja() Sheets("Sheet1").Range("A1:L15").AdvancedFilter _...

As Khalid alluded to, be aware of time differences. For my time zone, you posted your question after business hours on a Friday, and I don't check back in until Monday. Here's a start to your file. Chart created as pictured, and slicers made.

Duplicate thread here: https://chandoo.org/forum/threads/filter-the-specific-column-on-basis-of-criteria-and-populate-columns-in-new-excel-template.40933/ This thread is now closed

@thavil Please note our forum rules (and most forums have a similar rule) stating that you should indicate when you have cross-posted a question. Cross-posting is certainly encouraged, we just want to stay informed so if it's been solved elsewhere we don't waste time trying to "resolve" the...

Not a problem, just list out the phrase you want Call ChgTxtColor(Range("A25:A100"), "a string of words", 3)

Let's make one sub that takes arguments, and then we can call it multiple times. Public Sub MainCall() Application.ScreenUpdating = False 'What are all the things to find? Call ChgTxtColor(Range("A25:A100"), "late", 3) Call ChgTxtColor(Range("A25:A100"), "start", 3) Call...