The discussions
Macro to add/remove rows based on highest # in group of cells
SolvedI 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....
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 ...
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...
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 ...
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...
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...
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...
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...
Copy specific cells to separate worksheets upon 2 conditions
SolvedHello 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...
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 ...
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...
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...
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 /...
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...
Copy certain cells when an option is selected
SolvedHello, 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...
Arrow key now working.
SolvedHi, 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?
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...
Date format
SolvedHello, I want to write date into following format like (25/05/2015) into 25 days 05 months 2015 year. Is it possible??? Thanks Configuration...
Help to insert a date using a macro in excel
SolvedHello, 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...
How to hide and unhide tabs according to cell criteria.
SolvedHello, 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...
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...
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...
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...
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...
Convert number to word in excel
Hello, please suggest me the way to convert number to word
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 ...
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
Excel vba format a range borders to crossed diagonal lines
SolvedHello, 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...
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...
Change numeric to word in excel
how to change numeric to word in excel
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...
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...
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
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 ...
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...
Conditional formatting: 3 range of numbers
SolvedHello, 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...
Reformatting a date in excel
SolvedHello, 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...
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 -...
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...
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...
Get a percentage in microsoft excel
Solved/ClosedHello, 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,...
How to use name range..please help to solve this issue..
SolvedHello, 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...
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...
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
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.
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...
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...
Exam layout help
SolvedHello, 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...
Conditional formatting cell if every cell contains "yes"
SolvedHello, 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...
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...
