The discussions
Excel
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
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
ClosedHello, 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
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
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
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
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
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...
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
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
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
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
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
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
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
Hello,hw can i download freedom software and its configuration
Excel help
SolvedHello, 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
SolvedHello, 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
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
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
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
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
SolvedHi, 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
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
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?
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
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/ClosedHello, 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
SolvedHello, 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
SolvedHello, 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
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
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
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
Hello, How to concatenate two different cell values paste into single cell Configuration: Windows XP / Internet Explorer 6.0
Inserting certain number of rows
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)
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
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
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
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
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
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?
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?
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
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
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
SolvedHello, 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...
Compare columns in excel
Hello, I have 2 worksheets regarding (4) columns: Column A B C D How do I compare what's in Column A (Worksheet 1) with what's on (Wo...
Macro to extract data based on dates
Hello, Im a newbie to Excel couldnt find what I could accomplish I have a sheet with 4 different coloums with Sheet containing Raw data depen...
Conect pc to internet via mobile phonebrowser
Hello, How can I conect my desktop PC to Internet via mobile phone browser . I dont have Internet on my desktop PC and I want to use the Internet br...
Excel help
Hello, Hello, I have a excel worksheet with inventory data in it. Column A is Item Number Column B is Type of Coating Column C is Stock Lev...
