Excel Forum
-
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.... ...
-
QUESTION ABOUT EXCEL FORMULA [Closed]
Hello, my question is i have two sheets in a file, in one sheet my own data and in second sheet i unzip a file and data app...
-
macro modification [Closed]
Hello, dear friend in my document column "L" has some numbers & formulas.if any cell has formula base in that i need to inset rows below that formula...
-
formula to fill cells with names from a list [Closed]
Hello, I have a list of names I want to insert into a table. No name can be duplicated in a row. I would like it to automaticlly fill the table from ...
-
I can;t watch media on any web browser [Closed]
Hello, I can't watch any videos on any website. If a website has video in the address bar then the it says page cannot be displayed. I cannot even ...
-
How do I wopy row while recording macro W2007 [Closed]
In Word 2003 I had a macro and put it on toobar to select table row, copy it, paste it so I got a new row below current one, in a flash. Highly repete...
-
Make a special report with Excel [Closed]
Hello, I have a worksheet in Excell and I would like to have different views/reports using the same data that I have in the first worksheet. I would...
-
importing images into excel [Closed]
Hello, I just visited the forum and it looks like you might be the one to ask: I have MS office 2007, and am exporting data from a web shopping ca...
-
filtering only certain columns [Closed]
Hello, I have to tables side by side in excel and I have autofilters at the top of each table(headers). When I filter by column in one table. It hi...
-
excel macro loop to insert pics into more cel [Solved/Closed]
Hello, Could someone please help me in writing a loop in this macro in excel : I have an excel sheet where it contains the name of the pictures in c...
-
EXCEL HELP combining info from2 sheets [Solved/Closed]
Hello, Hello, How can I match and combine records across two excel sheets. I have two excel sheets containing record information, about 6 columns f...
-
Auto e-mail from excel if a cell value is Yes [Closed]
Hello, I have a problem and need solution for it., I have a excel worksheet with the data as given below... Name Student no. Marks Send E-mail...
-
Excel if function [Closed]
Hello, Basically i've set up some conditionally formatted cells and i want an extra cell warning me of how many false cells i have. i want a cell ...
-
Excel formatting [Closed]
Hey All, I have a column of data in excel for example as below; ABC DEF GHI JKL MNO The list is faily exhaustive and I need to format the...
-
Excel 2007 Question [Closed]
Hello, I know it is possible to copy an Excel 07 sheet (#1) into another Excel 07 worksheet (#2) and keep the data in tact. What I want to know ...
-
[excel] color format [Closed]
Hello, I'm trying to color fill a subset of a row (A1 - A10) if A10 is a certain value, False statement from a =istext. Any ideas?
-
Please help me the VBA [Closed]
Hello, Excel sheet 1 have dump data and excel sheet 2 have feature name defined in second coulmn. I hv to define the array with some feature_nam...
-
Excel - Storing entered data [Closed]
Hello, I am a relative novice who knows what they want to achieve but is unsure how to get there. I work in a school and want all staff to compl...
-
splitting data in one column into rows [Closed]
Hello, I have a situation where as all of the data from a survey was down loaded into one column. Each block of 10 rows represent one response. I nee...
-
Columns comparison [Closed]
Hello, Please find the values in Column A,B,D,E Column A Column B Column D Column E AA 100 ...
-
Excel If Function over a range of dates [Solved/Closed]
Hello, Can anyone help please? I am trying to add a divisions column, which are taken from a date range in another column. i.e. I would like to add "...
-
Add cells, div by cells with value (Excel2007 [Solved/Closed]
Hello,can any help!(excel 2007) A B C ...
-
Excel Help [Closed]
Hi, I am looking for a macro that will cpoy and paste data if it mets certain contintions, Say i have two sheets of data in which sheet1 contains 3...
-
Excel Formula to show Zero [Solved/Closed]
Hello, I'm using the formula =A2/(A2+A3) in A4, same in B to AF, i need the A4 line to show a zeros when A2-AF2 and A3-AF3 do not have values in. ...
-
compairing two columns A&B [Solved/Closed]
Hello, column A column B 5000 4001 5001 4080 5002 4445 5003 4493 5004 4...
-
Excel formula converting time difference [Solved/Closed]
Hello, i want to know the excel formula...below iam giving the details, In table A is my starting time e.g.10.49 and in table B is my reaching time...
-
Macro for copying info from Worksheet 1 to 2 [Closed]
Hello, Could someone please help me!! I have a client list on Worksheet 2 and I need certain client info copied to Worksheet 1. I would like to mark ...
-
Excel File Recovery [Closed]
Hello, How Can I Repair My Excel File ? It Shows The Error "Excel found unreadable content in 'File Name.xlsx'. Do you want to recover the conte...
-
Conditonal formating of rows [Closed]
Hello, I have a table in excel 2007, where column b has entries of names e.g. John, Devid, John, John, Gilbert, Devid etc. The same name may repeat ...
-
deleting alternae rows [Solved/Closed]
Hello, I want to delete every alternate rows from my work sheet. I tried recording macro, but it only deletes a particular row as shown in macro bel...
-
Linking Spreadsheets [Solved/Closed]
Hello, I'm trying to set up a cell that will draw information from another spreadsheet using excel 2007 The spreadsheet I'm pulling the info fro...
Subscribe To Our Newsletter!
