apply

Hi, I am looking to apply set of values to a set of cels in a column based on criteria being met on row, it is for filtering purposes, so i can then use a normal =IF(AND for a secondary filter to mark one row. I know it can be achieved in pivot tables, but i require the single row formula to...

hi guys - i'm totally new at this VBA stuff... i'm looking to apply the code below to 2 other sheets ("Sheet1" and "Sheet2"). the code i currently have is: Private Sub Workbook_Open() With Worksheets("Main") .Protect Password:="password", Userinterfaceonly:=True .EnableOutlining =...

Hi This message "Apply these changes to all other cells with the same settings" is in the Data Validation window. Why and What is used for? Thank you.

Hi I custom formatted cells A1-A10 with #;#;-; and when i wrote B1=sum(A1:A10), excel changed the format of B1 to same custom formatting of A1-A10, why is that? does that apply on all functions?

<tbody> Acct Name Return 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 123 John .25 </tbody> I have a long list I'm trying to apply this formula too but cannot figure it out. I need to...

Hello friends, hope all is well! My Excel hangs/freezes/doesn’t respond, when I apply the below formula on more than 100,000 rows. How to apply the formula without the above issues? Can it be done via powerpivot? What dax formula can I use? =COUNTIFS($D$5:D5,D5,$E$5:E5,E5,$F$5:F5,F5) Thank...

Hi all, For some reason my drowndown list arrows disappear after flashing and I found the code below on the net. When I click a cell with a dropdownlist, this code allows the arrow to flash and comeback, without this code it flashes only to disappear. All I need is to apply this code to the...

Simple macro, works just fine when I'm recording it, and looks like what I've used in the past. I've tried a couple of minor modifications, still and getting an error. Obviously I'm missing "something." TIA!! Sub Sort_XDATES1() ' ' tm_Sort_XDATES Macro ' Application.Volatile True...

Hello, How can select a range of cells and apply a format to it using VBA? For instance, let's say I want to take range B12 to D12 and remove all borders it has and then apply the border only to the top and bottom of the cell? In the code, I need to specify that the row is a variable. My...

Can anyone show me how I can keep the most 10 recent files in a folder and delete the rest? Additionally, I need this to only apply to files with 'Test' as part of the filename.

Hi Friends, Linux = Array("*Linux*", "*Solaris*", "*Sun OS*") d.Add "WindowsOS", WindowsOS d.Add "Linux", Linux . . . . ActiveSheet.Columns.AutoFilter field:=Columns(vcolumn).Column, Criteria1:=d.Items()(i), Operator:=xlFilterValues As u all know here d.Items()(i) will be...

Good afternoon I have the following code which presently populates any value put in column B down a certain amount of lines, however, I need this only to apply to a certain range (from B75 to B1500) Can I ask what I need to amend to apply to only a certain cell range please? Also, I have a...

I have copied a column of values into a workbook, but am unable to apply a formula to it (get #VALUE) as it has a space in front of it. If I remove the space I can apply the formula. How can I remove these spaces to the column, other than individually please?

Time to clean code in one file I have this for highlighting some cells in a selection For i = 4 To 35 'rowNumberValue Cells(rowNumberValue, i).Interior.ColorIndex = 37 Next I I would like to just select the row referenced as 4 to 35 without a loop and apply the colour and...

Hi there, I am looking for a macro which will apply a formula in the column after the last row of a worksheet and apply filter on the same column for the results and copy the columns 1,2, 4,7 and the column on which the formula is applied and copy only values in the different workbook. The flow...

Hello all! I am currently creating a finance dashboard for my government contracting company and have automated the majority of the sheets to disperse a total dollar amount of a contract over a specified time period (in months) evenly and to populate these fields automatically. The problem is...

Hi there, I am trying to apply conditional formatting across a worksheet, based on this formula; =BC3<bc14">< BC14</bc14"> HOWEVER I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am not using absolute...

Hi All I'm currently using some VBA to hide rows based on value in a cell and what I would like to do is apply that code to a range of worksheets in the workbook, how would I go about this. Lets say the worksheet names are called Month1, Month2, Month3 etc through to Month12. This is my code...

hello all, I'm trying to loop a series of ranges, however I don't seem to be getting results trying different online solutions, a nudge in the correct direction would be greatly appreciated. My ranges are: C6:L23,C25:L42,C43:L61,C63:L80,C82:L109,C111:L124 Basically, I am trying to apply my...

Hello, I am *brand new* both to this site and really to Excel. I've used Excel before, but only for the most basic of tasks. I've spent the past 5 hours trying to wrap my mind around INDEX and MATCH and VLOOKUP. I feel like an imbecile so I'm asking for some help. I have a huge spreadsheet of...