I'm making a sign in and sign out sheet for work and when I go to view and then page layout I get not only that but other sheets without the texts. Also, when I go back to my normal view I see dotted lines that show the page size over and over again. Any idea how I can see only what I want to see on page layout and get rid of those dotted lines?
View 11 RepliesI may be a bit thick here but i am trying to change between portrait and lanscape on the same worksheet on printing. I have a very good diary planning spreadsheet set up and I am keeping all the supporting evidence in the same workbook but on different worksheets. Now i have areally silly problem. One of the worksheets holds a list or translations i need to input into a system in the office and it is 5 pages long when printing.
I want the first 4 pages to print in portrait but the last one in landscape buit cant think how to do it. I know it is easy over worksheets but i want all this info on one worksheet.
I need to add a footer to a worksheet.
I did it with the recorder, but its gives me WAY more than I need to know. But I cannot find in the macro, where EXACTLY, the footer is located.
[face=Courier New] With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.7)
.RightMargin = Application.InchesToPoints(0.7)
.TopMargin = Application.InchesToPoints(0.75)
.BottomMargin = Application.InchesToPoints(0.75)
.HeaderMargin = Application.InchesToPoints(0.3)
.FooterMargin = Application.InchesToPoints(0.3)
.Zoom = 84
I have an excel spreadsheet I have created as a printable form. It all fits nicely onto one page. I would like to be able to email it to people and have it look like a one-page form. It looks great in Page Layout view, but the only problem is that there are a bunch of extra sheets that show up as well. Is there any way to remove/hide these extra sheets that are not needed? Or is there another way to send this out so that it comes to folks as a one-page form so that they can alter the data in the cells but not the page formatting?
View 1 Replies View RelatedWhen I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.
View 3 Replies View RelatedI have some code that parses an html table. I want to put in error handling in case the format of the page changes or the internet page is unavailable. I am testing without an internet connection and the run time error is not being branched off to the error handler and is fatally ending the macro. This is true also if I raise an error manually.
Private Sub ParseInjuryPage()
On Error Goto ErrorHandl
Dim strPage As String
Dim webIE As SHDocVw.InternetExplorer
Dim myURL As String
Dim tableBeg As Long
Dim tableEnd As Long
Dim RowBeg As Long
Dim rowEnd As Long
Dim cellBeg As Long
Dim cellEnd As Long
Dim strBeg As Long
Dim strEnd As Long
Dim myCell As Range
Dim rowNum As Integer
With Sheets("INJ")
Set myCell = .Range("A2")
.Range("A:F").Value = vbNullString
rowNum = 2
Set webIE = New SHDocVw.InternetExplorer
myURL = "http://www.sportsline.com/nfl/injuries"
webIE.Navigate myURL
Do Until webIE.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
strPage = webIE.Document.body.innerhtml...................................
I suddenly can't adjust my page breaks in any Excel spreadsheet while in Page Break Preview. Is there some option to turn it on and off?
View 7 Replies View RelatedI have a sheet that changes the number of columns based on data from other sheets. This is the only sheet in the workbook that I will print out every day. I have it set right now to fit all columns on one page, however sometimes this will result in the bottom 1/3rd of the sheet not being used. If I use fit all rows on one page, then some of the columns will get cut off. Is there a way to scale in both directions? My guess is there is not, but I thought I would ask because it would work great for me if I could.
View 4 Replies View RelatedI have a report that I use and right now I have a command button that prints the report x2. What I would like to do is to have it print one in color and one in grayscale. I could do this I think with two different buttons, but I would like to utilize just one. I tried creating a macro but it did not pick up the fact that I changed the properties to black and white.
View 2 Replies View RelatedI am looking for a formula that will take data from one page and graph it on another page. The data I am trying to graph is arranged like so:
A B
1 q 2009.05.01
2 w 2009.05.02
3 w 2009.05.01
4 q 2009.05.01
I am looking for something that will look at column A and if the answer is "q" and then look at column B and if the answer is "2009.05.01" Excel will take that and count it in a specific cell on another page. In the case above, I want Excel to give me the answer of "2" in a designated cell.
Is it possible to Change Start Page Of Multi Page UserForm Based on 8 CommandButtons. on a WorkSheet, for example.
CommandButton1
UserForm1.MultiPage1.Value = 0
CommandButton2
UserForm1.MultiPage1.Value = 1
CommandButton3
UserForm1.MultiPage1.Value = 2
CommandButton4
UserForm1.MultiPage1.Value = 3
Could I use 1 multipage UserForm Instead of 8 UserFoms. Is it better to use 1 multipage UserForm with 8 pages or 8 UserForms. I dont know if this make sense or not?
I have a workbook that has 9 different tabs in it. Once all the information has been completed throughout the workbook, is there a code that could transfer specific data on each page to a different colum on that same page? I need to do this for 9 pages at one time. The information is listed differently on each page. I need to transfer data from the current data column to the previous data column once the entire workbook has been filed out.
View 2 Replies View Relatedhow to get rid of the page numbers that appear when using page break preview mode. The page numbers appear in large grey font in the middle of each page and sometimes makes it difficult to read cells. Can I use this view with all the same functionality without that one feature?
View 3 Replies View RelatedI need a macro that will print a hidden page that is linked to the page I have active.
It needs to be able to find the correct hidden page that corresponds to the active page because there are multilple pairs of the hidden/visible pages. The name of the hidden page is the same as the visible one with "printout" added to the end. When created, the sheet code names are sheetn and sheetm; n and m being consecutive numbers.
Working with 2000 Excel is bringing some new chalanges. I see things are done different. I am trying now to keep my header to repeat from page to page.
For example I have a header that may say something like:
People, numbers, date, ect. And there are so many new rows they go on for pages long. How can I keep my header on the top of each page when it prints out on paper.
Assume that calculation is set to automatic and not manual, then is every formula on a page updated when any value on the page is changed, or only when the values in the cells pertaining to a particular formula change?
For instance, if cells a1-a10 have values and in a11 is a sum a1-a10 formula, and in b1-b10 are values and a sum b1-b10 formula in b11, if I change a value in range b1-b10 but do not change any values in a1-a10,then as well as the formula in b11 updating will the formula in a11 recalculate or does excel keep track of which cells have changed and thus is aware that the formula in a11 does not need to be recalculated?
I have a dataset that is as follows:
Col1 2 3 4 ...... 45
123 456 xxx xxx xxx
100 234 xxx xxx xxx
221 543 xxx xxx xxx
112 234
112 689
122 956
122 234
This goes on from left to right for 45 odd columns.
I need to copy each set i.e set 1 is 123 down to 122 to say cell a25 and then copy the next set i.e. 456 to 234 below the first set.
I need to somehow write a loop code that knows where to get the 2nd, then 3rd set, etc and copy it to the bottom of the preceeding set
I have MS Office 2003 with Excel and am comfortable creating formulas and have fun making spreadsheets, but have little experience with multiple tabs. They frustrate me. I'd like to set up a file that would essentially be a year of bookkeeping. Everything in view would be income, outgo, anticipated expenses, and running cash flow for a month. I'd like 12 or 14 tabs (1 per month plus overview and recap capability). If I make any format changes in row height or column width, I'd like those changes to apply to all tabs without having to copy the new layout to each of the other tabs. I think that would run the risk of also copying one months expenses/income erroneously to another month. Is this possible? I'd like to stretch a column, add column or row and have the changes apply to all tabs.
Also, most of the time, I like to have a tinted background behind my lists, but if a cost item needs to be copied from a green "expense list" to a blue "accounts paid" list, the color comes along. Can I copy only the text, not the format?
I receive a worksheet every month, Say sheet A, and then I change its layout as per our need, call it sheet B. here is an example. (Pleae see attached),
All I need to know is there a way to change lay out every month without cutting and pasting row up and down. I think if I insert a column in sheet A (received sheet) as column A and use match function with Prior months sheet B, and sort sheet A by column A (matching numbers), BUT the problem is the blank spaces.
What I want to do, is to populate the Lois, Beth, Kelly and Shelley pages with the rows from the Que page when they get assigned to one of them. I tried to program then off of a different example in the forum. It didn't work. Will include the copy.
Tracking(HELP).xlsx
Are there any forumla to mass change excel layout of info,
From (3 lines):
EMP_NO EMP_NAME JOIN_DATE CITIZEN_CODEJOB_CODE QUALIFICATION
70446Thaung Thaung Nge 20060630MYA Enrolled NBA
70446Thaung Thaung Nge 20060630MYA Enrolled NDiploma in Nursing
70446Thaung Thaung Nge 20060631MYA Enrolled NSNB EN Licensure Examination
Into
This (1line)
EMP_NO EMP_NAME JOIN_DATE CITIZEN_CODEJOB_CODE QUALIFICATION (1)QUALIFICATION (2)QUALIFICATION (3)
70446Thaung Thaung Nge 20060630MYA Enrolled NBA Diploma in NursingDiploma in Nursing SNB EN Licensure Examination
I'm a graphic designer with a few years of experience incorporating Excel content in design layouts, and for the first time I've been asked to use Excel to layout content. The client has a complicated spreadsheet that works as an interactive form, taking responses and running them through a hidden page of secret-sauce analytics before outputing results to a final report.
The thing is, they are hoping to use it in person with clients on an iPad, and then also print out all of the individual pages as a consistent-looking booklet.
I can make an excel page look good, but the printing just isn't going according to plan. When I go to print it distorts the pages. I can resize it to print, but then it doesn't work onscreen so well. And that's for one page: in a best-case scenario I'd need all of the pages to work for print and screen AND use the same scale so that they all look uniform.
how to use Excel for clean, consistant page layouts?
I have a worksheet that look something like the excel.jpg but hundreds of rolls instead
I wonder if there some way i can convert it into something like exel2.jpg without having to do it manually
if excel is not capable can i use access to do it ...
I have 2 excel files. 1 has 10 columns and about 20.000 rows. Each row is a customer entry and each column specifies data about the customer (column 1 first name, column 2 last name, column 3 email, column 4 city and so on). The 2nd excel file only contains 1 column with 4000 email addresses in it. These are email addresses of people who opted out of our newsletter and other marketing channels.
Now I want to have excel delete all the rows of the first file that correspond to the email addresses of the 2nd file. Obviously the email addresses in both files are identical, though the 2nd one contains fewer entries and only those people we don't want to continue sending emails to.
I received a CSV file with 2500 entries, but instead of being in 1 column, from 1 - 2500, they are spread across the top of the spreadsheet (1 in each header column). How do I make them go down instead of across??
View 2 Replies View RelatedMy question is explained inside the workbook. Changing a Table layout
View 5 Replies View RelatedI do not know much about macros so thats is possibly an easy problem to solve. My problem is basically rearranging the rows and columns. Example is below.
M.N= Material Name C.N= Country Name
M.N C.N
1 A
1 B
1 C
1 G
2 A
2 H
3 C
3 F
3 K
4 A
4 C
4 E
Here i have two columns. I would like to take the country list to rows as shown below.
M.N. A B C D E F* * *
1
2
3
4
5
*
*
And if the country has that material name it should show "Y" in the crossing cell. ( eg 1 A, 4 C)
I'd appreaciate your help. If you can help me with how to do this kind of layout changes with macro, it'd be more useful i guess, because i come accross with this kind of issues so often.
I need to import some csv files but I can not properly manage one of the field because it is a date and that field behave in a way that I can not definitely control;
I got an inversion of month with day so that the final layout is mm/dd/yyyy instead of the correct date layout dd/mm/yyyy I want (need);
the main problem is that when I'm importing these files via a VBA macro like
Workbooks.Open Filename:="n42s3.csv"
the inversion does happen whilst when I'm going through the "normal way" of the menu File, Open... it does not;
and moreover even if I put some commands on the vba macro like
Selection.NumberFormat = "dd/mm/yy hh.mm;@"
in order to control the correct date layout I want I get no result at all
it's a big problem for myself because I need to open a large number of files which can not conveniently handled with the normal way (i.e. passing through the menu)
I have a workbook where employee scheduling is done on a monthly basis in 15 minute intervals. It is laid out like this:
******** ******************** ************************************************************************>Microsoft Excel - Key Support Services 090813.xlsx___Running: 12.0 : OS = (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB2C2D2E2F2G2H2=ABCDEFGH2Time8/1/20098/2/20098/3/20098/4/20098/5/20098/6/20098/7/200938:00 AM 48:15 AM 58:30 AM 68:45 AM 79:00 AM 89:15 AM 99:30 AM 109:45 AM 1110:00 AM 1210:15 AM 1310:30 AM 1410:45 AM 1511:00 AM Schedule [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
The times go from 8 AM - 8 PM, and all of the cells within the range B3:AF51 are drop downs with the employee names listed. They are conditionally formatted so that we can easily see who is scheduled to work when, and on what days.
The problem that I have is that I like this layout for inputting the data because I can see it all very clearly, but it is not good for archiving or saving past months data. I want to be able to take that view and change the format so that it can easily be summarized in a Pivot Table for all of the historical information.
So, I need to take the date and time and format both of them into a column, put the client name (will be the sheet name) in the next column, and then the name of the staff that worked during that time.
******** ******************** ************************************************************************>Microsoft Excel - Book1___Running: 12.0 : OS = (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutA1=ABCD1DateTimeClientStaff28/1/20098:00 AMClient1Employee138/1/20098:15 AMClient1Employee148/1/20098:30 AMClient1Employee158/1/20098:45 AMClient1Employee168/1/20099:00 AMClient1Employee178/1/20099:15 AMClient1Employee188/1/20099:30 AMClient1Employee198/1/20099:45 AMClient1Employee1108/1/200910:00 AMClient1Employee1118/1/200910:15 AMClient1Employee1128/1/200910:30 AMClient1Employee1138/1/200910:45 AMClient1Employee2148/1/200911:00 AMClient1Employee2158/1/200911:15 AMClient1Employee2168/1/200911:30 AMClient1Employee2178/1/200911:45 AMClient1Employee2188/1/200912:00 PMClient1Employee2198/1/200912:15 PMClient1Employee2Sheet1 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
From there I can take a completed month, and quickly run some code to make the change, and add it to the historical tracking where it is all summarized.
I've got the data sheet and try to make the report like the one below pivot. I've tried many ways e.g: calculate field...but I just find one way to do that manually from three changes from pivot and make that report by copy/past. Can I do that directly from pivot?
View 2 Replies View Related