Excel Forum
-
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...
-
Excel Formatting Closed
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 Closed
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/Closed
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/Closed
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 ? Closed
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 Closed
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 Closed
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 Closed
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...
-
Unable to download using all browsers Closed
Hello, I have come across a strange problem.I am unable to download anything(files/attachements) from whatever browser i use.The moment i click the...
-
Excel Forumla help (IF formula) Solved/Closed
Hello, I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grad...
-
merging of more than one excel files Closed
Hello, I done the merging of more than one excel files using macro concept... but i can't able to implement with the vb or any language.... ...