Search results

With a user-defined-function? See attached in cells H9 and H15.

See attached. Both Sheet1 and Sheet2 have been processed. 1. Add a cell at the bottom of column A with just MZ in it (A26 and A253 in those sheets (green coloured)). 2. See the green cells at Sheet1 B2:J2 and Sheet2 B1:N1. In Excel 2007 you need to be careful how you enter the formula: For...

Perhap the attached?

Would this do the same?: Selection.End(xlToRight).Select Selection.End(xlToRight).Select If not, under what circumstances are you wanting to execute these sendkeys? Another application? A dialogue box? There may be the same thing with quite different code.

This worked for me (I was searching plain values, not the results of formulae): Dim AddOnRange As Range Set AddOnRange = AA04.Range("AD5:AD100") Dim WorksheetRange As Range Set WorksheetRange = AA04.Range("AI5:AI100") Dim MyRange As Range Set MyRange = Union(AddOnRange, WorksheetRange) Dim str...

In AD2: =INDEX(E2:W2,MATCH(TRUE,(F2:X2-D2)>=0,0))copy down. In AE2:=INDEX(E2:W2,AGGREGATE(15,6,IF((F2:X2-D2)>=0,SEQUENCE(,19)),2))copy down.

Try something along the lines of: =CEILING.MATH(A1-6,7)+12 where cell A1 contains the transaction date. (If you don't have the CEILING.MATH function, just CEILING will give you the same result.

If you right-click on the green table in the attached and choose Refresh, it may work out-of-the-box (if you still have this file present on your system: C:\Users\S.Lakhani\Downloads\askquestion.xlsb ) (Since askquestion.xlsb is a .xlsb file it should not be open whilst refreshing) Separately...

In the attached a table at cell F3: This is a Power Query table without its header row (see above pic). The dates in the first column are different from your expected results because you show 2024 dates under Feb-25 which I suspect you don't want to do. When you change the source data table...

If by the months you mean the sheets, they're on your system in the workbook askquestion. I recommend saving your the askquestion workbook as an xlsx or xlsm workbook (don't just change the extension, you have to do a save as) after removing the query worksheet from it. Then you need to alter...

With Power Query, it's better if you interrogate your askquestion workbook from a separate workbook because it's more difficult to interrogate the workbook that the query is in. A few points about that file: I've reinstated the header Email on all sheets (I think you deleted that column and its...

I've looked very carefully at your file and I can find no logic at all behind the allocation of names in column P on the Outut Required sheet. Can someone else help me out here?

It's nigh on impossible to code for what you want from code that gives you something you don't want. Please, attach a workbook with your sheet duplicated, and on the duplicate add the results you want to see. It doesn't have to be for all 555 rows, but at least for the 23 Vignesh Mohandas rows...

Attach a workbook with this in it. It will stop us guessing wrongly all the things we need to know; the type of chart, orientation, the data being plotted and lots more that I don't know yet that I need to know! Perhaps set it up manually so that it looks like you want it to look when it's finished…

I suspect that those chart elements have borders: Select the element and if they have a border you'll see something like: It could be automatic or solid border. Try changing it to No line: then deselecting the chart element: There may still be little something on mine in the pic...

For both adding named ranges and adding hyperlinks, something along the lines of: For Each ws In Sheets(Array("Sheet15", "Sheet16", "Sheet8")) ws.Range("A14:A28").Name = "'" & ws.Name & "'!January" ws.Range("B14:B28").Name = "'" & ws.Name & "'!February" 'etc... ws.Hyperlinks.Add...

Oh, I see, maybe not. I'll look at this in a few hours; you want someone clicking cell A1 to be sent to the named range January on the same sheet?

If you're working on the same subset of sheets in you workbook, you can restrict the code to work only on that subset: For each ws in Sheets(Array("Sheet1", "Sheet2", "Another Sheet", "ThisSheet", "ThatSheet")) January for all sheets is A1: ws.Range("A1").Name = "'" & ws.Name & "'!January"...

Amendment doesn't work here: Maybe you're after: Sub NameRange() Dim ws As Worksheet For Each ws In Worksheets ws.Range("A1:L1").Name = "'" & ws.Name & "'!YourRange" ' Change the range name to your specifiec name Next ws End Sub

Alan, you never refer to ws in the loop!

Not sure if this is what you want: Select your range on any sheet and, using the name box, type in a name (eg. myRng): then go into Name Manager and edit this Name by removing the sheet reference but keeping the exclamation mark: from this: to this: Then on any sheet, you can use the...

Attached.

Certainly a lot of work has gone into it, it looks very difficult to manage! In the linked-to workbook below, an alternative solution a using pivot table and chart in the vicinity of cell Q32 of the Transactions DB sheet. I've messed with that pivot table to make it look like your original...

For @BillyRay's information, the difference:

I haven't tested but wouldn't TAKE give a different result if there were ties in the top 5 (and there were more then 5 rows in the source)?