The discussions

Cell blocking

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...

1 reply Last reply on 15 Sep 2015 by
TrowaD

Vba for copy/paste a tutor perhaps....

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 ...

1 reply Last reply on 14 Sep 2015 by
technicgang

Comparing sales of mondays

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...

1 reply Last reply on 14 Sep 2015 by
ac3mark

Convert mm/dd or mm/dd/yy or mm/dd/yyyy to excel internal format

 Solved

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...

1 reply Last reply on 14 Sep 2015 by
ac3mark

Ô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 ...

Last reply on 14 Sep 2015 by
Ambucias

How do i lookup a value in say column and in returning the found

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 ...

1 reply Last reply on 14 Sep 2015 by
Mazzaropi

=if(f21="ctf",i21*15,if(l21="ctf",o21*15,if(f21<>"

 Solved

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*...

1 reply Last reply on 13 Sep 2015 by
Mazzaropi

If function for "specific date" + 15 calendar days

 Solved

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 ...

11 replies Last reply on 11 Sep 2015 by
j1969c

My compliments, great altruism everybody! great forum!

 Solved

Hello, everybody in the forum! My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated! A big hello, especially t...

4 replies Last reply on 11 Sep 2015 by
j1969c

=if(f9:f46="ctf",i9,"")

 Solved

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...

1 reply Last reply on 11 Sep 2015 by
Mazzaropi

Conditional cells filing

 Solved

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...

2 replies Last reply on 11 Sep 2015 by
Branok

How to use a single part of a cell's date

 Solved

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...

2 replies Last reply on 11 Sep 2015 by
TheMarcus

Find number (1), in like 12,15,31 ans.should be 3

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

1 reply Last reply on 11 Sep 2015 by
Mazzaropi

Help in merging codes

 Solved

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...

2 replies Last reply on 10 Sep 2015 by
smuneeb

Function has too many arguments...

 Solved

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 ...

1 reply Last reply on 10 Sep 2015 by
venkat1926

Search for multiple substrings and return different values

 Solved

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 ...

2 replies Last reply on 9 Sep 2015 by
jotied

Need help with data sorting

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)....

1 reply Last reply on 9 Sep 2015 by
ac3mark

Spreadsheet data

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 ...

1 reply Last reply on 9 Sep 2015 by
vcoolio

Filers

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 ...

2 replies Last reply on 8 Sep 2015 by
Brenda

Data storing by click.

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...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Creating a macro that does not copy amount of rows from file

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...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Formula for correction

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...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Sumifs function

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...

1 reply Last reply on 8 Sep 2015 by
TrowaD

Clicking data in one sheet..saving all those clicked in another.

 Solved

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 ...

4 replies Last reply on 8 Sep 2015 by
sram

How can i filter data from two work sheets by matching values

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...

1 reply Last reply on 7 Sep 2015 by
RayH

Creating new sheet when got into some event

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...

4 replies Last reply on 7 Sep 2015 by
TrowaD

Same date in column a on mutiple lines in seperate worksheets

 Solved

Hi, Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multi...

3 replies Last reply on 7 Sep 2015 by
TrowaD

Transfering the numbers with some calculations inside

Dear, i want to reformulate some data from an excel sheet to another with other columns titles. the order of the rows are different also. i added ...

1 reply Last reply on 5 Sep 2015 by
smuneeb

Icon sets in excel

 Closed

Hi, How to create icon sets K Column. how to create formula for icon sets ("K" COLUMN). I want Icon sets Green, Yellow, ReD.

Last reply on 5 Sep 2015 by
vcoolio

Transferring data between sheets using macros

Hello, I am having difficulty getting this to work. My original intention was to use a For Loop with an If check, but here is what I am trying to ...

1 reply Last reply on 5 Sep 2015 by
vcoolio

100-1=99 then 99+1=100

Hello, Good day. I want to ask something because i can't do this on my own. i want to minus D18 - D21 = H20 (100-1=99) ...

1 reply Last reply on 4 Sep 2015 by
ac3mark

Macro to copy data from master worksheet to new sheets

Hello, I hope everybody here are doing fine! Please, if anyone could help me with a macro for one of my Master reports. I don't really know muc...

1 reply Last reply on 3 Sep 2015 by
ruthf8

Change date format in excel 2007

Hello, I want to change date format in excel 2007 as given below please help me. now it is 09/01/2015 but i need (ddd mmm yyy 01/09/2015) like ...

1 reply Last reply on 3 Sep 2015 by
xpcman

Please help in getting data clubbed in one cell

 Solved

Please inform how to get the following information clubbed in a row Data as follows Required data in a ...

3 replies Last reply on 3 Sep 2015 by
TrowaD

Master sheet to work sheet,

 Solved

I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...

29 replies Last reply on 3 Sep 2015 by
vcoolio

Macro to copy data from multiple sheets onto single sheet

Hello, I have multiple sheets that contain basically identical data and I am trying to extract certain parts and place it onto a single sheet. The ...

3 replies Last reply on 3 Sep 2015 by
vcoolio

Vb averaging random fields in excel 2007

Thanks very much for help on this . . After finding a row based on a field value, I need to get the value from a different field in that row . . ....

1 reply Last reply on 2 Sep 2015 by
ac3mark

Using partial text in a field, color the row

Thanks for help on this . . . Using the last 2 characters in a string in field GFi, color that row . . next row Example: for all rows with...

1 reply Last reply on 2 Sep 2015 by
ac3mark

Accounts data requires automatic analysis

 Solved

Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

2 replies Last reply on 2 Sep 2015 by
249ccjames

How to autogenerate a new daily report

I have a daily report made up in Excel containing daily (manually entered) data, and "to date" (computed in Excel) data. I would like to be able to...

2 replies Last reply on 2 Sep 2015 by
aldeane1

How to create auto populating multiple sheets based on cell

Hello, I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I sele...

1 reply Last reply on 1 Sep 2015 by
TrowaD

Custom sorting & calculating average based position

 Solved

please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

2 replies Last reply on 31 Aug 2015 by
oluwaridenawa

Search word from list, match it copy values next to it

 Solved

I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

2 replies Last reply on 31 Aug 2015 by
haris1989

Sum value of one column if in another column there is a text

Hello, I am trying to sum values in column A if in column B there is a certain number. So, Column A 10 20 30 40 50 Column B E45D...

1 reply Last reply on 31 Aug 2015 by
Mazzaropi

If cell have specific text it give us alert message

Hello, If cell have specific text it give us alert message Configuration: Windows XP / Chrome 44.0.2403.157

1 reply Last reply on 31 Aug 2015 by
TrowaD

Transpose data in single column into 4 columns

Hello, I have data in a single column and would like to transpose it into a row for every 4 rows. I have about 7000 rows in the 1 column. I'd l...

1 reply Last reply on 28 Aug 2015 by
Mazzaropi

Compare 2 columns choose answer in third

Hi all, First of all thank you for reviewing this. I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have...

1 reply Last reply on 27 Aug 2015 by
xpcman

Macro-copy data from one workbook to another

 Closed

All, I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has 1 2 3 4 5 WB2 (target) al...

Last reply on 27 Aug 2015 by
Dvibe

A macro to change the values on a specified cell

Hello, I am searching a macro code on excel to set a value on a cell that is found by using such an excel function =ADDRESS(MATCH(N7,'Sheet1'!...

1 reply Last reply on 27 Aug 2015 by
TrowaD

Copying cell information

Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The informatio...

1 reply Last reply on 27 Aug 2015 by
TrowaD
Results 2251 - 2300 out of a total of 7,066