Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...
Hello, I'm Salman i live in dhaka. i work in a company. some time facing many problem to office excel work. Pls told me to how to improve excel wo...
Hi, I need some help with conditionnal formating. I have 27 conditions and for each I need a separate color. 1,0-2,0 2,0-4,0 4,0-6,0 6,0-...
Hello, how to merge 3 cells into 1 cell? we tried and tried but we didn't get it.. even the formula, we don't know.. we are just a first timer. w...
Hello, I HVE TO CALCULATE THE DIFFRENCE IN DATE. e.g: there is a two coloums as per below, purchase requisition date purchase order date ...
Hello, Configuration: Windows 7 / Chrome 24.0.1312.57 Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details i...
Hello, I am curretly trying to write a macro, that will insert a row on the next available line, keeping the formulas, formats, (including some co...
Hello all, I was wondering if anyone knows a way to have Excel add a monthly billing charge to invoices. I need something that would automatically...
Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0
Hello, I have a problem in macro in Excel. I am working on a file that counts the number of responses (0 or 1) of a certain type under certain que...
Hello, I have two separate Excel spreadsheets (e.g. 2011 sales & 2012 sales) with the following columns: Customer ID, Customer Name, Product #, Sa...
Hello, I am trying to find a way to download a number of files that exist on a webpage (the names are in sequence, e.g. abc202, abc203, abc204...e...
Hello, I was having difficulty in solving this problem. say: I have a dropdown on A2, text1, text2, text3 when you selected text1 the format...
Hello, I have been using Excel for a number of years but fairly new to formula etc. I need a VBA code that can copy data from costing(raw data) to ...
Hello, i want to know how can we convert in excel the mixed numbers such as 1ZXV78 to "one ZXV seven eight".. can some one help on this task, ...
Hello, Hi morning! I Have a problem right now. Here's the thing. I' working on an Ms Excel. My data are the following: "Assigned Reg...
Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...
Hello, I want to calculate the (k)Cal/min in excel. I have a cell with start time defined in time and a cell with endtime (from a running session)...
Hello, I need a formula that I can apply to my spreadsheet that will calculate how much time it takes someone to complete a task. Everything is b...
Hello, We have a Excel which is saved to a network drive and used by multiple users. What I need is when somebody updates the excel sheet or puts ...
Hello, I am trying to use conditional formatting to highlight a cell if the date in that cell is the same or earlier than dates in the rest of ...
Hello, I have an Excel 2007 spreadsheet that is resetting all the data cells to Date format. Have anyone seen this before? I don't think I have a vir...
Hello, I have a spreadsheet with two columns. The left column is an eight digit house ID. The right column represents miles driven by individual...
Hello, I am a teacher from Greece and I want your help to gather information and sum from different worksheets in different workbooks to another f...
I have a worksheet that is identical in all values other than price. All data is collected on worksheet one. Work sheet one has a column where a...
Hello, how to split the data from state wise using macro ex: Location type month year state India email 12 2012 UP India email 12 2012 ka...
Hello, I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states B...
Hello, I want to know how to do this kind of table Let's say I have two teams under 2 supervisor with 7 employees/supervisor and what I want is ...
Hello, Please help me out on this issue. If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in be...
Hello, I have a spread sheet - column B lists dates for the last time a report for each product was completed. Each report is due every 28 days. ...
Hello, I got a shock when trying to open excel sheets. The message " THERE WAS A PROBLEM SENDING THIS COMMAND TO THE FILE" i can't open any saved exc...
Hello, I would like to reserve a column "B" on an excel spreadsheet to put a date in the field for "Next Activity Date". Then put the date in the...
Hello, I am using 2007 excel and have the VB doing 2 things: 1) looking at specific Column for EXACT values and deleting row 2) looking at speci...
Hello, Ive put together a spreadsheet for work, where we have a main page called roster, the whole weekly roster for all staff members goes onto t...
Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...
Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...
Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"
Hello Sir I have two excel files where I want to match file1 Coloum A with File2 Coloumn A If match found File1 Coloumn C cell value should copy to...
Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...
Hello, I've seen examples close to what I need, but I'm not an experienced macro person and I don't know how to tweak them to get what I want. ...
Hello, I have an Accounts Receivable worksheet for each year. I want to log each entry into the main spreadsheet and then into a separate worksheet b...
Hello, Getting a little stuck - would anyone know how to copy text/number from one cell and with one function: in a new cell create a comment AND ...
Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...
Hello, I'm having a hard time to figure out a formula that colour the column with respect to dates. Can anyone help me out on this please..here's...
Hello, I have to create a macro, which can count for me how many of different categories of services we have. there are around 20 main categorie...
Hello, I'm new to Macro's and now wanted to learn how to run a macro based on the column values. Eg: If in column D has a values and if D3 has ...
Hello, Morning! Anyone can help me? i dont understand what ive read in wiki about macros. i dont know how it works even in simple excel! Can y...
Hello, Please assist. Im trying to concatenated cells with text until it finds a cell with no text then it stops current continate then continues...
how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52
hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...