written

Hi, I want to filter data in workbook2 based on the value in workbook1. i have written macro which will pick values in workbook1 and go to next workbook but I'm not sure about the code to filter the values in workbook2, copied from 1st workbook. i have written the code as Sub Copy_Data()...

So I admit Im not great with pivot tables so this is probably something simple I have a large Ledger off all checks written this year Date Written to What For Category Amount when i turn the data into a pivot table the category "training" shows up twice everything...

Hi, In Excel2010 How can I identify with a formula, if a cell contains a formula, or a written, text or number? Thanks.

I'm trying to use a sumifs: SUMIFS('Sheet 1'!$R:$R,'Sheet 1'!$A:$A,A1,'Sheet 1'!$C:$C,$G$6) A1 in my first lookup criteria is the month of the year written as 1 for Jan, 2 for Feb etc. However in Sheet 1 the months of the year is written in the yyyy/m format for Jan-Sept, and yyyy/mm for...

Hi,, In column A I have very many phrases. Each phrase may or may not have one or more words in brackets. How can I make all the words in brackets written in capital letters? Thank you.

Can someone help me with this please?! I need code in my spreadsheet to stop users having access to the "title bar". I have VBA written so there is a "close button" on my spreadsheet so the user closes the sheet (and saves automatically) EDIT: I do not need the code to do anything else, as...

I need the formula to be able to evaluate a cell to find what range of numbers it falls within and then return a single number as a result. My formula is written like this thanks to the help I found on this forum...

Hi, I have a working userform & require a text box just so i can add some brief notes. I have added the text box to the form ok & written some text into it. I save it all ok but when i then go back to this customers records on this form i dont see the text that was written ? My info for all...

I have never written a concatenate code in VBA before and I am not finding anything. I am trying to convert the following formula to VBA: =CONCATENATE("MD",MID(A4,4,1),RIGHT(A4,5),G4) Can you please help?

Hi experts I wonder if you can help me with this, it’s reslly frustrating. I have 3 sheets Sheet 1 has 2 command buttons, button 1 generates a non typical range of cells info on sheet 2. Button 2 copies the info from sheet 2 onto a summary page on sheet 3. I want to use this button 5 times (mon...

after I subtotal a worksheet and clicked [2] at the upper left - the summary will be shown, after which, I would like to deactivated the command button - how should the code be written? kindly correct the following: If ActiveSheet.Outline.ShowLevels RowLevels:=2 Then CommandButton1.Enabled =...

Ok, so I am creating an attendance sheet and I have it looking up the employee's # of points and letting it dictate by vlookup what level write up that employee is on. The catch is, if a employee has a no call no show they receive a point (like an absent) but also a right. Excel gives them the...

I have a CF that applies to column G based on dates. I want to take the color that is applied for overdue orders RGB(217,217,217) and apply it to the entire row instead of just the cells in column G. This is what I've written, but it is not working the way I expect it should. If...

Wondering if anyone has ever experienced something where you've edited code and debugging over and over, discovering your edited code isn't included in the execution; instead, a previous interpretation of written code is being executed from memory (doesn't contain the alterations you've just...

I need assistance writing multiple countif statements. Example countif 'Sheet1'!C1:C100,"Y" or if 'Sheet1'!D1:D100,"Y". I currently have it written as follows, =COUNTIFS('Post-Visit-Call-Raw-Data'!AE:AE,"Y",OR(IF('Post-Visit-Call-Raw-Data'!AL:AL,"Y"))) and am getting an error. Thanks in advance.

Hello everybody. For one specific site, I've problem in logging in. When the macro runs, the id is correctly written in its field, the same for the password, but clikking the button the operation fails with the following alert as if nothing had written: All fields are mandatory...

I have the following array formulae repeated about 2.2 million times. Any other way to have it written to increase calculation time? =IF(E5:BB5="","",RANK(E5:BB5,$E5:$BB5,1)+COUNTIFS($E5:$BB5,$E5:$BB5,$BD$3:$DA$3,"<"&$BD$3:$DA$3)) Thank you!

can a formula be written that will reference a cell 5 rows below A1?

=IF('Quarterly Data'!C351> Goals!$Q$45,0,(IF('Quarterly Data'!C395=0,"N/A",(IF((('Quarterly Data'!C351/Goals!$Q$45)-1)=(-1),(100),(ABS(('Quarterly Data'!C351/Goals!$Q$45)-1))*100))))) Could someone tell me what the -1, (100) is? So when I calculate the formula (131.511 / 206.076653) I get...

So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is.... 5250 goes to 5000 6380 goes to 6500 7750 goes to 7500 any help is appreciated.