Excel Forum
-
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...
-
sum certain cells in a column if corresponding cells of another Closed
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 Closed
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 Closed
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 Solved/Closed
Hello, 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 Closed
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/Closed
Hello, 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 Closed
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/Closed
Hello, 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 Solved/Closed
Hi, 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 ...
-
Comparing two spreadsheet data Closed
Hello, If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in between. The next sheet contains t...
-
Add-ins not show on excel 2010 Closed
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? Closed
Hello, 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 Closed
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 Closed
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...
-
Help needed with Excel Macro Closed
Hello, I have the following sheet: A B C D 1 XXX Monday 5-Jan 5 2 YYY Tuesday 18-Feb 0 3 ZZZ Wednesday 23-Mar 3 4 AAA Thursday 12-Dec 4 ...
-
Help on merging multiple excel files data Closed
Hello, I am trying to merge multiple excel files placed in a folder. all of them have same headers and similar pattern of data. the purpose of th...
-
Many Columns return into fewer columns. Solved/Closed
Hello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...
-
Formula to check for text in column Closed
Hello, I am trying to write a formula that searches an entire column for specific text, if it finds it, then add 1. There are three different text v...
-
MSOffice 2010 Solved/Closed
Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.
-
copy many columns and past it in one single column Closed
Hello, I am trying to copy many columns C,D, and G and paste them into on column B in the first blank cell in the same sheet and I will need to do the...
-
convertion of numeric to text Closed
Hello, I have used your program for converting numeric to text in excel but there is problem regarding when we are entering greater than 100000 (o...
-
Search for a text in a column when found copy cell above it Closed
Hello, Boy Results Ttstm063 Mark Earned Points Earned Boy Results Ttstm063 Mark Earned Points Earned Boy Results Boy Results Ttstm063 ...
-
Aline data horizontally in excel using vba or vbs Closed
Hello, ...
-
If and logic Closed
Hello, I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but le...
-
All permissions in protected and shared workbook disabled autom Closed
hello friends, Version: Excel 2007 OS: Windows 7 Professional Situation: I have a 1000 rows X 50 columns of data. Filters are applied on th...
-
Copy from one excel sheet to another Closed
Hello, I am trying to figure out if it is possible to copy from one sheet to another. Not the whole sheet, but rather I would like to put cells f...
-
Short cut to merge cells Solved/Closed
Hello, If there a short cut on the key board to merge cells in excel?
-
Macro to connect to Paste All Clipboard Excel 2007 Closed
hello, I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button ) The cell is A1 sh...
-
How can I lock the column in excel Closed
Hello, If I have a table or Excel sheet and I made a function in a cell A2 and drag this function to be coped in all column A and finally I wan...
-
Macro to sort clipboard Paste all function Closed
WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3R...
-
Updating Excel that has Macros Closed
Hello, How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. T...
-
Vlookup ? Closed
Hello, I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in ...
-
Convert numbers to text format: Closed
Hello, i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format ca...