Excel Forum
-
Search Macro, copy and paste [Closed]
Hello, I need help creating a macro. The macros needs to search worksheet 1 for data, then copy and paste it to worksheet 2. Worksheet 2 has 3 ...
-
Excel Macro [Closed]
Hello, I have created a worksheet that I want to develop for a competition entry data collection. basically i want the 'entrant' to type in thei...
-
Excel [Closed]
Hello, I have basic knowledge of Excel. i am currently trying to link my data on my invoice Excel spreadsheet to another spreadsheet, which would ...
-
Temporarily highlight excel cell [Closed]
Hello, I would like to know the function of how to temporarily highlight a specific cell. I do not mean highlight it and have it change colors. I m...
-
Protect and email with a Macro in Excel [Closed]
Hello, I am trying to run a macro that will protect a worksheet, and then attached the file to an email. Here is the macro I am currently using to...
-
Problem with "Lastline" in VBA Excel 200 [Solved/Closed]
Hello, Let me start off by saying that I'm a VBA noob, and have never worked in it before. Basically, I inherited a spreadsheet which has a macro t...
-
unable to browse internet explorer [Closed]
Hi, I am unable to browse my internet explorer,yahoo messenger and real player although i can browse Firefox.Can you please tell me any solution for ...
-
Automatically filling cells froma different s [Closed]
Hello, I have a small problem with excel 2007 which i cant seem to figure out. I have a table of data which contains data like the one below for sev...
-
Sorting and Matching Columns in Excel [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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/Closed]
Hello, With the following VB code I have created a wordart object: Sub ShowMessage() ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "Even...
-
sharing workbook with macro [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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/Closed]
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/Closed]
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 [Closed]
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/Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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) [Closed]
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/Closed]
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/Closed]
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 [Closed]
Hello everyone, I have an Excel sheet with the folowing data as example: _______|_Product1_|_Product2_|_Product3_| Name1_|___15€___|_________|_...
-
EXCEL Linking Data [Closed]
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/Closed]
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/Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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/Closed]
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 [Closed]
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 [Closed]
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/Closed]
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/Closed]
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 [Closed]
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 [Closed]
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...
