The discussions
Vba code that will find, copy and transpose
SolvedHello, I'm looking all around for a VBA code that will: 1 - Search down one column for the word "ADDRESS" 2 - Once "ADDRESS" is found, I need t...
How to count rows which show specified dates
SolvedHello, I am trying to get help with stats. I have a spreadsheet which shows the date a specific action was started in each row. I need to be abl...
Select y in all 3 columns and return value
SolvedHello, There are 3 columns where range is unknown for all the 3 columns( A, B & C). Macro need to selcect "Y" in all the 3 columns then No action ...
Incorrect product key
SolvedHello, I have just purchased a new computer. A Windows 7 Acer, actually... Well, as a new computer, a Product Key is required... right? See, Micros...
Reg: macro - auto run
SolvedHello, I need to run a macro automatically when i open an excel sheet. and aslo to run a macro when i close the sheet can any one help me...
Vlookup help
SolvedHello, I would be very thankful if anybody solve my problem which exactly need. The details are given beloW: DATE SCRIP NET(Cr/Dr) 19-...
I receive pdf files but can't open them.
SolvedHello, I have windows XP and when I receive an e-mail with a PDF file attached I try to open it and all I get is grafeate. Is it the Windows XP th...
Macro question
SolvedHello, I'm trying to write a macro in excel 07 to select the last row in a range. I want it to select the last row of the range only. Does anyone...
Excel
SolvedHello, I need some help. I would like to find out how many occurences of the same number occur in a column with in excel. Eample: 11111555555556666...
Excel matching data
SolvedHello, I have two rows of data in excel one has the name of all members about 100 and the other list is of members who have paid their dues about 5...
Where does the reference (weekends/holidays)
SolvedHello, in regard to your formula in counting days. you said that a list of holidays/weekends should be created. onces it is created where does that i...
How to update prices in excel by %
SolvedHello, I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spr...
Excel: if then else with multiple criteria
SolvedHello, Essentially, I would like to determine a numeric value (1-9) for the letters of the alphabet. Returning the number value in relation to a n...
Vba/macro: removing titles
SolvedHello, I need to remove Mr/Mrs/Miss preceeding the names in one cell and copy them to another cell. Any idea? Your advice is much appreciated. i...
I need a formula in excel?
SolvedHello, Hello... I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0 your help much ap...
If statement
SolvedHello, Please help me with the following if statement : =IF(A1:A34"Ba","Ba","") Column A1 to A34 contains the following text :Co, Cs, Th, Nk et...
How can i open my files without password
SolvedHello, i lock the forder with "free hide folder" software, i forget the password how can i open my files without password
Constant in formula
SolvedHello, I am trying to use a input cel in excell 1) On my excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used. ...
Countif function
SolvedHello, I'll like to know if i can use the coutif function on multiple values? for example: =COUNTIF(E2:E30,(AND(G2:G30, "=הסתיים",A2:A30,"=11"),"=...
Marcos
SolvedHello, I had someone help me make a marco in excel three years ago in office 2003. the mecro worked fine, but now I have installed office 2007. I can...
Stay on same row when selecting next sheet
SolvedHello, I would like to know how to stay on the same row when selecting another sheet. My file contains 17 sheets. Sheets 2 and 5 till 16 contain...
Stable date
SolvedHello, Is there any function in Microsoft Excel where in we can get a stable date, the date should not change as it changes depending on the system ...
Help with excel macro
SolvedHello, I am certainly a macro noob and require some help, please, :( I work at a travel agency and I have a worksheet with all of our reserves. It h...
Using a named cell in a macro - same workbook
SolvedHello, seems simple but I'm just not getting it....I'm using excel 2003 and am trying to use a named cell on one sheet in a macro on a different sh...
Activate userform in userform
SolvedHello, I've just started exploring the possibilities of userforms. My userform contains a TextBox named "txtAanvraagDat". In this textbox a date...
Count # rows where 2 conditions are true
SolvedHello, I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORI...
Excel 2007 formula help - if cell is empty...
SolvedHello, Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get t...
Excel: nested if formula question
SolvedHello, I've read some answers to similar questions, but not quite the same... How can I have *certain* results of my nested "IF" formula display...
Simple excel question (i think)
SolvedHello, I am putting together an XL sheet and would like to find the MAX value in a column of numbers, then return the contents of the cell next to it...
Vba excel search select paste delete
SolvedHello, If someone could possible help on this I would be very greatful. I have reems of data in Excel (tidal data). I'm looking to get the highs...
Auto_open
SolvedHello I have a question about Auto_open. Where do I put it in VB Editer? Do I put it in a Module, or Sheet, or Workbook. I have 3 sheets in the work...
Forgot password & secret question of orkut
SolvedHello, I m using new gmail & orkut A/c. But i forgot my ol orkut a/c's password & secret question. I want to delete my old a/c. Can anybody pls help...
Adding dates
SolvedHello, I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the day...
If iserror with 2 cells match
SolvedHello, If i have 2 cell that i need to match to 2 array row and print "W" or "L" if both of the cell match. This is what i have =IF(ISERROR(M...
If formula
SolvedHello, wondering if you can help me with excel i need a formula that shows if A1 is starts with letter then give me a that first letter. If it sta...
Macro help...copying and pasteing
SolvedHello, I'm trying to write a macro to copy a row of cells to where the cursor is. The info is constant and the pasteing changes. I've used the "reco...
What is hdd (hp) master password?
SolvedHello, I have Windows XP and it's shut me out of me out. When I turn on it has black screen, asks for a DriveLock Password, a second I forget, then ...
Vba to open an excel file in notepad
SolvedHello, Can someone tell me the vba code to open an .xls or .csv file in notepad? thanks PM
Conditional activation of macro button
SolvedHello, I was wondering if it is possible to only make a button work if there are only two cells selected. I have got a button which will copy th...
Excel formula for conditional formatting
SolvedHello, I'm trying to find a formula and instructions for shading date values in a column on a worksheet based on the month relative to today's date. ...
Set password in mozila firefox
SolvedHello, i want to know how can i set pass word in mozila firefox which is ask me when i start or open firefox. please repy or answer in my email addr...
Highlight one cell based on date in a range
SolvedHello, Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or...
Excel date formatting problem
SolvedSo here's my problem. I have multipe dates all in one column on one tab/worksheet of an excel workbook. When I try to link to that date on another tab...
Count a text string if criteria is found
SolvedHello, I have a problem and is that I want to count a text string from a range of cells, if the criteria is found correct, for example, jamshedpu...
Please help with my spreadsheet
SolvedHello, I am having a hard time trying to figure out how to format my spreadsheet so that i can make it a template that i can use in future, this is w...
Please help! excel question
SolvedHello, I am trying to figure out how to count the number of cells that contain a certain text. For example: Column A 2007 Entry Draft ...
Simple function or formula i think
SolvedHello, I want to set up a formula or function to display a number from another cell only if a different cell is greater then 0. Example: data in Cel...
Excel 2003 question
SolvedMicrosoft Office Excel 2003 I am trying to put in todays date along with text. How would i do this? in box A43 i have: =Q1&R1&S1 in Q1 i h...
