Excel Forum
-
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 ...
-
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,...
-
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...
-
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 ...
-
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...
-
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 &...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Unable to Convert Date in Excel [Solved/Closed]
I am trying to change all of the dates in an excel spreadsheet to the mm/dd/yyyy format, but when I go to format the cells, it does not change,...
-
Make cells unavailable for selection based on prev selection. [Closed]
Hello All, I'm in the middle of a very big task trying to figure it out. I've 50 assemblies.. Each have variants. I select Ass#1, for this an...
-
Populate missing value in a column [Closed]
Hi, I need to compare two columns and need to populate the missing values in other column. EX: Column 1; Column 2; Column 3; a, b, c,...
-
Using a comand button to open an external software? [Solved/Closed]
Hello. I'm using Excel and I need do create a comand button to open an external software, e.g. I need do order that button to open "Profis...
-
Edit and delete data from database using userform in excel [Closed]
Hi Team, Need some help! I have been working on a userform for entering in and editing data in a database sheet which is located in my share...
-
Sum funtion to substract [Closed]
Hello, When I do the below formula the results are different. What's the difference between Sum function and simply doing the subtraction...
-
How to populate a version # change to a text sentence [Solved/Closed]
Hello, Using Excel 2013 What I'm trying to do is I have for example a row that contains information about my software. And in 4 of those...
-
Conditional copy to another excel sheet based on date [Closed]
Hello, I need some assistance pertaining to copying certain specific cells from one sheet to another in the same workbook -...
-
Dynamic database [Solved/Closed]
Hello, i have a database sheet about spare parts in my store .. this spare pasrts are changed their counted daily , i need the formula that...
-
Excel Macro to rearrange data- combine cells and move sheets [Closed]
Hello, I am just starting to use macros and am lost on figuring this out. Any help would be appreciated, thanks. Inventory comes in a...
-
auto start a specific row in second page from previous page [Closed]
Hi i need auto start a specific row in second page from previous page in excel i hope your replay Configuration: Windows 7 / Chrome...
-
sum different alphabets in an excel range. [Solved/Closed]
some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P"...
-
Macro to copy rows of data off of a sheet into several different [Closed]
Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet. I need...
-
comparison of two table [Closed]
Hello, I need to compare the two table values and return the result as true or false based on two table value in another table . It should be...
-
Auto-running macro when cell is changed. [Closed]
Hello guys, I am using simple macro for one sheet (ControlSheet) to hide rows, in which certain cell (B11;B51) contains text "Corrective Action...
-
If Then rule with dates help [Closed]
Hello, I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a...
-
Transferring data to successive worksheets [Closed]
Hi I have a excel workbook containing several worksheets. To keep things simple Sheet 1 contains a column headed Dates listing 36 weekly starting...
-
copy data and paste using vba [Closed]
Hi, I've two files, I would like to copy the data and not able to do so. Source file: Multiple rows (some times has 60 rows sometimes 80...
