Excel Forum
-
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...
-
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, ...
