Hello, I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system ent...
Hi, If anyone can help me to create the excel macro on- I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy ...
Hello. I have a userform that I use to introduce some data on excel. Most of the data must be filled (that are textbox that the verifications d...
Hello, Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands ...
Hello, I would like to lock/unlock a work book with multiple passwords. I would also like to add a Log tab and have the unlock record the user, d...
Hi, COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :- Source data copy from:-...
So I have been doing research but have been unable to find a macro that does what I need. Basically, I have multiple items on different carts, labeled...
Hello, I am having a column; A B 1 ab 2 abc 3 abcd 4 abcde 5 xyz 6 I want the next entry in 6 row of A to ...
Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines
Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtes...
I have two separate worksheets "Customers" & "Members". Some customers are also members. I want to remove all Customers from the Members sheet. T...
Hello, I am trying to format a column B2 to B56 with different dates in each row to change yellow when each date is 30 days before the due date and ...
Hello, So my problem is that I have a big chart with lots of numbers in it. Some are whole numbers "1,2,3,4,etc." and others are decimal numbers "1...
I have this information on one single tab (50 sales reps) Colum A - Sales Reps Colum B Revenue sold I need to create a single worksheet for each ...
Hi, When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited a...
Hello, I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (te...
Hi i am struggling to find my customers names on Excel Spreadsheets i have tried the format box and used the find box i also tried the name box can so...
Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any sug...
Hello, I need a macro that could format my data . Data in report comes as Col1 Col2 Col3 Col4 Name1 Date proj task hrs .. . . Tota...
Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
Hello, I am trying to lookup a partial text value in column 1(e.g. lookup all cells with the suffix AAL in cells that have an actual text of say AAL68...
Hello, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20...
Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
Hello, I want to add 9 if conditions is it possible in Excel?
Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
I have two lists containing FAA pilot certification information. One list is basic information on each person in the database, the second list contai...
Hello, if i make 10 invoices for a company on sheet 1 to sheet 10, each invoice has amount about Rs. 10000/- i need a auto covering letter on sheet ...
Hello, i need the formula on excel sheet for find out percentage if the number is >=3499 than find out 5% and if the number is
Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
Hi, I have a master spreadsheet that I want to pull certain information from without losing the format and formulas. I need it to link with my mast...
Hello, I have a list of 500 customers on one sheet with multiple columns of data for each one, Last name is column O, first is column P. On th...
Hello, if cell A2 contain any text then B2 should highlight with color Configuration: Windows 7 / Chrome 45.0.2454.99
I want to copy a particular column from sheet 1 in a workbook to the corresponding sheet 1 in the other workbook and from sheet 2 to the sheet 2 in ...
Hi I'm trying to write a formula to produce an answer depending on whether the data in a cell contains any of the words I am trying to match. Ie. ...
Hello, how can convert for numbers to word Configuration: Windows 7 / Chrome 45.0.2454.101
How to work Microsoft Excel properly?
How to remove Apostrohe in excel eg. '6018-8400-1532-3636 to 6018840015323636. I successfully remove the dashes by using "Find & Replace" but can't...
Hello, I'm working on a sheet to autopopulate from data that I've downloaded in Excel format. Currently, I have to recreate the wheel (spreadshee...
Hi, I have 2 columns. I want to change the color of column A based on value in column B. If value in B is blank no conditional formatting required Bu...
I am looking to re-arrange several tables. They are all in this type of format. Each table does not have a set number of rows and columns. Also...
Hi All I am trying to copy conditional formatting from an original cell to others but the format still refers to the original. Sorry if this is obvio...
Hello, I made changes in a pc and when opening the document in a mac excel 2007 without VBA the changes were screwed up (ie. formatting, formulas, e...
Hello Apologies if this has been answered in another thread, I have tried to ask the question in many different ways but cannot come up with anything...
Hi, I need a Macro Which can help me to collect data from different Xl sheets in master One. That data can be Identified With Its Title i.e. Data und...
Hello, I am new to VBA, and I am searching for a script which can check if a debit has a corresponding credit (same value bue with -/+), and highl...
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
Hello, I need help with the best way to combine information in two worksheets and identify rows where data in colum B and column C has changed on...
Hi everyone. I am trying to figure out a macro to create a new set of rows/columns ive created with formulas and such. The way i want it: 1-I have ...
I am having some difficulty trying to apply conditional formatting to 1 cell with numerious rules - as i have found 1 rule will always work as new rul...
Hi Team, I need step by step procedure how do i set the automatic reply to me if any of the team member update a excel sheet. kindly help me i m...