Excel Forum

Sorting and matching columns in excel

Hi People... I see there are so many questions and answers on sorting data....... I have one for you, a solution for which would help me no end... ...

Event macro error when opening workbook

Hello, I am a newbie excel visual basic program dabbler. I have created a macro that runs several other macros just fine when I run it myself. I ...

Excel format blue font in bold

Hello, Can you please tell me if there is a conditional format that I can apply to an entire column in which I can have blue text formatted to be bol...

Inserting offset cells values into formula

Hello, I am trying to sort through technical stock data to test entry and exit conditions, I have set this up so that when the signal turns from SE...

Msg box vba

Hello, How to put Msg box in VBA code, using the criteria of wether a seperate file( other than active file) is opened.

Macro to delete created object

Solved

Hello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...

Sharing workbook with macro

Hello, Good day to everybody..I'm asking for anybody's help regarding to my workbook.. I have a workbook with a macro. its running fine with my pc, ...

Excel sheet not opening

Hello, i installed excel 2007 but when am trying to open an excel window its not opening?can anyone help me it is urgent to me plzzzzzzzzzzz

Inserting rows/copy data from row to column

Hello, Hopefully someone can help me solve a problem I am having creating a macro to insert rows into a spreadsheet then copying data from the row in...

Conditional copy of a row in ms excel

Hi friends, in an excel sheet, if a cell satisfies a condition i want to copy a particular row in a work sheet to another work sheet, pl some one hel...

Delete certain cells of active row

Solved

Hello, I would like a code for the following: Check which row is active/selected and then delete the data which is in the 5th and 7th column of ...

Insert rows based on count of row in another

Solved

Hello, I have a excel where I create few dummy accounts and the next sheet (sheet2) has details of these accounts. I need the sheet 2 to have certai...

Highlight row when all cells contain data

Hello, Using Excell 2007... i am trying to use Conditional Formatting to create a formula that will allow any row on my spreadsheet to highlight on...

Excel macro - dynamic column selection

Solved

Hello, I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column ...

Compare & delete - excel macro help

Hello, I am new to Macro's and VB. I have been trying to create a macro to automate a task in Excel. I have an Excel workbook with data on two diffe...

Transferring data between two excelworksheets

I have a master worksheet (Worksheet1) that has two columns titled ID and Route. Each Route has a corresponding ID assigned to it. There are about 160...

Deleting cells with same data as other cell

Hello, I am trying to do the following in relation to two mailing lists in Excel. 1. Identify the email addresses in one list that are the same...

Copy from another spreadsheet with condition

Hello, I'm currently working on a data base in excel and would have the following question: I have a sheet "North America". In this sheet, on c...

Comparing two excel sheets

Hi, Macro given by you is working, Thankyou very much . But if I have two columns in worksheet1 and 1 column in worksheet2, I should get only re...

Excel formula help

Hello, I have a workbook that contains a data sheet and a summary sheet. the data might look something like below lady box lady dice lady ...

Macro

Hello, I have a problem and i need a Macro to resolve it. I have in the range "a2:f2" formulas in each cells and i need to copy and paste it in the ...

Excel help

Hello, Say on sheet 1 I have in A1 the value 3 and the cell color is red. Is there a way to do a formula that would return this on sheet 2 in A1. ...

Extract identical cells of 2 columns (excel)

Hello helpers!, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list o...

Excel conditional formatting row color

Solved

Hello, I am trying to get Excel to automatically change the color of a row depending on the entry in column H. I've got some VBA code written up, but...

Copy data one sheet to another

Solved

Hello, dear friend i have two work sheet.first sheet has a data.using subtotal function I'm daily taking summary of that data.that summarized data da...

Excel - converting data for sap upload

Excel linking data

Hello, I am a bit of a dummy on excel and I was hoping someone on here could help me. I have a mater spreadsheet which lists all the training t...

Macro to compare two sheet with both sheets h

Solved

Hello, I have a 2 excel sheet which has all the column having same. This has D$C Comment, OMS comments, Planned Resoluiton date & Sub account in bo...

Lookup,count and pie chart excel2007

Solved

Hello, Can anyone give advice? I got a form on sheet1 thats got a savebutton to save the input data of the form to the database on sheet2.On sheet2 ...

Search and copy a whole raw to another sheet

Hello, Cany anyone help me out about a problem: I want to copy records (complete raw) from a Excel file contain several sheets (have thousands of ...

Web browser

Hello, i m jyoti doing mca , my question is if my computer not install internet explorer in window or i dont have net but i want to install ie then h...

Excel function

Hello, I am trying to look into 2 different cells for certain data and if it is true than put something in a third cell. For example: if C2 has an "...

Excel

Hello, if i enter in excel as 10-20 it showing me as 10 oct if i enter 20-30 it is giving me 20-30 plz solve my problem

Formula or argument in excel

Hello, I am looking for a formula to use so that when i pick a person's name from the drop down list a date will appear in the cell next to the nam...

Copy data into next empty cell in new sheet

Hello, I have designed a self-grading test. What I would like to do is have data (Name, Date & Score) saved on the next available row in a new sheet...

How to fill selected cells with given data?

Solved

Hello, I often need to fill cells with a date of production. What kind of a macro would be usefull in this situation so that I could just select the...

Copying a macro to multiple docs

Hello, Is there a way to copy a macro into multiple excel files at the same time without touching each file? I have a macro built and need to incor...

Combining information from 8 columns

Hello, I have a spreadsheet with 8 columns of data including the following headings Business Name, Street #, Street Name,Tel #, Contact Name, Cont...

Find a string in excel and remove all cells

Solved

Hello, I need to find a string (for example: abc) in a large worksheet then remove all cells containing this string. I have tried different functions...

Cut-paste row to sheet2 if columnvalue is met

Solved

Hello, I have got 2 sheets. Sheet1 contains a list of assignments, in which column B contains the status of those assignments. Sheet2 contains comp...

Macro for comparing between excel files

Hello, I need your urgent assistance, I have 2 excel sheets with the same format, "Master sheet" listed in column A, I have the serial No. from...

I want net browsing

Hello, I have nokia 2626 cell phone.i having net in my cell. how to connect net from my cell to desk top system. please give me information about c...

Excel formatting

Hey, Is there any way to have an entire rows font a certain color based on the value in the cell in the row next to it? I am trying to have the text ...

Videos and facebook chat stall my browser

So I've got a relatively new laptop and it has been working fine ever since i got it until this past weekend. I don't know what happened but now whene...

Excel help

Solved

Hello, I am having trouble with an excel calculation, i'd be grateful for any help: I have menu items listed along the top, with a space for th...

Getting perfomance of each vendor using excel

Solved

Hello, What I want is to get an evaluation of every supplier. Let say I have 20 list of supplier and list of product I'd ordered, including quantity...

Moving data from csv to excel ?

Hello and thanks for any help that might be provided, I was wondering if it is possible to grab data from a csv file that is updated by another pro...

Excel help

Hello, I want to make cell to display the date at the time a cell is populated by a name from a drop list. E.g. cell i3 to display the current d...

Excel conditional formatting

Hello, I have an issue with conditional formating. For any chance is it possible to set a conditional format for a date that every day changes. ...

Merging cells in excell

Hello, I have inserted a 0 before a number in one cell then i ahve merged this cell with another the result i get is losing the 0 example 1234 merge...

Excel Forum

Subscribe To Our Newsletter!