puts

Does anyone know how to get fix an #NUM ! error so the cell is blank and not have this #NUM ! In . I have the following formula that puts this error in the cell...

Hi guys , I need a solution wherein we are saving a excel sheet & password gets activated after 15 days(for example). idea is to send file to the user & if he doesn't use that within 15 day a pre applied password protect the same & promt for password on 16th day. Regards

I have a vlookup column that I would like to sum the dollar amounts that vlookup puts in the column. Thanks

Hi again I'm pretty sure that this is doable but I'm having a hard time with the macro. I'll make it simple for you Excel gurus out there. Say I have only one button that executes a macro. Say the macro puts a one in Cell A1. Then when I click on the same macro button, it puts in a zero in...

Sorry this seems simple but not working for me. I want to compare to see if c4 > n4. If c4 > n4 subtract n4 from c4 else put a zero in the cell This isn't working for me. c4 currently equal to 35,844 n4 currently equal to 24,852 P4 should be 10992 but it puts a dash in the cell. Here is what I...

I am automatically extracting data out of a Text file and pasting it into Excel. When I do it puts all the columns from the Text file into Column A and you cannot easily separate them. I need to be able to keep the source formatting from the text file (i.e. Columns) when I paste. Any help is...

hey, so im really new to VBA, and im not sure if this is possible. the thing i want to achieve is: in row a i have names, these are names of sheets i already have. these sheets change. so lets say A1 has "sheet1" in it. now what i want is that with VBA i want to make a formula that takes the...

I have the following setup: Each of my cells does a vlookup for a matching record in either of 2 other source data tabs. If it finds a match, it puts them in the associated cells. When the Date Replaced cell is filled in with a date, an 'x' is entered into the associated S column, via a...

I have a vba macro that runs and solves some thing that puts data in to Columns A:C which i then paste to sheet 2 in columns A:C. Now the macro returns to sheet one and keeps running and puts a different set of data in Columns A:C on Sheet1 how do i get this to automatically copy to the first...

Hi I am working on a sub which has a userform as part of the macro, there are some calculations based on the information the user puts in the user form, some of the calculations are on time so the user needs to put a : between the hours and minutes and seconds (12:45:29) some are based on...

hello every one, I have a line of code that I'm working on, it auto sums the data from column "A" and puts the sum, one cell below the last, what I'm trying to do is have to sum appear in "W1" instead of the cell below the last, any thought? [CODEWith Sheets("DataDump8") Dim Lr As Long Lr =...

I am trying to use a formula in, let say, cell A1 such as =if(x2>0,"yes" ,"no" ). Now X2 contains a formula that gets its data based on other cells. So cell A1 always registers x2 as being greater than 0 and puts yes no matter what. How do I get cell A1 to see the formula result in x2 and not...

I’m looking for a formula or routine to calculate the number of SPY put options, or dollar amount of put options, required to be purchased to insure against dollar loss when the value of a stock portfolio declines.

Here is what I need to do. in the example below I need Colum L (Velocity Code) to have a formula that if Colum K (Hit Count) has a number >250 it puts an "A" in the Velocity Code Colum. But if it is <250 but >100 it puts a "B", if it is <100 but > 50 it puts a "C", <50 but > 10 it puts a D and...

Trying to get this to be blank when no data has been entered. Currently, if there is no data put in yet it puts up an L =IF(A2="","",IF(A2>2500,"H","L")) any help on this will be great.