Excel Forum
-
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...
-
Formula for correction [Closed]
Hello, The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15 please suggest for the correction Configuration: Windows / Chro...
-
SUMIFS function [Closed]
Hello, I am trying to sort the formula below =SUMIFS(Sheet3!$AI$15:$AY$22,Sheet3!$B$15:$B$22,$A142,Sheet3!$AI$4:$AY$4,D$2) the criteria_rang...
-
Clicking data in one sheet..Saving all those clicked in another. [Solved/Closed]
Hello, I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number ...
-
How can I filter data from two work sheets by matching values [Closed]
Hello, I have two Excel sheets. I want to copy name and address on D and E columns of sheet 1 from sheet 2 if both sex and age match.The first one h...
-
Creating new sheet when got into some event [Closed]
Please help me built macro like this : When i write name at "C7" and pressing Enter Button it will create new Sheet with the C7.Value.And it will d...
