Excel Forum
-
Adding days to an auto populated date in Excel [Closed]
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...
-
Macro help required [Closed]
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 ...
-
Help please, VBA userform, MsgBox! [Closed]
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...
-
excel formula using Julian calendar [Closed]
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 ...
-
How to lock/unlock a workbook with multiple passwords [Closed]
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...
-
How to use macro to copy data from workfile A to workfile B [Closed]
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:-...
-
Macro to transfer data from single to multiple columns [Closed]
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...
-
display a new entry in a column in a separate cell in excel [Closed]
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 ...
-
Converting number into alphabetic word [Closed]
Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines
-
Whole Numbers and Decimals [Closed]
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...
-
Remove data on one worksheet if it appears in the other [Closed]
I have two separate worksheets "Customers" & "Members". Some customers are also members. I want to remove all Customers from the Members sheet. T...
-
Conditional formatting [Closed]
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 ...
-
Whole Numbers and Decimals [Closed]
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...
-
create Automatic tabs by sales rep [Closed]
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 ...
-
Date formatting [Closed]
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...
-
If blank cell value of 1 + add 9 cells together [Closed]
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...
-
Finding Customers Names [Closed]
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...
-
greater than and less than [Closed]
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...
-
Macro for formatting Raw data [Closed]
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...
-
How To Copy Data Between Several Sheets on VBA [Solved/Closed]
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...
-
looking up text values in a col. and replace text in another col [Closed]
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...
-
Comparing two columns with other two columns [Closed]
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...
-
values from one workbook to another [Solved/Closed]
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...
-
I want to add 9 if conditions is it possible [Closed]
Hello, I want to add 9 if conditions is it possible in Excel?
-
Range of cells depending on a condition. [Solved/Closed]
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...
-
excel problem [Closed]
I have two lists containing FAA pilot certification information. One list is basic information on each person in the database, the second list contai...
-
Please Solve my promlem if any body can ? [Closed]
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 ...
-
excel formula [Closed]
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
-
match cells in excel with all characters same except one [Solved/Closed]
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...
-
Please Help Create Sub Sheet w/Master Sheet using VBA/MACRO [Closed]
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...
-
Comparing orders vs customers to find the ones who didnt order [Closed]
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...
-
Query [Closed]
Hello, if cell A2 contain any text then B2 should highlight with color Configuration: Windows 7 / Chrome 45.0.2454.99
-
copy data from a workbook to another work book [Closed]
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 ...
-
Excel - If Function [Closed]
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. ...
-
convert numbers to word [Closed]
Hello, how can convert for numbers to word Configuration: Windows 7 / Chrome 45.0.2454.101
-
Microsoft Excel [Closed]
How to work Microsoft Excel properly?
-
How to remove Apostrophe in excel [Closed]
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...
-
Auto populate rows from master sheet to other sheets Excel 2013 [Solved/Closed]
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...
-
Conditional formating if another cell is non blank [Closed]
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...
-
Re-arrange data table [Closed]
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...
-
How to copy conditional formatting to other cells but not refs [Closed]
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...
-
lock specific cells [Closed]
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...
-
Match two unique criteria, total from a third .add to new sheet [Closed]
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...
-
Collection Of data from different Worksheets Under specific name [Closed]
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...
-
script which can check if a debit has a corresponding credit [Solved/Closed]
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...
-
IF functions with dates [Solved/Closed]
Hi, I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece ...
-
Excel - Compare data in two worksheets [Solved/Closed]
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...
-
Macro to create a new set of rows/columns [Closed]
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 ...
-
HELP! conditional formatting to 1 cell with numerious entries! [Closed]
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...
-
Automatic reply if anyone updated in excel [Closed]
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...
Subscribe To Our Newsletter!
