I have created a form for my customers. It is attached.
In creating the form, I have merged cells so that the area behind my text boxes will appear clean (no lines).
However, I cannot remove the lines around certain cells see, e.g. range K21.
I would like to make the form as "pretty" as possible for my clients (and it would help me look good to management).
I sometimes import data in the copy-paste way from completely different sources, eg. a program on the web or whatever, which has arranged the data in a table.
It is often succesful with the data neatly arranged in the spreadsheet in columns and rows and all, but sometimes the gridlines disappear even though 'cell format' is set to 'none' in 'grid lines' and the settings have a mark for 'visible grid lines' and their color is 'automatic'. Only the imported area misses the gridlines.
It is of course possible to set some grey gridlines manually in cell format, but then I get them on the print also and I don't want that.
See the code below. It works fine but in the report that gets printed off, it doesn't display grid lines and line numbers .
[Code] .........
Is it possible to show a table in a user form? For example I have a table that is 4 columns wide and 5 rows deep with lines seperating both. I have tried using a text box and list box to achieve the results I am looking for but can't figure out how to add lines to seperate data between rows and columns.
View 5 Replies View RelatedHow do i deselect grid-lines in Excel 2003 so as the sheet is clear.
View 6 Replies View RelatedI am having a problem formatting a chart in Excel 2010. My chart has multi-level category axis labels, and I would like to have a vertical grid line separating each major group of categories. In Excel 2003, I could right-click on one of the gridlines and then specify the spacing I wanted between gridlines. In Excel 2010, as soon as I indicate that I want multi-level category axis labels, I get a vertical gridline between each category and I am unable to alter the spacing. If I deselect the multi-level axis label option, I can adjust the spacing between the vertical gridlines, but the axis multi-level label functionality is lost. Is there a way to fix this problem without having to resort to using the drawing tools or text boxes to achieve the desired results.
View 3 Replies View RelatedIn Sheet1 cell A1 has concatenate formula and the data source is linked from sheet "DataInput". Sheet1 cell A1 has multiple data and there are blank lines within the cell. I would like to remove these lines so it looks clean without any gaps. So basically its looking like this right now
Harry
Andrew
Joe
Apple
Billy
I want it to look like this but i am having a difficult time because this cell contains a formula
Harry
Andrew
Joe
Apple
Billy
A formula or something that would fix this problem automatically.
I've dug through the chart options, but didn't find a way to show the major grid lines on the Surface Chart itself.
View 1 Replies View RelatedI created a table where based in several competences anyone can evaluate performance and potential. My issue comes when based on that result (colum Y in "Perf&Pot" Sheet) I want to export that to a nine box matrix (Sheet 2 "grid" in the attached excel). As could be several people in the same box I wasn't able to com up with a formula that solves this.
Pasta1.xlsx
i really dont know how to do it. remove these lines in excel sheet???
View 2 Replies View RelatedI have enclosed 3 pictures with my question.
1. Is where the user is putting in data.
2. Is a spreadsheet with the data choosen from the action of the user, but it is containing also the non-choosen data from the input spreadsheet.
3. IS how I want the data shown to me either automatic or thru a macro. So is there any code like IF or some Macro who would make this happen?
What I want at the end of the day is a list of products that the user have put in and nothing else, with the QTY and price and the sum of that.
Here is a picture example of what I mean, just randomly found on google:
http://www.projectwoman.com/uploaded...ent-763577.jpg
Maybe an insignificant thing I want, but can the line from the comment connecting to the red indicator be removed? Added an example since my comments show up below the selected cell with VBA code.
I have code that works well to insert a blank row. I need to remove all vertical lines each time it adds a row. You can see I commented out the line I tried.
Sub InsertRow()
Dim LstRw As Long, ChkRw As Long
LstRw = Cells(Rows.Count, "A").End(xlUp).Row
Application.ScreenUpdating = False
For ChkRw = LstRw To 6 Step -1
If Cells(ChkRw, "A") Cells(ChkRw - 1, "A") Then
Rows(ChkRw).EntireRow.Insert
'Selection.Borders(xlInsideVertical).LineStyle = xlNone
End If
Next ChkRw
Application.ScreenUpdating = True
End Sub
I'm trying to remove lines in my line charts. I searched the internet and find the following code:
Code:
Sub RemoveLines()
Dim ser As Series
For Each ser In ActiveChart.SeriesCollection
ser.Format.Line.Visible = False
Next ser
End Sub
However, when I run the code, I got "Object doesn't support this property or method". I did select the chart. I have excel 2003 with vba 6.5.
Example.xls
Within my attachment, I have a grid of data, Row A are headers, and beneath, various corresponding dates, there are no row headers.
I'm trying to do a lookup so that column header is returned bases on a exact cell value.
Example: inputting 03/03/2014 will return "Week 3"
Week 1|
Week 2|
Week 3|
Week 4
07/07/2013
|14/07/2013
|21/07/2013|
28/07/2013
[Code] ......
Looking to expand grid in Excel 2003,
View 4 Replies View Relatedway to conditionaly colour code all cells in a grid based on cells in other grid: i.e.
gridA
1 1 2
1 2 1
2 2 1
grid B
12 11 14
34 16 53
35 64 23
i want all cell in grid B to be red if the coresponding cell of GridA is 2.
so here "14" "16" "35" and "64" will be red!
Let's say we have a "grid" like this one:
--A-- --B-- --C-- --D--
243 325 234 456
--E-- --F-- --G-- --H--
365 987 345 867
--I-- --J-- --K-- --L--
876 678 123 625
I want the program to return the value from a cell which is exactly below the given letter. It can be anywhere in the grid, not just in one specified column or row.
So, for example, for an input "G" I want the program to return 345.
I have this code:
[Code] .....
The first change in column K it finds perfectly but then it enters a lot of blank rows and does not put blank rows at the rest of changes in column K.
I am trying to make sheet that will give me averages from different groups within a worksheet. In E64 I would like to have the total that is in I4 unless there is a total in I24 or I44. When I made the worksheet, it figures everything great but when I remove the data on following weeks it messes up the averages.
View 10 Replies View RelatedI want to have 2 cells where I can enter 2 numbers (length & height) so that a grid can be plotted. For example, a big sheet of paper size is length 30" x height 8", if first number is 10" (length) is entered, it will plot 3 lines across 30" (cos 30" divided by 10" equals to 3) and if I enter 2" (height) on 8", it will then cut it into 4". Attached a file for better understanding.
View 14 Replies View RelatedI'm not worried about the order of the data. What I want is information on turning a grid into a list.
View 4 Replies View RelatedI'm creating a fairly large risk analysis spreadsheet which uses a fairly standard 5x5 risk matrix.
I need a function or a formula which refers to the score a cell in a 5x5 grid, if given the row and column values, like this (where the columns are probability and the rows are impact):
VL
L
M
H
VH
VL
1
2
4
6
7
[Code]....
I have the attached spreadsheet that has 176K of addresses. The cell contains data that is actually Address Line 1 and Address Line 2. I need to separate these. I believe there is an unprintable character that separates most of them -- maybe a CRLF or something like that.
See the attachment for examples ... Cust Address with unprintable characters.xlsx
TTHBF251863100
147943F00KNQ TTHBF251863100
REF VINS DU MONDE SA
O/RTT HBF251863100
I need a macro to transform my multiple lines cell as above ( 5 lines ) into a one line cell as below.
REF VINS DU MONDE SA
As the cells needing changing will always be different it would be good if I could have a macro working on the selected cells only, not a specified range.
I am trying to write a macro that given a selected range of cells goes in each cell and bolds the first 2 lines within the cell. An example of this would be if the cell contained:.............
View 2 Replies View RelatedIn column A I have product names, in B I have product categories and in C:H the product categories from column B are titles and the name of the subcategory is written in the cell. Because there are mutlipule sub categories that a product can belong to the report produces mirrored lines with one sub category on each line. What I need to do is combine all of these subcategory entries into one cell separated by a comer (,).
View 2 Replies View RelatedI have values in a column of cells in the format (All numbers in a single cell)
34567,43510,'1'
44049,99820,'1'
11124,37373,'1'
etc
up to ten such entries may appear in each cell with an arbitrary number in each cell. They were entered using the ALT+Enter method. Is there an easy formula to extract each row (such as 44049,99820,'1') to use in a formula. If there are two entries I would like to write two separate rows like:
LINE 34567,43510,'1'
LINE 44049,99820,'1'
If a macro would be required I understand and could use that also.
How to trim when there are many lines in cell. The normal trim works only when we have one line in a cell.
View 9 Replies View RelatedI'm trying to link objects and pricing to groups via a combo box. If the user selects Group A from the combo box and enters Object A on the line item, I want the price associated with Object A and Group A to populate.
Group A
Group B
Group C
Group D
Object A
$1
$3
$5
$7
Object B
$2
$4
$6
$8
Object C
$3
$5
$7
$9
Object D
$4
$6
$8
$10