Creating A Persistent Format Across Several Pages
Feb 1, 2009
I'm essentially creating a basic table and I have my first page created exactly how I want it. Header, footer with page numbers, and the main page consists of a table with borders, column headers, and every other row highlighted. I'm making the table for a small company to record the results of equipment tests that they have to run every morning. What I need it to do is to keep that format on every new page that gets activated. The users of this particular form that I'm making are not particularly computer savvy, so asking them to recreate the table everytime they need a new page would be asking quite a bit.
View 14 Replies
ADVERTISEMENT
May 27, 2014
I have a Column of dates in this format: 5/19/2014 8:08:44 AM I am trying to get this to read 20140519 or yyyymmdd It doesn't matter what format I change to, it will not update unless I activate the cell and then tab or enter out of it. I have 3000 rows to convert. with this either by setting or VB Sub?
Excel 2010
View 3 Replies
View Related
Aug 27, 2008
I have a list of approx 600 locations with codes that I want to populate into individual worksheets.
For example, the list (in excel) has the following
NEW YORK 12345 WW012
NEW JERSEY 23456 WW013
PENN 34567 WW014
(Each field is in it's own column)
The other worksheet is a template where the Site Name, codes would be placed is specific locations, one site per worksheet.
Is there a macro that can create one sheet per site with the proper information?
View 9 Replies
View Related
Sep 12, 2007
Im trying to get a macro that will set every sheet in the workbook i am usine, to match sheet1.
Sub LOOPY
Dim WS As Worksheet
'Loop through all worksheets
For Each WS In ActiveWorkbook.Worksheets
'Do this for all sheets except these sheets
If WS.Name = "Pcard Statement" Or WS.Name = "namedranges" Then
'Do Nothing
Else
'copy "pcard statement" page setups/print magins
Sheets(WS.Name).Range("A1").PasteSpecial Paste:=print margins?
End If
Next WS
Application.CutCopyMode = False
End Sub
View 9 Replies
View Related
Mar 20, 2013
My worksheet has a column full of numbers that are suffixed with "." and more numbers.
Example
Before After
135443.234 135443.23
456544.810 456544.81
435466.235 435466.24
654352.8 654352.80
I save my files as .txt. In the text files, the numbers appear preserved. But when they're opened in excel, they're rounded. If I format them as numbers with 3 decimals, the "#.8" becomes "#.800" which is no good. Oh, and the suffixes which end in a zero always end up losing the zero.
I've formatted my columns as general, number (with 3 decimals), and as text. That hasn't worked.
I've tried concatenating, separating the decimal from the suffix: =456544&"."&810
I've tried using the value formula to get get the cell value.
View 4 Replies
View Related
Apr 21, 2009
In the sheet I am working on I have some numbers that represent todays activity. These numbers are volatile and reset when the date advances. I have a column on another tab that has all the days of the month as F4:F33
The results I want will go in the G4:G33 column.
C2 is Today() to avoid too many Today()s.
Active!J10 is the value I need in the G column.
Basically what I need is the value from Active!J10 to be copied to whichever cell corresponds to the date next to it in the G4:G33 and then stay there when the date advances
The formula I am using for the g range is :
=IF(F24=C2,Active!J10)
=IF(F25=C2,Active!J10)
=IF(F26=C2,Active!J10)
And so on down the column.
I dont mind the FALSES for future dates, but the current one changes to false upon the advancement of the date. Basically, I need a running log of the final numbers going down the G range and for those values to stay there when the date advances.
View 2 Replies
View Related
Feb 20, 2009
I'm trying to execute a macro and it won't put the focus (radio button) to select x pages wide by x pages tall in the Page Setup/Page/Scaling Area. I looked at the macro and can't find a setting in the code but yet the focus won't change. What can I do about this? In other words the radio button stays selected as "adjust to "" % of normal size. Here's the code...
View 2 Replies
View Related
Feb 11, 2014
I'm looking at what appears to be a custom chart. It is a box divided into 4 equal quadrants. In each quadrant is a percentage with the total equaling 100%. In each of the quadrants there is fill equal to the percent that is numerically written in that quadrant. I'll post a picture with this, but if I was talking cells then....
A1 = 15% B1 = 66%
A2 = 4% B2 = 15%
The backround image behind the number is filled up by volume equal to the percentage indicated. They are also color coded with red representing the highest percentage quadrant filled.
To top that, there are little arrows along the sides of each quadrant indicating an average score.
My first question is WHAT TYPE OF CHART IS THIS THING!, and second can this be done in excel?
View 4 Replies
View Related
Jul 21, 2014
I have a table (attached example with only a SMALL part of all data) I would like to transform this into pivottable format without copying and pasting. In row 2, all of the numbers pertain to years. Column B has the number of years in force for each property account (Column A). I
View 2 Replies
View Related
Apr 14, 2013
I want to create a custom format for a cell for entering in "cup measurements". I want to be able to type in 5, 1/4, 1/16, etc. and have the word "cups" appear after the number in that cell. I formatted the cell to say the word cups after typing in the numbers in my cell using the code "cups".
ex: 0 "cups" works fine for whole number
so then if i change it to 0/0 "cups" is works great for only 1/8 but not 1/16 or whole numbers. Then I looked at other custom codes that already existed in my formatts so I attempted to try this code which I just kinda came up with
_(0/00);_(0);_(0/0); "cups"
well it isn't doing what I want and If I use the 0/00 "cups code and I type in 4 cups the cell then says 4/01 cups.
What does my code need to be for me to show whole numbers and and size fraction without having it look weird?
View 2 Replies
View Related
Jan 29, 2007
I am trying to create a text box using the format control, however, everytime I click on the box it go to visual basic editor. I believe I'm missing something. I am not familiar with visual basic.
View 9 Replies
View Related
Sep 10, 2009
What I have is a double quoted, comma delimited text file that is created from an external application, every now and again we need to open the file to make corrections and this is easier if we open it via Excel using the delimiter options, the problem is when saving the file as a csv it removes the double quotes, however I have found some vba coding that adds the double quotes back, which works great, but it changes the format of the date fields from what the original file had from 09-Aug-2009 to 09/08/2009.
I suspect this may be because the file is opened before the double quotes are added and excel changes the format.
Is there any code I can add that will stop the date format from changing ...
View 12 Replies
View Related
Jan 18, 2009
I am using the VBA Chart Control and I have the following instruction;
Me.ChartSpace1.Axes(ChartAxisPositionEnum.chAxisPositionCategory).Numb erFormat = "mm/dd/yy"
The chart is a "chChartTypeLine". the problem is that i cannot change the format of the X-Axis to a Date (mm/dd/yy) format no matter what I try? I keeps wanting to keep it as "General", here is the code;
Private Sub CommandButton1_Click()
Dim ser As ChSeries
Dim cht As ChChart
Dim MinValue As Double
Dim MaxValue As Double
MinValue = Sheet1.Range("D2").Value + 10
MaxValue = Sheet1.Range("A2").Value
View 9 Replies
View Related
Oct 30, 2008
I have a website with lots of pages and I have a tool where I can see how many visits these pages get. What I want is to find out which pages didn't get any visits.
So I have in one column all the pages URL's on my site
In the other column I have all the pages URL's that have been visited, and in the column right next to it I have the amount of visits that page has received.
For example, this is what it looks like today:
column A:
row 1: /site/hello.htm
row 2: /site/how.htm
row 3: /site/are.htm
row 4: /site/you.htm
column B:
row 1: /site/are.htm
row 2: /site/hello.htm
column C:
row 1: 10
row 2: 20
Ideally the URL's that have been visited should show up on the same row as the URL in column A, and then for the ones that have not been viewed it will just be blank in column B and C.
so in the above case it would look something like this:
column A:
row 1: /site/hello.htm
row 2: /site/how.htm
row 3: /site/are.htm
row 4: /site/you.htm
column B:
row 1: /site/hello.htm
row 2: [blank]
row 3: /site/are.htm
row 4: [blank]
column C:
row 1: 20
row 2: [blank]
row 3: 10
row 4: [blank]
View 13 Replies
View Related
Aug 20, 2014
I am trying to create a PDF of every 2 Worksheets. I currently have this code that creates my PDFs for each individual sheet but I need it to group 2 together. Ex: Sheets 1 & 2 a separate PDF, Sheets 3 & 4 a separate PDF and so on.
[Code] ......
View 5 Replies
View Related
Nov 7, 2007
Is there a way to insert a cell/row, and add data to one page/tab, and have it automatically insert a cell/row and add the data on another page/tab?
Excel 2003 is the version I am using.
View 14 Replies
View Related
Nov 25, 2008
I opened an Excel file, and the whole page is grey. I can't see the cell lines at all. How do I get it back to white with all my gridlines?
View 3 Replies
View Related
Dec 19, 2013
I'm trying to find an easy way(or any way) that I can have excel automatically insert a page number into my document. I'm looking at 60+ pages on separate tabs that I will be adjusting and modifying for a few weeks yet and I don't feel like continually fixing page numbers.
View 3 Replies
View Related
Mar 27, 2009
I have a user form that has several tab pages on it when the form opens it checks to see if the user has entered there default info if it is empty it needs to go to the default tab so the user can enter there info. How do I do this using vba in excel 2000 I have not been able to find any code that will do this if I use the set focus option for a text box on the tab page it comes up with an error saying the item is not visible! The user forme is names = UserDataInputForm. The tab pages I have are
1st = InputDailyTimesPage
2nd = OverTimePage
3rd = DataPage
4th = DefultDataPage
the form opens using the 1st tab page by default
in the user forms inisilisation code I have this check
View 2 Replies
View Related
Dec 14, 2012
I have created a spreadsheet which serves as a reporting portal - if you select a product from a drop down, the spreadsheet automatically updates with data regarding that specific product. I would like to give my worksheet the ability to select a new item from the dropdown (that part i can do) and then print each of these product reports (1 page each) and aggregate them into one large pdf.
View 2 Replies
View Related
Jun 20, 2007
I have a formula that checks the previous page(Tab) for a figure so the formula goes =SUM(F37-'05-27-2007 thru 06-02-2007'!F37). Is there a way to instead of asking for the page '05-27-2007 thru 06-02-2007' to have it generically ask for the previous page?
View 9 Replies
View Related
Sep 15, 2014
I have a long growing statistical report(18 pages + more), and 14 of the pages will use report table headers. I went into the page set up and selected the row to repeat on each page. I do not want the table headers on any pages after 14. The rest of the report is formatted differently and does not use the row headers. but all of the information is related. Is there a way to only show the row headers up to page 14? I can't use headers and footers, of course. The report will be set in one place and the user will print it out once a week. It seems as if this cannot be done but I this is my last resort.
View 4 Replies
View Related
Jul 14, 2014
I am trying to print this document and it has several pages.
My problem now is I don't want to copy the header (all content of Cell 1 to 4) into all the pages.
Is there a way I can leave it the way it is and it will reflect on all the printouts?
I mean on all the pages that will be printed?
View 4 Replies
View Related
Dec 10, 2008
My question is about webqueries... specifically how to set up a query that will automatically fetch data on different pages (same data, but includes page 2, page 3, page 4, etc )
I've just figured out how to import a "new web query," but it seems like I won't be able to import 63 pages of it unless I do all of them by hand.
View 7 Replies
View Related
Mar 18, 2013
I have a workbook that has a total of 128 pages. The problem is that a lot of those pages won't be used. Basically I have a sheet that needs to be filled out for each day up to around 30 days, sometimes more, most times less.
Currently I have created all the sheets that I will typically need (31 daily's, 31 daily printable reports).
Data is entered into the daily (and other spots) and then with the use of formulas transferred to the report sheet which is hidden and then printable with the use of macros.
I also need to withdraw some of this information (CSV File) to be able to populate a database.
Is it possible to have my "daily" page as a template and then create the subsequent pages as I need them? (this would have to be done with a bunch of other report pages as well). For ease of use I would need all the formulas etc that I currently have to be able to be "created" as well. As an example, there is a running total of costs associated with the "daily" pages that would need to be carried forward.
View 8 Replies
View Related
Feb 19, 2014
I work for a construction company, Someone else created a workbook a few years ago with 140 similar pages, each listing a separate piece of equipment as a service record. I need to print these out randomly for mechanics to update with new information, as they service the machines. However, some of the pages of the original workbook are goofy and the workbook as a whole could be improved. But, oh that many pages!
I have worked on a new template page for entering information to make the worksheets all cohesive and updated. Is there an EASY and/or FAST way for me to copy this page 150x to make a new workbook, and just enter my data onto each new page? I really don't want to reformat each page of the original workbook individually to see if I can fix all the glitches and weirdnesses that have occurred on the pages over the years. I thought it would be much easier to retype the data onto new pages.
View 6 Replies
View Related
Mar 3, 2014
I was trying to print a workbook which was about perhaps 20-30 sheets of roughly one page of printed info each. However, I saw the print job and it said it was printing over 7,000 pages!!!
It turns out there were about 4-5 worksheets which were blank (and also didn't have gridlines even though gridlines were checked on in options).
When I switched the sheets to page break view, lo and behold each sheet contained a few thousands "pages". I simply can't seem to reduce it down to a relatively normal size.
I tried going right past the edges of page 1 and deleting all columns/rows to the right and bottom of it to no avail. I selected the whole worksheet and removed all borders and any cell content with no luck.
I saw other "solutions" on the internet about copy/pasting the other unaffected sheets to a new workbook and deleting, but this seems cumbersome.
View 1 Replies
View Related
Nov 21, 2008
In A1 of Sheet1, I'd like to display the number of pages Sheet2 will be when it prints out. I have no idea where to start.
View 2 Replies
View Related
Jan 3, 2009
i want it to stay on working sheet asit prints out the selected sheets below.
is there anyway to stop this from showing the sheets? ie stay on working sheet
View 14 Replies
View Related
Dec 16, 2009
I having troubles getting a part of this script to do what I want and was hoping someone could point out what to try. What I need is when the user is asked to enter the amount of pallets. The number they input is placed into a cell.
Here is the problem.
I'm looking for a way to start at number 1 and work up to the number the user placed in the input box. For example if the user put 5 in the input box Range("F37") Would read 5 then in range("A37") the number would read 1. Then the page would print ,the next value in Range("A37") would be 2 ,then print and so on up to 5. So the end result I would have 5 pages that printed with the only differnce being Range("A37") Value being 1,2,3,4,5.
View 2 Replies
View Related
