Excel Forum
-
Writing rule in ms excel using vb [Closed]
Hello, my question is...i'm having huge customer list mails in the format ******@***.es.us ******@***.es.in ******@***.net.us ******@...
-
how to expert office excel work [Closed]
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...
-
Conditionnal formating for more than 3 colors [Closed]
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-...
-
merging more cells into one cell [Solved/Closed]
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...
-
how can calculate days between twodates [Solved/Closed]
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 ...
-
How to insert & resize picture automatically [Closed]
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...
-
Insert row with formats and formulas [Closed]
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...
-
recurring billing fee [Closed]
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...
-
organisation chart preparation [Closed]
Hello, how to prepare organisation chart Configuration: Windows XP / Firefox 18.0
-
Macro to count the answers in a table [Closed]
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...
-
Comparing sales [Closed]
Hello, I have two separate Excel spreadsheets (e.g. 2011 sales & 2012 sales) with the following columns: Customer ID, Customer Name, Product #, Sa...
-
Macro to download certain files from a webpage [Closed]
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...
-
changing cell formats based on another cell value [Closed]
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...
-
Transferring data from one sheet to another [Solved/Closed]
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 ...
-
convert text mixed numbers to spelling [Closed]
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, ...
-
what formula shall I use [Closed]
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...
-
VB script to read data from another sheet [Closed]
Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...
-
cell with cal/min [Closed]
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)...
-
Time calculations on a 24-hr clock [Solved/Closed]
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...
-
Auto notify or mail when Excel sheet updated. [Solved/Closed]
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 ...
-
Compare date in cell against dates in range of cells [Closed]
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 ...
-
Excel 2007 resetting cells to Date format [Solved/Closed]
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...
-
Transpose and Removing Duplicates at same time [Closed]
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...
-
Need a macro to sum range of cells [Closed]
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...
-
worksheet name input to move data from one worksheet to another [Closed]
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...
-
Excel - A macro copy to cell based on a specific criteria [Closed]
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...
-
conditional Formatting [Solved/Closed]
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...
-
Attendance tracker [Closed]
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 ...
-
Comparing two spreadsheet data [Closed]
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...
-
Simply cannot find an answer [Solved/Closed]
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. ...
-
saved excel will not open [Closed]
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...
-
Activity Reminder from Excel Column [Closed]
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...
-
VB issue with delete rows with specific values [Solved/Closed]
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...
-
Roster with each person getting their own weekly sheet printed [Closed]
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...
-
Macro Help: Copy Data from a Range of Sheets to a Master Sheet [Solved/Closed]
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: ...
-
Tagalog [Solved/Closed]
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...
-
How to convert number into text in Excel [Solved/Closed]
Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"
-
Camparing two coloumns in excel and copy another cell value [Closed]
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...
-
Adding a new entry into a list - Excel 2007 [Solved/Closed]
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 ...
-
Need help with macro for 2 worksheets [Closed]
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. ...
-
I need help getting info from one worksheet to copy to others [Closed]
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...
-
Hi, Need some help - Copy pasting and creating coments! Thanks [Closed]
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 ...
-
VLOOKUP range question [Solved/Closed]
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...
-
colour column based on dates [Closed]
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...
-
macro which can countif on multiple criteria and export result [Closed]
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...
-
Macros [Closed]
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 ...
-
New in MS Excel [Closed]
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...
-
Macro - concatenated cells until if finds a blank cell [Closed]
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 [Closed]
how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52
-
adding the same action to every second line [Solved/Closed]
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...
Subscribe To Our Newsletter!
