I was wondering if there was any way to do a cell format so that if I type in a word in sheet1 say "mike" on sheet2 the word "mike" cell would be highlighted? or if there is a formula you could use to do that.
View 14 RepliesI have 2 sheets in a work book both contain the customers address if I leave a line not type on on sheet 1 then it will put a 0 on sheet 2 is there a formula to stop this happening.
View 3 Replies View RelatedWhat is the correct method to duplicate the last sheet when using Sheets.add Type: (how to finish this statement to have the newsheet be the same as the preceding sheet)
View 9 Replies View RelatedI am trying to figure out how to not allow a word to be type into a cell. I am relatively new to excel and I am working on a spreadsheet where I do not want the word TOMORROW to be allowed in a cell.
I have a list of asset data (columns A:Z and over 20,000 rows).
I want a macro to find the word TAG in column F then cut off the entire row for all that meet the criteria and paste in another sheet. So I can see both sheets.
First off I have an excel sheet that I have split into two windows. excel sheet.jpg
I am looking for a formula that will change the bottom sheet number a color if it exists on the top sheet.
I need to convert numbers to text in excel 2007. I have done it before in 2003, but can't seem to remember exactly what I used. I may have used some kind of conditional formatting, but not sure.
Here is an example of what I need.
If I type "7203" in a cell I want "Home Repairs" to appear. I have a list of words associated with a list of numbers and want to be able to type the number in a cell and have the word appear.
I would Need a macro which would Search a Keyword in the excel sheet and copies and pates the data in Cell "A2". for Example "Market" and then after the search it copies 12 rows upwards and 10 columns from the Cell that the word "Market" is placed. And then it copies 12 rows downwards and 10 columns from the Cell that the word "Market" is placed.
I have tried recording the same but it does not work if the Word "Market" is placed in different cell value.
I have a worksheet with a list of four digit codes that are colored. On a separate worksheet (in the same workbook,) I would like to be able to type the four digit code in, and have it return the color I have the cell turned. E.g., I have a cell with 8810 colored green on one sheet, and I need to be able to type that code on another sheet and have the cell turn green. Is this possible? The codes are all random, with three different colors to choose from, so conditional formatting is probably not the best solution.
View 5 Replies View RelatedI am trying to reference a cell in sheet All Employees in sheet Brock. This is an employee training database.
Currently there is no data in the cell I want to reference (B9).
When I use the formula ='all employees'!b9 the cell in the brock sheet shows "january 00 00" even when the referenced cell is empty. This problem is eliminated if I formate the Brock cell to General. It then displays a zero.
However, the cell in the All Employees Sheet is going to be a date. If I format the Brock cell to general, when I enter a date in All Employees, it gives a large number, not a date. This problem is eliminated by changing the formating of the Brock cell to Date.
What I would like to do is be able to type the date in the All Employees sheet and have it magically transfer to the Brock sheet without any additional work. I would like the brock sheet to be printable, and with January 00 00 written all over it, not only is it messy but its incorrect.
I have locked some cells on my Spreadsheet so other people can not change them. What I would like to know is how do I change the colour of the font? I also would like to Bold/unbold the font.
View 6 Replies View RelatedI have inherited a monstrous speadsheet on which all data appears on a single sheet rather than being broken up across several sheets in some logical fashion.
One portion of this monster is a set of quite a few form letters, each of which reference various cells elsewhere in the spreadsheet.
I want to move all of these letters, together, to another tabbed sheet as a first step in reorganizing the monster.
Simply copying and pasting the cells or columns doesn't work. It fails in different ways depending on which pasting options I employ.
A very simplified version of my problem appears on the 5 sheets of the attached file, with what I hope is just enough further detail about the difficulty.
By the way, I also tried using the "Insert Copied Cells" option when pasting but since this failed with the exact same results as one of the other options I didn't include the results in the example shreadsheet.
i'm trying to delete a specific type of chart from the active sheet using this macro:
View 2 Replies View RelatedHow can i convert excel sheet to word A4 sheet.. i tried copy paste but the format changes.
I create a monthly excel sheet regarding customer & their payment
like this..
Suppose..
Month January 2007
Customer A 2000
Customer B 2000
Cust C 3000
Feb
Cust D 3000
Cust E 4000
Cust A 2000
Mar
Cust B 2000
Cust A 2000
Cust G 4000
Now, I want to do somthing like that If a customers Name repeat in another month, I mean Cust. A name has been already entered in Month January & if it comes again in february then it should be automatically replaced or highlight with red line Or something like that.
I want to search for a word say "Output" in a Column 7 in one sheet and return the value present in the Upper cell of Output Cell and its adjacent cell to a cell in another sheet example:
Yes 10
No 20
Output Value
Here i want to search for word "output" in a column and return the above value "No" and its corresponding value "20" to a cell in another sheet.
i have a directory of words file with same format, how can i insert this files to excel sheet?
for example attach tow files,
Code: [URL]...
Code: [URL]....
Is there a way that I can Conditional Format a cell is it has a particular word in the value that is in the Cell?
I'm looking to CF where Cell Value is like Duties:
I would like to attach a pdf (or word) file inside an Excel sheet so that it is seen as a pdf icon or word icon when viewing the sheet. Any of you who knows if this is possible and how to do it?
View 2 Replies View RelatedI have a sheet called 'TimeRecorded' which will contain lots of rows of data.
If a row contains 'invoice' in column H, then the data in that row, preferably as far as column H, should be moved to the next blank row in a sheet called 'Archived'.
I would like the macro to move every row that contains 'Invoice' in column H to be moved.
I want to write a macro for conditonal formatting
I want to highlight any cell containing the word "If "
I have one problem with my excel table exportation to .docx word document. I got 2 questions.
1) When I paste a Cell Range from my excel, it pastes well but leaving a double line spacing between the rows and I don't know how to re format this table for just having normal line spacing between lines.
Code:
Dim order_num As String
Dim last_row As String
Range("I100000").Select
Selection.End(xlUp).Select
last_row = ActiveCell.Row
[Code] .......
2) How can I bold normal text into a word ?
I have 10 worksheets in my workbook. The two that I'm concerned with in this post are "Main" and "Completed".
If Column AA in "Main" contains the word "Complete" (which is from a drop down list) I want to copy the entire row from "Main" and paste in the "Complete" sheet without over-writting previous pasted rows.
Back in sheet "Main" I want the data in that row to be cleared with the exception of Column A as it contains a formula for sorting blanks. If I delete that row it will mess up my links on other sheets.
I need to read A1 Rows and if it's values is bold letters then i have to add from top of it's above un bold members like that the should work for 2000 rows Like below Ites income - (A) vlues need to be added from row 3 to row 9
A) ITES
ITES Income
B P O - Domestic
4000101
[Code].....
I want to be able to create shortcuts for cells by using abbreviations. i.e If I wanted a cell to come up as "Food Services" all I would have to do is type in "FS" rather then the entire word or continually using copy/paste for the various abbreviations. Is this possible through excel or would it be best to be done through ms access?
View 4 Replies View RelatedI have two Sheets, first is Service Data, the second is Log Sheet. In the Service Data sheet I have a column of serial numbers in column A. I also have a column of serial numbers in the Log Sheet, column A.
I'm looking for a conditional format whereas I enter numbers into column A on the Log sheet it will auto highlight the cell if I duplicate a serial number from row A in the Service Data sheet. I would like it to highlight the Duplicated number on the Log sheet. I know new versions of excel make it easier to do this but unfortunately I have Excel 2003.
I have 2 workbooks in Excel 2010, each contain just 1 sheet. (see attached) I need to compare on sheet 1, cell D1 and column A:A (this column will be much longer), with the data in columns C:C & A:A on sheet 2, if a corresponding match is found, the data contained in column D on the same row on sheet 2 is written to the cell with the matching data in sheet 1.
My attempt is in cell D2 on sheet1.
I have workbook that has several sheets within the workbook that are set up identical. Each of the sheets in the workbook are for a specific company.
As of right now I have been adding a sheet to the workbook that is an overview for what is in each sheet (the individual companies). Currently I am doing the formatting of the heading and column names manually and I pull the data from each sheet with a VLookup. I have been trying to enhance my VBA skills with coding something that will fill in the appropriate cells from worksheet to worksheet.
What I am trying to do is to populate an overview sheet with cells C24, C25, and B36 being static on each row per sheet. Then each row will be populated with cells C(36, 59, 70, 81), D(36, 59, 70, 81), F(36, 59, 70, 81), G, and H(36, 59, 70, 81). The overview sheet will have the diagram below in a ru
I attached an example : example.xlsx
Sheet 1
C25
C24
B36
D36
C36
F36
G36
H36
I36
[Code] .....
i have a workbook that has a lot of sheets but i need to pull information from the one sheet "Veneer Log" i Need it to make new sheets with the same heading as on the "Veneer Log" (Rows 1 & 2) Sheet but it needs to be filtered by the "Product" Column (H) with a new sheet made for all the diffrent products i.e. Dimensional, Drywall, Corners - Thin V., Accents,..... so each product will have a new sheet with i am hoping someone can help me with this. This log changes Daily and it would be nice to have a sheet with only the same product on it to compare new orders so we can batch run. i hope i have given you enough information so someone can help me with this. i have attached a sample log the real log has about 10 worksheet for diffrent departments but i only need info from the Veneer Log Sheet.
View 14 Replies View RelatedIf I have a cell that has as its contents as sheet name, is there anyway I can use the cell's address to reference that sheet?
As an example, say I have in Sheet1, cell A1, the text Sheet2. And let's say I want to return the value of cell B2 on whichever sheet the text of A1 says. So, on Sheet1, I might have this: