Search results for query: *

All. I have a table using the CountIf function in Sheet1 to capture data from Sheet2. The table is setup as: Fails By Age <8 (col.K) 8-15 (col.L) 16-30 (col.M) >30 (col.N) The CountIf function works for cols. L & M but not for K & N. Is this because the criteria contains...

All. Presently I recorded the Find/Replace function to look for any data that had "19" & to replce it with "20". Upon further review of this data (in mm/dd/yyyy format)I would like to know if there is a way to code Find/Replace so that it only looks for the first two digits of the yyyy area ...

All. In col.D I have some data that is identified as SP3 & SP 50. How can I incorpoarate the follwing logic into code ? =if(left(D1,2)=SP,then delete entire row. Thanx for any help & guidance.

All. I have a set of data in date format (mm/dd/yyyy). I need the macro to find "19" & replace it with "20". Simple enough except "19" shows up in the dd section. In short, I need to change all of the data in years only from 19 to 20 while leaving the day portion alone. Control/Find changes...

All. In my spreadsheet, I am filtering by one criteria & having all rows deleted once they have been identified. Upon completion, I have a custom filter based on two sets of criteria that should show me the data for "Bond" & "Repo". One issue I have found is that I need to manually add the...

All. I am trying to compare data for three (3) pivot tables. A table next to the pivots has been created to show any variance for each subjects total. I have tried the SUMIF, VLookup & SUMProduct functions but cannot get any to give me a proper reconciliation. Any guidance is appreciated. Thanx.

All. I am using the following formula to change my date (in text form) to a number: =DATEVALUE(LEFT(L170,4)&"/11/"&RIGHT(L170,2)) How can I change the middle section, which is the month ? Note: Left = the year / Right = the day I have tried the MID function but to no avail. Thanx.

All. I have formulas in cells A1:A3. I would like to have my macro: 1. Copy the formula from that range (A1:A3) to B1:B3. 2. It will then go back to A1:A3 & copy/paste value that range. This will happen daily so the range will move to the right with each passing day. I've used the recorder...

All. A simple question that hopefully has a simple answer. The data I bring in via a VLookup formula I have formatted to text. This is because the data it's referencing is in text form. However, I would like to have the 4 digit data have a zero in front of it. e.g.: 1234 to be 01234 Thanx...

All. I am trying to do is add the IF(AND function to my SUMIF formula. What I am trying to accomplish is have the formula locate Account 1614 in Col.A & the currency "EUR" in Col.M and then use the SUMIF formula to give me my answer. My formula is as follows: =IF(AND('LDN Data'!M:M=EUR,'LDN...

Hello All. I'm trying to copy multiple selections. However I get the error message stating "That command cannot be used on multiple elections". I'm simply holding down the CTRL key & highlighting what I need to copy. I obviously need to chk or uncheck something but cannot find it & MS Help is...

All. How can I combine the IF function with the Vlookup function when what I am referencing is duplicated ? In my example below referencing the bin # of the dog is easy but for the others I get a NO for an answer when clearly the bin# is there. I know this has to do with the bin# being...

All. I am trying to attach, via copy/paste value, data in a worksheet to the body of an e-mail. The data is in worksheet "Template" and will be using the range of A1:H15. What I would like is to have the macro copy/paste value the range into the body of the e-mail. I already have the code set...

All. I opened my workbook and after enbabling the macros have found that my icons for VBA are "greyed out". I can record a macro through Tools / Macro but am perplexed as to how this happened and occurred. Any help is appreciated. Thanx.

All. Is there a formula to count only the numeric cells in a range ? e.g.: A1 = 123 A2 = 456 A3 = HELP A4 = 789 A5 = LUCK The formula would give me 3 as the answer. Thanx.

All. How can I adjust my code to hide the Worksheet "Data" ? Sub Mailer() ' Application.ActiveWorkbook.Worksheets("Pivot").Activate Application.ActiveWorkbook.Worksheets("Data").Activate ESubject = "Subject" SendTo = "" Subject = "" Ebody = "" NewFileName = "" Set App =...

All. By attaching the following code to a button, I'm trying to copy down the formula to the next line. This would bve done on a daily basis. c3:d3 to c4:d4 one day c4:d4 to c5:d5 the next and so on. Sub() Sheets("P&L Var - MTD Summary").Select Range("C3:D3").Select Selection.Copy...

All. The following code is giving me the error of "subscript out of range". Sub carolina() Dim ws2 As Worksheet Set ws2 = Sheets("Whatever") With Sheets(whatever) .Range("C3:D3").Copy ws2.[C4].PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False...

All. I have a vlookup formula that includes a date within the file it is referencing. How can I copy this down and have the date change ? Example:=VLOOKUP(A4,'U:\MBS\Whitesheets\2005\Nightly Board\March\[mar 21.xls]Sheet1'!$A:$L,12,FALSE)would have to change to mar 22 when copied down. Thanx...

All. The following code copies a tab and updates the date within. The problem is that it copies & values the range also. My question is how can I just get it to paste the range as oppposed to paste/value (as it contains formulas) and have the code go back to the previous tab and paste/value...