building a worksheet to list people, payrates and hours worked etc. the header needs to have fill in areas that change with the job so I entered them in the rows rather than in a proper header. what I want to do is get rid of gridlines in the first 6 rows but
leave them intact on the rest of the document. I see templates that this was done somehow.
Is it possible to remove all gridlines (except in a table) and change the background colour to plain colour (except the table) in Excel 2010?
View 2 Replies View RelatedIs there any way to remove the first part of a string of text in a cell and save the second part?
The first part of the text string is a team code that has a variable number of numbers, capital letters and sometimes spaces. The second part of the text string is a variable number of words in a team name that all start with a capital letter and have lower case letters. Every line has a different team code and team name.
The original spreadsheet also has a column with just team code. Is there a way of using this column to "subtract" the team code from the text string to just leave the team name?
I have a spreadsheet with 2 worksheets. On the first "active parts" I have a list of active part numbers and on the second "All Parts" I have all of the parts available.
I want to compare every part in the All Parts worksheet to see if the part number exists on the Active Parts sheet - if it's there, I would like it to return the value "Active" in column B in All Parts. I have a formula in column B in All Parts that seems to work for the first few, but as soon as it finds one that is active, the rest of the cells below all return "Active".
I have a list of data that populates B2:B2900
This data is often prefixed by a 'reference code' that I wish to be removed.
Now rater than perform this manually aprox 3000 times is there a formula or some VB code that will complete this for me....
eg
The list of data is shown like:
SC7547-05 - Payne, Freda
SC8706-08 - Rungren, Todd
SC8714-05 - Travis, Randy
SC7517-03 - Beach Boys, The
Love Song
Now You're Gone
SC7512-01 - Horton, Johnny
SC8721-15 - Journey
So I wish for the SC7547-05 - to be removed from the first example to just leave Payne, Freda and continue this throughout the list
However if the data is found not to include this code (as in the 5th/6th examples above) leave it alone
So if the code of formula is run for the above the outcome would be....
Payne, Freda
Rungren, Todd
Travis, Randy
Beach Boys, The
Love Song
Now You're Gone
Horton, Johnny
Journey
I need to remove duplicate Part Numbers where other information in the cells will not match. In the following two examples, the only difference is that the COMP_ID: number is different, but for my purposes, the second example is a duplicate and needs to be removed. I have hundreds of rows of this type of information with various part numbers: ...
View 9 Replies View RelatedI have a simple sentence in cells C3, D3 and E3. The sentence in C3 is:
Find Airfare to Chicago, Airline Tickets to Chicago, and More | XXXXXXXXX®
D3 contains: XXXXXXXXX highlights outstanding airfares to Chicago from quality airlines and agencies. E3 contains my list of keywords: Chicago Flights, Cheap Flights to Chicago, Cheap Chicago airline tickets, chicago flight, chicago airfare, chicago airline ticket, chicago airline tickets
The XXXXXXXXX in the C&D cells is the client name which I had to blank out in order to post here. I wasn't sure if you guys would need to know exactly how many characters there are in each cell. In column B3 is the name of the city, in this case the city is Chicago. I have 8000 destinations so I need a formula that will take the city (or any information) in the B column and replace that in the C, D and E columns in the appropriate place. I've attached a small, representative file to demonstrate.
I have two sets of data and i would like to combine into one.
Problem is some may have duplicated part number.
My current method is copy & paste data from 2 different tab in to one and using data, remove duplicated to get what i needed.
UserForm1
Current OptionButton names are like ABC123, ABC 124, etc.
How can i change all names, with code - as i am not seeing a find and replace option within UserForms, to all but the "ABC" part, the result of the OptionButton names shall therefor be 123, 124, etc. - delete "ABC" or, find "ABC" and replace with
I have 800+ files the problem is that the file name ends in 80 different combination so I need to try all of those for each file.
eg: one of the 800 is "109 st no 103 av" the file could be called:
"109 st no 103 av nb1_cleaned.xls" or
"109 st no 103 av nb 1_cleaned.xls" or
"109 st no 103 av nb 1._cleaned.xls" or
"109 st no 103 av sb1_cleaned.xls"
.
.
.
.etc
I wrote a code to try all those combinations, the issue lies a space the code adds before _cleaned, how to remove it?.
So the name should be
"109 st no 103 av nb1_cleaned.xls"
but my code is letting it be
109 st no 103 av nb1 _cleaned.xls
Where the variable Ord is the "1" after nb.
Find the code below:
[Code] ....
What I would like to do is remove part of an email address from a cell.
Ex. if the was a cell that contained "someone@somewhere.com" I would like to make that cell only contain "@somewhere.com"
I'm a novice Excel 2007 user and appreciate all the help I can get. I have a workbook with monthly worksheets in it. When a certain data Type is selected from a drop down menu in that monthly worksheet than I would like to have it automatically enter specific data (Name, Date, Eval, Type) copied to another worksheet (CC) in the same workbook. I have been manually entering the data so far. Another thing, some of the data will be entered into the Monthly worksheets and some will only be manually entered into the CC worksheet so it would need to accomodate both methods of data entry. Please let me know if I need to clarify. I have attached the workbood, too.
View 11 Replies View RelatedIs there a way I can write a formula to get names from a different worksheet if I type part of that name in the active sheet.
Say Sheet1 contains cells like
1026 Wild hard nuts fruits -Named Fgl1026
1028 Wild Soft nuts fruits -Named Fgl1028
In active sheet, when I type Fgl1026, I want the next cell to left of the activecell to show Wild hard nuts fruits.
[img][/img]
I have "inherited" an Excel workbook from someone that is really unwieldy in presentation and difficult to read. I want to break it down and reorder some of the tables and information. To do this I need to copy/ cut parts of different sheets into others. When I do this, I'm finding that I get reference errors even though the source documents are the same.
View 3 Replies View RelatedI have a macro to loop through the files in a folder. The macro will then open up the files and copy over to a new workbook.
As I want to rename the worksheets created in the new workbook as part of the file name. Any idea how to extract the file name out and stored in a string?
Currently it will be named after the Cell A1 in the opened file. However I would like to rename as below.
Example, the file name : 030309_Mary Sales.xls, Worksheet Name to Create : Mary Sales.
File name : 030309_John King, Worksheet Name : John King
(in the code, 030309 taken from my menu sheet,D4 is the keyword , to search in files containing D4, where D3 is the directory to look in)
Sub RunCodeOnAllXLSFiles()
Dim lCount As Long
Dim wbResults As Workbook
Dim wbCodeBook As Workbook
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
On Error Resume Next
How to change part of an array value?.If i try to change array value "Microsoft Excel" popups a dialog stating "You cannot change part of an array."
Somebody have mention to use "Ctrl+Shift+Enter" but this will change entire array value.So I need a change only a specific cell value.
I'm not sure what I have clicked on, but I have no gridlines when entering data into my spreadsheet.
View 13 Replies View RelatedIs there a button in Excel you can press that will turn gridlines on/off rather than going through the tools/options/gridlines route?
View 6 Replies View Relatedif (a) gridline can be shown in a userform to make the appearance and readability more appealing and (b) if it is possible, how do make the gridline appear?
View 6 Replies View Relatedhow to change the color of gridlines from black to blue or red?
Is it possible to eliminate gridlines from only certain rows, columns and or cells? Specifically, I would like to eliminate the gridlines from the frozen columns and rows.
View 5 Replies View RelatedI have exhausted myself looking online before I came here and have come up short.
When I create a new workbook my gridlines are off and I have select to turn them back on everytime.
Not sure how it happened, but I lost all gridlines in Excel. I was working in a workbook this morning and something happened while in there. I have gone through options/advanced and my gridlines are colored to black. Then I have also highlighted the entire sheet and selected no fill from the Home Tab. Nothing is working.
View 9 Replies View RelatedI am doing a scatter plot of several columns and have the x-axis grid lines turned on. What is apparent is that the grid lines and tick marks are slightly off. In my case, when the point value is 6.004 the tick mark and grid line for the value 6 draws through that point.
I am using Office 2003. This was tried in Office 2007 as well with the same result.
Is it possible to show gridlines in some cells and hide gridlines in others on the same worksheet? Is it also possible to isolate a row or column and change the size of selected cells without changing the size of the cells in other rows and columns?
View 5 Replies View RelatedI use webdings font with the letter 'a' to get a tick in excel but the it erases gridlines surrounding the cell i've ticked.
View 3 Replies View RelatedCreating a macro that updates and copies part of a worksheet in Excel 2003 and pastes it in MS Word. The sheet I have is a sheet that updates some prices etc and after it updates I usually select a square (part of the sheet), press CTRL+C to copy it and paste it as a picture (paste special ) in word. Is there a way to automate the process?
I am thinking a macro that updates the sheet, copies and pastes iit on word??
Is there a way to hide the column headings/row headings and gridlines automatically when a workbook is opened without having the user go to the view tab and unchecking the appropriate boxes?
View 2 Replies View RelatedAny way of displaying only certain vertical grid lines on a radar chart. I've added several blank rows of data to make the chart more of a circle but I don't want every one of the vertical lines to display. How to only show some of the vertical grid lines?
View 1 Replies View RelatedOn occasion I cut a table from a website and paste into Excel. If/when that data is subsequently deleted from the sheet the gridlines no longer show. I've tried turning the gridlines on and off to know affect. I've tried setting and clearing borders, but that made no different to the gridlines either. Even if I highlight the entire sheet and delete it makes no difference. I can't think of anything else to try.
View 2 Replies View Related
