Excel Forum
-
sum different alphabets in an excel range. Solved/Closed
some one please help me......how to sum different alphabets in an excel range..........example.....range is ...A!:Z1 and i want to sum "P" and C...
-
Macro to copy rows of data off of a sheet into several different Closed
Hello, i'm new to these forums and new to writing macros, I've been trying to find a solution to my problem but haven't found one yet. I need a ma...
-
comparison of two table Closed
Hello, I need to compare the two table values and return the result as true or false based on two table value in another table . It should be high...
-
Auto-running macro when cell is changed. Closed
Hello guys, I am using simple macro for one sheet (ControlSheet) to hide rows, in which certain cell (B11;B51) contains text "Corrective Action not ...
-
If Then rule with dates help Closed
Hello, I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a Sund...
-
Transferring data to successive worksheets Closed
Hi I have a excel workbook containing several worksheets. To keep things simple Sheet 1 contains a column headed Dates listing 36 weekly starting dat...
-
copy data and paste using vba Closed
Hi, I've two files, I would like to copy the data and not able to do so. Source file: Multiple rows (some times has 60 rows sometimes 80 with fe...
-
Macro to rearrange data in excel- merge 3 cells and move sheets Closed
I am just starting to use macros and am lost on figuring this out. Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom lef...
-
macro to delete rows matching certain column criteria Closed
site: https://ccm.net/faq/6261-excel-a-macro-to-delete-rows-with-specific-values I have reviewed this VBA code and it keeps getting stuck when it ...
-
How to reference Excel information onto other sheets Closed
Hi, I have imputed all the information onto excel sheet 1, now I need to consolidate all the information from this sheet onto another excel sheet 2...
-
Help. Difficulty with adding a new row Closed
Hello, so I am working on a payroll excel sheet which pretty much tallies up the number of hours that each employee does bi-weekly. On my first worksh...
-
Macros for counting the record count of each sheet Closed
Hi , Anybody plz help me in writing macros to prepare summary of records i will be uploading txt files into excel each file will have header and...
-
Conditional Formatting as a text Closed
I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement... if the cell = 7, I want a text to com...
-
Macro with variable rows Closed
Hi I am very new to macros and trying to record (rather than write through vba) a macro that can be used each week. The purpose of the macro is to f...
-
cell blocking Closed
Hello, i need to block the cell after entering data to it which means i need each cell to accept entry one time only note.the worksheet must be pr...
-
Change date format Closed
Hello, I want to change date format from D/MM/YYYY (as it's being downloaded from a google form) into YYYY/MM/DD but I can't get it to work. A...
-
Table relation Closed
Hello, Ok This is the scenario, I've a excel sheet, with inside 2 sheet. In sheet1 i've a table with some some datas. In the collum B there ...
-
Coping one cell values into different excel sheets by different Closed
I have one cell vales. I want to store that value into different cell in different sheet. Suppose I have 10 in cell A1 from sheet 1 today which will ...
-
VBA for copy/paste a tutor perhaps.... Closed
First of all, Excel is not new to me, and although I am not fluid on creating pivot tables, I can create some pretty awesome formulas on my own...and ...
-
Comparing sales of Mondays Closed
We have an excel spreadsheet of sales for the year. The headings are Monday thru Friday. The rows are labeled for different categories. We would li...
-
Convert mm/dd or mm/dd/yy or mm/dd/yyyy to Excel internal format Solved/Closed
I have looked at dozens of articles, but they all talk about converting different forms of mm/dd... etc. to other similar forms. I want to chart bloo...
-
Ôter la protection Closed
Bonjour tout le monde, j'ai un problème qui me bloque depuis un bout de temps, je veux ôter la protection des structures et fenêtres pour un classeur ...
-
Macro Closed
Hi Team, I wanted to create macro which can select some data from cell A1 (not whole cell) eg if i have 10 characters in cell A1 i want select only 5...
-
How do I lookup a value in say column and in returning the found Closed
Hello, How do I lookup a value in say column and in returning the found value replace the it with a typed value. An example is; a b ...
-
Google sheet Help required Closed
Hello, i want to print some 18 document in Google sheet as a PDF format. i want to create a formula, by which. If i enter the default value in ma...
-
=IF(F21="CTF",I21*15,IF(L21="CTF",O21*15,IF(F21<>" Solved/Closed
Hello, I am at the crossroads with this functions string (doesn't work) any help will be much appreciated... =IF(F21="CTF",I21*15,IF(L21="CTF",O21*...
-
Convert numbers to Word format in Rial Omani currency Closed
Hello, I like to Convert numbers to Word format in Rial Omani currency, say for example - 8,823.200 should be written as Rial Omani Eight Thousand...
-
Sheet1 value in Sheet 2 Closed
Hello, I have different DATA in a ROW of various Column of sheet1 (for specific date). Now in Sheet2, I have to use these DATA in various places. ...
-
how sum the total for paticular value Closed
Hello, we have the stated contains as below Region product amount sales Chennai apple 1,854.00 * Delhi apple 4...
-
IF function for "specific date" + 15 calendar days Solved/Closed
Hello, maybe you can help with the following... I am looking for an IF function that alerts me to "PAY NOW" or to "HOLD" as follows; PRODUCT ENTRY ...
-
My compliments, great altruism everybody! Great forum! Solved/Closed
Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...
-
Macro copying data to another workbook Closed
Hello, After running the macro, WB2 doesn't have 6 7 8 9 0 1 2 3 4 5 WB2 has 1 2 3 4 5 http://ccm.net/faq/7565-excel-macro-to-copy-d...
-
=IF(F9:F46="CTF",I9,"") Solved/Closed
Hello, I would appreciate any help regarding the above formula - =IF(F9:F46="CTF",I9,"") - I am trying to compute a scheme where if any cell betwe...
-
Conditional Cells Filing Solved/Closed
Hello guys :), I use Excel 12. What I need help with is a conditional filling of cells, based on values in different cells/in the certain row. I l...
-
how to use a single part of a cell's date Solved/Closed
So that's the scenario, I've a date in a Cell (D4) in the format 02/02/2008. I need to compare only the year of the date (2008) and if it's true re...
-
Find Number (1), in like 12,15,31 Ans.should be 3 Closed
Hello, Find Number (1), in like 12,15,31 Ans.should be 3 Any formula to count number Configuration: Windows / Chrome 45.0.2454.85
-
Conditional Formatting for dates Closed
Hello, Hey there, so what I am trying to do is: I have a range of fruits that we grow. All of the fruits have to be tested at certain times. A ...
-
Help in Merging Codes Solved/Closed
Hi I need help in the following VBA (Macro Codes) in Excel 2013 Code 1: Private Sub Worksheet_Change(ByVal Target As Range) Dim Inva...
-
Help Please For Auto Fill Closed
Hello, Hi I have one sheet with 100 row and every row have 3 cell i want crate auto sheet with copy in first sheet set a1 from row 1 cell 1 a2 c...
-
Function has too many arguments... Solved/Closed
Why is excel telling me that this formula has too many arguments? =IF(TODAY()>=B9+15,"PAY NOW","HOLD",IF(u9="PAID","PAID")) I am stationed on ...
-
Search for multiple substrings and return different values Solved/Closed
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string ...
-
Need help with data sorting Closed
I have 2 columns , one which contains values ( the invoice amount) i send.. The other column will have another list of values ( funds credited to me)....
-
Search for multiple substrings and return different values Closed
I have a cell I2 which contains long string. I want to find out the following: If string in I2 contains "month", then return "Monthly", If string in...
-
Spreadsheet Data Closed
Hello, I would like to know how to set up a formula so when I enter a certain value or text into a cell i.e "C" all of the information in that row ...
-
If condition Closed
Hi I need to do use IF condition for multiple cell check in a column E.g, of my data as below . I need the answer in Column Z like if the data ...
-
comparing sheets Closed
Hello, I need help comparing data in Excel 2007. Here is the situation, I'm using an aging report and in sheet 1 column A I have the invoice numbe...
-
Filers Closed
Hello, I added filters to my excel spreadsheet and saved, however, when other people open it sometimes the filters are no longer there. What could ...
-
Deleting tables with macros Closed
Hello, I've got a long dataset. At some point in the sheet there are tales that start with a row with a text in the first cell "Please specify"...
-
Data storing by click. Closed
Hello, I'm working on excel which has assembly numbers. I've assembly names and corresponding numbers by side for each assembling we do. I'm looking...
-
Creating a macro that does not copy amount of rows from file Closed
Hello, I am trying to create a macro that does NOT copy the amount of rows in the file the macro was recorded in. For example: The macro is sp...