Excel Forum
-
Matching 2 columns in Excel [Solved/Closed]
Hello, I've got 2 columns of data- I'm trying to see if there's a match between the data in Column A with Column B- if the data is in Column B somewhe...
-
I would really appreciate this Excel Help! [Closed]
Hello, I have Sheet 1 & Sheet 2 Sheet 1 = contains a list of clients and the total of USD entered each day Sheet 2 = contains the list of cl...
-
Macro that increase previous cell [Closed]
Hi, Can I get help in creating macro that adds up 1 to reference cell. The reference cell will start with letters such as LT. In other word if the ...
-
copy specific cells from sheet1 to data sheet [Closed]
Hello, Iam new here, if somebody could give me a hand with a sort of code, that would be great. I want to copy the next cells (B5, C3, E15) loc...
-
excel [Closed]
Hello, i have a one master excel workbook and 120 sourse books with only one sheet(file type: text). I want to updated master file by details in s...
-
I need help to merge 2 macros VBA CODE [Closed]
Hello, I need help to merge 2 macros. Bascially, after "MACRO1" finishes running in File 1 ( macro 1 itself located in file 1), i want excel to ru...
-
can vba return excel cell value with formats [Closed]
Hello, I have entered text "ABCDEFGHI" into an Excel cell. I have changed the font of "DEF" to bold. Is there a way for VBA to return the value in the...
-
EXCEL 2007 [Closed]
Hello, I have two excel 2007 files. Both files have same columns but different dates. What I need to do is to compare the data in both files...
-
Excell Question [Closed]
Hello, what excel formula should i use for the date to be automatically input on a cell when typing a dollar amount on another cell.
-
Vba excel problem [Closed]
Hello, Does anyone know the vba to do the following: On command button select - cell A3 = (1st of next month) - cell A4 = (14th of the month...
-
excel help [Closed]
Hello, How do i duplicate rows in excel based on a condition. e.g. name count aa 3 bb 1 i wish to ...
-
Compare 2 data sets in excel [Closed]
Hello everybody, this is the scenario: I have 2 spectrometers that aquire data. I need to compare the aquired data and in order to do so I wand to...
-
Excel Macro: copy paste certain columns to... [Closed]
Hello everyone, I am very new to Excel VBA and could use some help with a macro design!! :) I already looked a bit around but could not find the...
-
problem in excel userform [Closed]
Hello, My english is not good so sorry in advance i have some problem in excel userform please give me solution. check this link https://a...
-
comparing two different excel sheets [Closed]
Hi I need ahelp in comparing two sheets of excel. First sheet columns containing two additional columns when compare to Second sheet(other column n...
-
Compare two Columns and return a value [Closed]
Hello, I have these columns now the problem is how can I make a formula or macro to search from column its counterpart value on column b and retur...
-
vba help [Closed]
Hello, i am working in workbook A.I want to extract data from a particular sheet in workbook B say the name of the sheet is 'xyz'.please help me w...
-
Deleting and keeping rows in same Macro [Closed]
Hi, I'm working on a Macro to keep rows if it meets two conditions, see below. Then I want the macro to look at all the rows again and delete the o...
-
Count visible&non visible rows on filter [Closed]
Hello, I want to count all the visible and non visible rows even when data is filtered. Currently using SUMPRODUCT(($E$2:$E$15="Incident")*SUBTOTAL...
-
freebrowsing [Closed]
Hello,hw can i download freedom software and its configuration
-
Excel help [Solved/Closed]
Hello, I have an excel worksheet with cells filled with strings of text like this... CAS [354-24-5], 99% I'd like to search a vertical c...
-
More than 3 conditional formats in Excel [Solved/Closed]
Hello, I am working with an Excel spreadsheet, and need the cell background in one column to change to red if its value is within a range of numbers...
-
Moving data from columns into rows [Closed]
Hello, I have data that is in two rows in excel such as this: 3/1/09 Joe Sick John Black hotdog 47 y/o ID # 123-09-638...
-
Fill cells based on the value of other cell [Closed]
Hi, Please can you help providing macro for the below query.. If I enter a value in a cell say for example I have entered '2' in B4, i want 2 c...
-
Paste one excel sheet data to other sheet [Closed]
Hello, Configuration: Windows XP / Firefox 3.6 I want to copy set of one excel sheet columns to a specified range of other excel sheet column...
-
macro and formula [Closed]
Hello, I need help to be able to create a macro which for example will use the following formula: =sum(d1+f1 -1), the result is in g1, now I wa...
-
Excel 2003 - Change Row Colour with VBA [Solved/Closed]
Hi, hope somebody can help I've got a spreadsheet when I need to change the row colour dependent on the data entered into a particular cell. The...
-
Can't find excel formula [Closed]
Hello, i have been trying to find a formula for my excel spredsheets. i thought the Formula should be =ifE3
-
CONDITIONAL COPY TO NEW SHEET [Closed]
I'm working on a Excel file with three sheets. All have the same colums, just different sheet names. The last two colums for each sheet reflect the ...
-
My EXCEL formula isn't working, why? [Closed]
Hello, Why won't my formula return my total # count? Here's the problem.... Column A Column B Column C Column D ...
-
EXCEL Conditional Format VBA - Colors & Fonts [Closed]
Hello everyone. First of all, thanks a lot for your help and input. I have been looking all over the web to find the code for the following (i am a...
-
Import webpage data into Excel spreadsheet [Solved/Closed]
Hello, I am attempting to import the web page data from "http://bet1.hkjc.com/racing/pages/odds_wp.aspx?date=19-10-2008&venue=HV&raceno=1&lang=en" th...
-
Open excel file into worksheet of open workbk [Solved/Closed]
Hello, MS Excel 2000, VBA I'd like to be able to open a file directly into a new worksheet of an open workbook, thus adding the new sheet in the...
-
Excel Formula [Solved/Closed]
Hello, I need a formula to accomplish the following. 5 + years => 15 10 + years => 20 15 + years => 25 20 + years => 30 eg. say I was h...
-
Comparing two values on spreedsheet [Closed]
Hello, I have to sheets (Sheet1 and Sheet2), Sheet1 contains ID_Numbers and Lastname, Sheet2 contains ID_Numbers only, I want to compare ID_Number...
-
How to transfer four column data in two rows [Closed]
Hello, I am new member for this forum I required help to resolve following detailed issue in excel sheet I have one query for Excel sheet ...
-
one row items transfer in to two rows [Closed]
Hello, I have one query for Excel sheet I have in one row A B C D E F G H which I want to transfer in to two columns like A B C D ...
-
macro [Closed]
Hello, How to concatenate two different cell values paste into single cell Configuration: Windows XP / Internet Explorer 6.0
-
Inserting certain number of rows [Closed]
Hello, I need to insert a certain number of rows in between two adjacent rows for set of 400 rows Configuration: Windows XP / Safari 533.4
-
Find and replace chars within a cell (Macro) [Closed]
Hello, I am trying to write a macro to find specific characters ("_", "*", "/" etc) and then replace them with a specific outcome. withing a ran...
-
Excel Help [Closed]
Hello All, I need a litle help, When I read a bar code with 31 chars (numeric and alpha numeric) at an excel cell I need that it jumps to the next...
-
Macros to filter data based on two criteria [Closed]
Hello, I'm completely new in Macros programming, I would be approciated if you can help to resolve one task with filtering. I know how works adva...
-
add rows [Closed]
Hello, My name is Nilin and am from chennai. I have a data like below : A1 B1 C1 D1 A2 B2 C2 D2 A3 B3 C3 D3 I would need a ma...
-
Macro for copying different rows [Closed]
Hello to all I would like to copy automatically different rows that have the same numbers at column A to different sheets at a time - then the resu...
-
i want to change excel arabic to englich [Closed]
Hello, I have the same thing problem, I download arabic excel and word and I cannot understand all, how can I change or convert to english? if I downl...
-
What excel formula do I need for this? [Closed]
Hello, I am trying to summarize the number of projects being processed everyday and i want to determine how many projects are approved, hold and r...
-
Excel multiple formulas? [Closed]
Hello, Not sure if it is possible to use multiple formulas but here is the question. Column M has a value that I would like to round to the nea...
-
Excel problem solve [Closed]
Hello, I am a solder of Bangladesh Army. My job office work. My question, A excel work view to MSword. Example I write some word that is ''230...
-
Excel [Closed]
Hello, I have a spread sheet with 6 columns of merged cells with 3 rows of data per merged column. I need to analyze the data, so I unmerged th...
-
Match colums from sheets [Solved/Closed]
Hello, I have two sheets - S1 and S2. In S1 are colums A and B. In S2 are columns B and C. I want to join columns A and C using colums B (which is...
