Excel Forum
-
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...
-
Copy rows to total page Solved/Closed
Hello, I have an Excel spreadsheet with 13 worksheets. The first 12 worksheets are January through December. The 13th worksheet is a total. Each...
-
Creating a directional macro Solved/Closed
Hello, I am not familiar with writing macros at all. I created a form and I need a macro so that when I input data in a cell the cursor will automat...
-
MACRO Closed
Hello, Can any help me how to link the macro in one sheet to macro in another shee ? Regards, Kiran.M.K. 9738489792
-
Excel - delete rows when alike Solved/Closed
Hello, I am in need of a formula to solve this problem. I want it to find similiar cells and delete those cells from the worksheet. Here is a sa...
-
macro needed as soon as possible Closed
Hello, i m smith i need a macro to split the data in every 5th cell .I am giving you the data below as an example 1. 2. 3.Darlene Thornton 4....
-
Excel Issues Closed
Hello - HELP!! What I am trying to do is set - up a way of tracking costs in a month. So, if cell N52 contains a monetary value and A52 is 'January...
-
VBA Macro doesnt work on other machines Closed
Hello, I have a Excel program that i use which contain macro's for opening files and copying and pasting cells. However my colleague is using the s...
-
How To Create Macro to Search, Copy, & Paste Solved/Closed
Hello, Here's what I want to do. I have a worksheet with customer data by row and I also have a worksheet with an invoice I want to auto populate w...
-
Referencing cells in Excel with functions Closed
Hello I am trying to write my own Lottery Program in Excel. On the first worksheet I have all of the numbers (1 through 59) in a column and to the...
-
EXCELL Closed
Hello, i have 14 names i want to assign a number value to, like 1 thru 14 and when i input a number in a colum row the name appears in that cell. say...
-
excel formula help Closed
Hello, I want to add a column of numbers (only cells that contain data, there will be some that will be blank and then I want to get the percentage o...
-
Macro Code Closed
Hello, I want to write such a macro that if i click the button. if their are 50 sheet in work book and i want to copy paste all the sheets into one ...
-
comparison between two excel sheet Solved/Closed
Hello, i have two excel sheet with same value which i need to compare every day .with in same excel sheet i can compare easyly using conditional form...
-
need excell hel[p Closed
Hello, i have an excell book open with multipule sheets. the 1st sheet has all the master info, the other sheets are cells for production. on the ma...
-
help! new to excell Closed
Hello, i have an excell spread sheet with multipule sheets open. i need to select certain rows of information, copy the info and tell that informatio...
-
How to have Mixed References in Macros Closed
Hi - Newbie here.. (can hear the groans already :-) I am trying to use a macro to copy a set of cells. I have successfuly created a macro - the...
-
Excell Solved/Closed
Hello, I need a formula that will take the sum of a group of cells from a worksheet and apply them to a specific place on another worksheet. All i...
-
Linking Excel Data to Excel-Based Calendar Closed
Hello, Okay, here I go. I have a workbook which contains a tab (CalendarData) with information as follows: Column A - Name Column B - Apt # C...
-
Excel User forms Closed
Hello, I have created excel project database using excel Userforms. First request form capture the customer inputs and store in Request_database sh...
-
Excel Help Closed
Hello, I have two excel files in different path. Every week I have to copy the data from daily excel file to weekly excel file. Is there any formul...