Hello, I have a cell which contains number and alphabets and also some characters. Is there a way to just get alphabets out of it
Hello, I have a list of towns in Massachusetts. I want to combine similar towns into one entry, so for instance, Brookline and Brookline Villa...
Hello, Configuration: Windows Vista / Internet Explorer 8.0 Dear sir, I need a formula, if the cell contain a prescribed text and the c...
Hello, I am looking for a formula or script that can help me with the following. I am doing a spreadsheet for 19 different offices (on seperate...
Hello, I want to count days, exclude Sat.and Sun and Stat. holidays and have the program tell me the date 20 days, 40 days down the line. eg. I p...
Hello, If I need to look at a cell and if its > than 5 than I need to add 1 unit to another cell. Each additional 5 means 1 more unit in that col...
Hello, I have to an issue with matching columns. Column A Column B Column C Column D Column A: This has 300 lines with account #'s Column...
Hello, I am having a hard time figuring out how to link workbooks. I would like to have a main workbook that we number with a job number and a row...
Hello, Hi, I have two sheets with different data, but one colum is the same (customer name) so I want to add the data from sheet 2 into sheet 1 so...
CAN I ABLE TO ACCESS A TEXT ON FIRST TO SECOND WORKSHEET IF I ENTER DATA IN FIRST SHEET IT CAN BE RETURN IN ANOTHER FILE ALSO
Hello I have a list in excel and for each entry in the list I would like to create a new worksheet with a link from the original list. Is this possibl...
Hello, I want to copy the numbers (numbers only) in a pivot table to another worksheet by using VBA. The following code works if I use debug mode...
Hello, Please help me this is could cost me my job! I got a new computer wirh win 7 and put office 2007 on it. I had files back in excel that 2003 ...
Hello, I have a column that contains "yes" or "no". I need to total the "yes" in each column. What is the formula to do this? Thanks
Hello, i am have a set of numbers( indicating the product serial number) in rows having comments which include some text + date of manufacturing...
Hello, I need a macro that takes multiple csv files and puts them all in 1 worksheet. The csv files all have header info that i do not want copied ...
Hi all! I have what would appear to be a basic question, but can't seem to put my brain around the solution. I have a spreadsheet on Sheet 1. O...
Hello, I need to compare 2 spreadsheets that are coming form different sources but have mainly the same content. I can easily edit them so that t...
Hello, Say, a code like C1180230 may occur more than once in column A, but its occurence with name "Recipe" in the previous cell is unique. I wan...
Hello, I want your help for calculating the balnk cell in the row in a particaular cell and paste the top row column value in that cell. Means ...
Hello team , 1.Can you please help me with the macro to copy paste the filter area to another work sheet . 2.Also the tab from which it is copyi...
Hello, I have a question about "if End If" nested in a For Next structure in excel vba. I have been trying to write a code but I cannot get the...
Hello, Greetings everyone... I want to copy data from one sheet to different sheet but only if a condition is true. For example, 1st Shee...
all the media player sounds are working... and the game sounds too... but none of the computer system sounds are working( startup, login, windows...
Hello, I have data that is inserted in a row. I'm trying to create a macro that will copy certain cells within that row and paste them into cells...
Hi can someone help me to get a macro code to make following: I have a file in which some cells having data as 10000, > 10000 and some others 10000...
Hello, I am trying to create a diary using excel to keep track of everything. As I am a referee I want it to have all the games I have refereed on a...
Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmula...
Hello, I have 29 rows of product numbers composed of 6 different products in an Excel spreadsheet. I need a macro formula that will insert five ro...
Hello, I am creating a macro based application. I wanted to merge almost 20-25 sheets to one sheets. that task is completed. After merging Now...
Hello, I need help to copy a range od cells and want to copy it for "x" number of times given in a cell say "K2". Need the loop to copy for exact n...
Hi I am doing a world cup predictor spreadsheet in excel. How do I match scores and assign points in excel? eg. If someone predicts england to ...
Hello, I was hoping someone could help me out with a code for Excel. What I require is a macro or a workaround for Excel to copy a row from o...
Hello, I would like to add cells in certain columns (for example: a & c) if the data in a certain row (say "8") is the same. I'm sure it's a logic...
Hello, I need a macro that will search for the sku I'm looking for then scroll to the correct column and update the cell with the correct value th...
Hello, Is there a way to automatically insert a new sheet in excel each day ? If yes, can the new sheets be formatted as the original sheet and al...
Hello, I'm making a doc where Column A has number values the same as column B and C. For each cell the conditional formating of cell in column C w...
Hello, i am currently making a spreadsheet that will log our equipment that is being repaired and have had some luck using the IF statement in th...
Hello, I need a macro that will select all rows that have have the word "Japan" in one of the columns. And then Copy and Paste that to Another sheet...
Hi I'm trying to create a dashboard - which will automatically pick up rows based on a condition. I.e. copy the row if its 'closed won' and if it...
Hello, I am trying to get data whcih has been inoutted into one workksheet to copy into another worksheets when it meets a command in one of the c...
Hi All, Thanks in advance for your help. I am autoformatting my dates in Excel 2007 to read as mmm-dd-yyy (i.e. Jan-01-2010) which is working per...
Hello, My name is Edgar I have a problem with my laptop. the internet browser wont start when i open the internet explorer it closes down by itself....
Hello, I would like to include the text value of a cell in the statement I have for one of the IF options. So far my formula is -: =IF((B1...
Hello, In one of my excel formate below mentioned row/coloums are there, Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv N...
Hello, I hope someone can help me. I need to print the step by step values of a formula in a cell for example ilets say: cells(A,3)= Cells...
Hello, First of all i am using 3 rules in conditional formatting and those are =AND(c1"",c1today() Green it works perfectly but ...
Hello, Heres my problem: The company I work for currently uses an excel spreadsheet for scheduling. Its annoying and cumbersome. Once updated...
Hello, I need to set up a loop function that will only output the data of the cheapest house, with a pool. Here is what I have so far, but my...
Hello, I am trying to set my vb code to highlight columns C through G in a light blue color after each step of the loop. So for instance my for st...