The discussions

Macro to add/remove rows based on highest # in group of cells

 Solved

I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....

1 reply Last reply on 4 Jun 2015 by
TrowaD

Insert row data on sheet2 based on sheet1 cell value(text)

Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...

5 replies Last reply on 4 Jun 2015 by
TrowaD

How to match 2 lists to get the unique entries

I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...

1 reply Last reply on 3 Jun 2015 by
xpcman

Calculate formula based on values for two dates

Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...

3 replies Last reply on 3 Jun 2015 by
Mazzaropi

Conditional formatting help

Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...

1 reply Last reply on 2 Jun 2015 by
TrowaD

Combining rows

Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...

1 reply Last reply on 2 Jun 2015 by
TrowaD

Conditional formatting based on range ofcells in different sheet

Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...

1 reply Last reply on 1 Jun 2015 by
TrowaD

Replacing a value using lookup table

Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...

1 reply Last reply on 1 Jun 2015 by
TrowaD

Copy specific cells to separate worksheets upon 2 conditions

 Solved

Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...

3 replies Last reply on 1 Jun 2015 by
vcoolio

Check if cells are blank or zero help please

I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...

2 replies Last reply on 1 Jun 2015 by
angieanguk

Help creating an automated sheet

I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...

2 replies Last reply on 31 May 2015 by
kc_74074

Based on date copy data and move total net down

How to move total net etc down based on the data filled above based on date If guest stay 2nd night second night data must me filled below first...

2 replies Last reply on 28 May 2015 by
Sunny

Change the cell color if the text in cell changes

Hello, How do I conditionally format in excel (i.e. change the cell color if the text in cell changes?) Thanks, JC Configuration: Windows 7 /...

1 reply Last reply on 28 May 2015 by
TrowaD

Give a text cell a percentage value

hello everyone; i am doing an evaluation report (checklist) and the output will be used as values for evaluate the service itself, soi created a sele...

1 reply Last reply on 28 May 2015 by
TrowaD

Copy certain cells when an option is selected

 Solved

Hello, Can anyone help me with a script to: Copy: cell A, Worksheet One to cell B, Worksheet Two; cell G, Worksheet One to cell D, Worksheet Tw...

14 replies Last reply on 27 May 2015 by
vcoolio

Arrow key now working.

 Solved

Hi, When i use the arrow keys using excel, the columns & Rows are being highlighted. How to unlock this? Can you help me to solve this?

2 replies Last reply on 26 May 2015 by
belle07

Single cell in my "work area" tab to be copied to a cell in the

Hello, I believe this is somewhat easy/straightforward but I don't know how to handle. I have a work book with multiple tabs. One of the tabs (spr...

1 reply Last reply on 25 May 2015 by
vcoolio

Date format

 Solved

Hello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...

2 replies Last reply on 23 May 2015 by
Mazzaropi

Help to insert a date using a macro in excel

 Solved

Hello, I have a spread sheet with four tabs. I have written a macro to copy the tabs and rename them but I need to be able change the date which u...

3 replies Last reply on 22 May 2015 by
Matt

How to hide and unhide tabs according to cell criteria.

 Solved

Hello, I have an Invoice that has a Rent To Own Sheet and also an Order Form attached to it. On my the Order Form tab I have a data validation...

1 reply Last reply on 20 May 2015 by
vcoolio

Vba

Hello. Asking for anyone who could please help me. I am an Environmental Science major with only one basic computer class from 2001. I have 2 major pr...

1 reply Last reply on 20 May 2015 by
vcoolio

How to import a range of cells from a different worksheet

Hello, Please help me to import a range of cells depend on the output cells generated on different worksheets on a page-2(in my folder the differe...

2 replies Last reply on 20 May 2015 by
mathewmunna

Data consolidation

Hi Team I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be d...

1 reply Last reply on 19 May 2015 by
TrowaD

Letters and numbers

Hello, Could someone please help. Is there a formula to convert A12812001 into 5/8/2015. A =2015 and 128 = the day. The rest of the numbers do...

1 reply Last reply on 19 May 2015 by
TrowaD

Convert number to word in excel

Hello, please suggest me the way to convert number to word

1 reply Last reply on 19 May 2015 by
Computertech

How do i populate worksheet tabs via a formula or macros?

Hello, I have a list of fifty different names I need to enter on the tabs of 50 worksheets (all on the same workbook). Is there a macros formula ...

1 reply Last reply on 19 May 2015 by
vcoolio

Change yyyymmdd format to mm/dd/yy in excel

Kindly give me guide to solve the change yyyymmdd format to mm/dd/yy in excel Santosh Mane

2 replies Last reply on 17 May 2015 by
eladeb

Excel vba format a range borders to crossed diagonal lines

 Solved

Hello, please help me to format a range of cells like if in a range a1:c10 if any cell eg: c1 contains a value c then format diagonal lines wit...

4 replies Last reply on 17 May 2015 by
MaxStart

How can i pull multiple information from a data sheet

Hello, I have a data sheet with hundreds of Packaged Products that have specific items in each one, and what I am trying to do is on another sh...

1 reply Last reply on 17 May 2015 by
vcoolio

Change numeric to word in excel

how to change numeric to word in excel

1 reply Last reply on 16 May 2015 by
Computertech

Copying conditional formatting to other rows automatically?

Hi folks, Could somebody good with excel please have a look: I have a problem. I want to color the whole row with conditional formatting. For e...

1 reply Last reply on 15 May 2015 by
MaxStart

How to get multiple tables from sheet 1 and transfer to another

Hello, i am trying to transfer data from one sheet to another. i have drivers so i want each initial to have its own table. can someone help me with t...

1 reply Last reply on 14 May 2015 by
vcoolio

Its about excel macros

Hello, I need to saveas some excel cell range as text file how to do it Any help will be appreciated Thanks in advance

3 replies Last reply on 12 May 2015 by
ac3mark

Compare two excel sheets in the same workbook

Guys ! I need your expert advise .I'm working on a crusie ship and at the moment I'm trying to compare 2 voyages (Passenger Lists) which has the same ...

3 replies Last reply on 12 May 2015 by
TrowaD

Macros, button that copies data from certain cells into table

Hello, I am trying to create a "database" table on one sheet to record data that was calculated on another sheet. The issue is the data calculated...

1 reply Last reply on 11 May 2015 by
vcoolio

Conditional formatting: 3 range of numbers

 Solved

Hello, would like to seek advice from some of the experts here. I want to do conditional formatting from column O6-O21. If percentage is a...

2 replies Last reply on 10 May 2015 by
LCC

Reformatting a date in excel

 Solved

Hello, I could really use your help with Excel. How can I change a date formatted like this...03/12/2004...to just reflect the month and year...0...

4 replies Last reply on 8 May 2015 by
Bert

Struggling with dependent text or list display in cell

Hi - thanks for reading I'm not sure if this is possible but I'd like to get the following to work: - Cell A1 contains a small pick from list -...

1 reply Last reply on 8 May 2015 by
MaxStart

Expiration date search, copy to sheet2

Hi! I have a spreadsheet with dates in column C starting at C7, and other info to do with the dates in columns A through L Im wanting to have a c...

1 reply Last reply on 8 May 2015 by
vcoolio

Copy data from one sheet in a workbook to another sheet

Hi, I'm trying to copy one sheet automatically in one workbook to multiple workbooks. For example the workbook is May 2015 Sales Numbers and the S...

1 reply Last reply on 7 May 2015 by
MaxStart

Get a percentage in microsoft excel

 Solved/Closed

Hello, I am trying to get 10% of a number in another cell. rather than doing it in my head, I was hoping someone would know the formula. If you do,...

Last reply on 7 May 2015 by
kb

How to use name range..please help to solve this issue..

 Solved

Hello, i have a excel work book which has few name ranges eg namerange1, namerange2, namerange3.. how i can display the resultant like if column e...

4 replies Last reply on 7 May 2015 by
Mathewmunna

Automatically syncing data from my master sheet to individual sh

Hi, What would be the procedure for automatically Syncing Data from my master sheet to Individual Artist sheet. I basically would be enteri...

1 reply Last reply on 6 May 2015 by
vcoolio

How to change date in order of dd/mm/yy in excel 10

Hello, I want a solution for this!?! pls Configuration: iPhone / Safari 4.0

1 reply Last reply on 4 May 2015 by
MaxStart

What it mean rs = 7: sheets(f1).select

Hello, im stater excel vba i see this code and im not clear what it mean please any one explain me.

1 reply Last reply on 3 May 2015 by
MaxStart

Excel master list

Hello, I will be creating a spreadsheet with lots of text data, addresses, phone numbers, names, ect. I have all the data set up in rows so I will j...

1 reply Last reply on 1 May 2015 by
MaxStart

Excel vba input data to next empty range

HI everyone, I am excel vba stater I have crazy problem to solve. I want to input data into range j6 by use inputbox and if j6 had value next input wi...

1 reply Last reply on 1 May 2015 by
MaxStart

Exam layout help

 Solved

Hello, I want to display a classroom layout on sheet 2 using a list of names from sheet 1 I'm sure it's possible, I just don't know where to sta...

8 replies Last reply on 1 May 2015 by
addseo1115

Conditional formatting cell if every cell contains "yes"

 Solved

Hello, I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 i...

2 replies Last reply on 1 May 2015 by
LizzyDashwood

Replacing any alphabet with c, and number with 0 in an alphanume

Hello, I have huge list of alphanumeric string in each row. And I want to replace any alphabet with C, and number with 0 in an alphanumeric. e.g I...

1 reply Last reply on 30 Apr 2015 by
TrowaD
Results 2451 - 2500 out of a total of 7,066