The discussions
Changing cell formats based on another cell value
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
SolvedHello, 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
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
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
Hello, please provide solution , please find my requirement Sheet1 column name values A 1 B ...
Cell with cal/min
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
SolvedHello, 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/ClosedHello, 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
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/ClosedHello, 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
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
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
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
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
SolvedHello, 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...
Comparing two spreadsheet data
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
SolvedHello, 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
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
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
SolvedHello, 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
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
SolvedHi, 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
SolvedHello, 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/ClosedHello, 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
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/ClosedHi 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
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
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
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
SolvedHello, =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
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
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
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
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
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
how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52
Adding the same action to every second line
Solvedhi 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...
Sum certain cells in a column if corresponding cells of another
Hello, I want to sum certain cells in a column if corresponding cells in another column contain a certain letter. I have amounts in cells G2:G1...
Conditional equation
Hello, I am desperately trying to write a formula for the following: If C23 is less than 2 but greater than zero, then value of E14, and if not,...
Formula to measure percent of checklist complete
Hello, I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks...
If, then formula
SolvedHello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...
Counting between two given dates
Hello, I need help. I need to count on Excel 2007 between two dates including the start date and end date. But the DatedIF fdoes not work. and...
Convert date into month name
Solved/ClosedHello, suppose date has mention 1/1/09 and no month name then how to get the month name
Macro to copy data under matching column header
I am trying to write a macro to copy data from multiple spreadsheets and get the data to paste into the proper matching headers. Here is what I have s...
Copy excel 07 sheet to other & keep formulas?
Solved/ClosedHello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...
Excel - active x combobox, selecting sheets
SolvedHi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...
Add-ins not show on excel 2010
Hello, Please , somebody can help me with this wrong I follow all the step for add an add-ins on excel 2010 , But this not appear What i...
How to recover excel password?
ClosedHello, I can't able to open my excel file, i have lost my excel file password please suggest me how to open my excel file and how to recover excel f...
Calculating sum of the amounts of each airports automatically
Hello, I have TWO tables such as below,according to the First Table :the first column (Airport name) the second column is ( the amounts in USD) ...
Creating macro to copy data from one wb & save to new wb
Hello, I am very new to creating Macro's and need some assistance. I have a large report with data for several different campuses. I'd like to cre...
