Repeat Information On Multiple Pages?

Jan 24, 2010

I recently undertook an excel based knowledge test and whilst I haven't been informed of the answers/scores yet I have been frustrated with my inability to find the answer to what seemed like a simple question on the test....

Q: Without using copy and paste, put A1:H11 and its associated formulas and formats onto all 7 worksheets within the workbook.

Bearing in mind all questions on the test generally used only a few keystrokes, I felt fairly stumped and with copy and paste excluded from the options I am convinced I answered incorrectly. But the worst of it is I left fairly contently from the test and thinking I would get home and satisfy myself with the answer outlining a simple oversight on my part, have been shocked that I've been unable able to find one anywhere, is anybody able to put me out of my misery here as it's beginning to really bug me!

View 7 Replies


Information From Web Pages With Java Applets

Mar 10, 2007

i suppose web query /internet explorer object are still new subjects for many. there are'nt too many threads on these topics. Is there a way get the information from a web page that uses java applets and put it in excel?

View 4 Replies View Related

Copy & Repeat Single Row Information To Many Rows

Sep 3, 2008

In the excel sheet bellow that I'm attaching you will see what I'm looking for.

View 8 Replies View Related

Web Queries For Multiple Pages?

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

Delete Row From Multiple Pages

Oct 20, 2011

I have a command box that I type a number into, when you type this number and hit "OK" it searches that sheet in column B for that number, if it finds that number it deletes it, if not close. This works perfectly. I have 7 other sheets however, and I want it to search those sheets as well for the same number (still in column B) at the same time, if found delete the row, if not keep going. I have it working on Sheet2 (laser) but every time it fails on Sheet3 (punch). The thing that kills me is it's the same code. I have tried numerous things but have had no success.

Private Sub CommandButton1_Click()
Const strDelete As String = "TextBox1.Value"

Dim DeleteValue As String
Dim rng As Range
Dim rng2 As Range

[Code] .........

View 6 Replies View Related

Workbook With Multiple Pages

Mar 25, 2009

I have a workbook with multiple pages, two of which are labled "Summary" and "Questionnaire" On the Summary sheet, I would like to have a button or permanent dialouge box that asks the user if he wants to print the "Questionnaire" sheet. The button should have 2 options YES and NO. If they say Yes, change the contents of cell A2 on the Questionnaire page to "1". If they selct NO, make contents of A2 on the Questionnaire sheet to "0"

I have a macro that reads the contents of A2 on all sheets and prints if >o

View 9 Replies View Related

Inserting Rows On Multiple Pages

Mar 21, 2006

I am working on a database with Names and Volunteer Hours worked over about five years.

What I have is one sheet with names and info, and the respective sheets for each year and different events they worked that year.

on each year sheet I have only the first and last name, which is all that I need for personal info. I have these names on the seet using the sheet1!A1 formula. However whenever I add someone new they will not update the new row on the other sheets, they will simply ignore it. How can I make it respect my row updates?

View 3 Replies View Related

Printing Multiple Pages On One Page

Feb 3, 2010

I have a list that I need to print. It is only 2 columns, but 12 pages long. I would like to print 4 or 6 pages, side by side on the same sheet. I tried changing the print setting to 4 pages per page. But, when I looked at the print preview, it showed only 1 page per page.

View 11 Replies View Related

Conditional Formatting Over Multiple Pages

Dec 17, 2012

I need setting up a conditional rule over 2 pages.

Page 1 displays a list of countries.

Page 2 pulls in the RSS feed from the BBC World News website.

I need to find a way to set a rule that will highlight the country on page 1 if it is mentioned anywhere in page 2.

View 7 Replies View Related

Printing Multiple Pages Per Sheet?

Jan 22, 2014

I'am trying to create a document which automatically prints the next page on the same sheet.

I have created a spread sheet which prints the first 5 rows in the top of every page, but I can't figure out how to make excel print two A4's on one A3 side-by-side.

View 2 Replies View Related

Multiple Calculations From Different Pages - Macro

Feb 3, 2014

I'm working on this excel tool that I would like to make as user-friendly as possible. It would act like a survey almost where the user would choose responses or input values for specific questions and then on other worksheets it would have the actual calculation and math.

I see that if one were to add a value onto worksheet 1 and which would be a variable that is essential to a calculation on worksheet 2 it does not run automatically.

If there is a combo box w text values that also needs to have a calculation on another page, can i just do an IF statement on worksheet 2 with combo boxes?

View 3 Replies View Related

Code To Print Multiple Pages

Nov 8, 2008

I have a macro that cycles through several student ID numbers and prints a progress report for each one. It works great, but I would like to add an option to pick which printer to use at the beginning of the code. In other words, when I run the macro, the printer box opens and I can pick the printer. When I click okay to print, the macro continues.

View 4 Replies View Related

Print Multiple Pages And Worksheets To PDF?

Aug 25, 2013

In my excel, i have 3 worksheets. On the first worksheet, i have 2 pages since i have 2 sections side by side. I can't stack the sections due to different column widths. I am trying to see if there is a macro to stack the 2 pages on the first worksheet as one pdf page, and then have worksheets 2 and 3 as pages 2 and 3 of the pdf.

View 1 Replies View Related

Printing Multiple Pages On One Sheet

Mar 28, 2007

I need to print 2 pages on one sheet. Page 1 on top, page 2 below. I can get this to work on Portrait, but I need it printed Landscaped.

View 9 Replies View Related

Creating Multiple Pages From A List

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

Print Specific Pages On Multiple Sheets?

Dec 29, 2012

I have a workbook that has multiple sheets for patients (each named with SSN) with all such sheets having identical structure. I have the VBA code below that prints all sheets. Each sheet will have 7 pages when printed. Is it possible to amend the code so that it prints page 1 and page 3 from each sheets only?

Sub PrintSpecificSheets()
Dim WS As Worksheet, mySheets()
Redim mySheets(0)


View 1 Replies View Related

Auto-Sum Ranges Of Cells Within Multiple Pages And Then Sum Those As Well

Mar 22, 2013

When I tried using Autosum and just selecting the ranges like I do normally it gave me the #VALUE error. There's got to be a way to do this.

View 1 Replies View Related

Find And Replace Across Multiple Pages In Workbook?

Apr 1, 2012

Is there a way to do a "find & replace" across multiple pages in an excel workbook?

I am trying to update 1 particular data-set, and need to do it across all my pages...just spent 30 minutes doing find & replace on each page.

View 4 Replies View Related

How To Set Page Setup To Print Multiple Pages

Jan 25, 2013

I have data range which have three sections identical in shape and size.

How should i set the page setup so that each section print on a separate page.

View 1 Replies View Related

Making Multiple Pages With Drop Down Menu

Jul 17, 2006

is there any way in excel of making multiple pages with a drop down menu. Let say I choose 3 within the drop down, I'd like excel to make 3 pages (with the same settings of the first one) having a head/foot head pages. If you have a excel example(xls)

I just added a picture of what I actually want to do. I'd like to have the same design but adding pages between the top and bottom of the pages with a drop down or via an input box.. doesn't matter.

View 7 Replies View Related

Hide Rows On Multiple Worksheet Pages

Sep 7, 2006

This code will hide row 2 across Sheet1, Sheet2 and Sheet3 while recording in the macro record mode but when played back after recording will only hide row 2 on Sheet1. How do I get this code to work?

Sub MultiplePageHideRows()
Sheets( Array("Sheet1", "Sheet2", "Sheet3")).Select
Selection.EntireRow.Hidden = True
End Sub

View 5 Replies View Related

Pulling Multiple Matches (formula Repeat?)

Aug 21, 2009

I'm looking for is to repeat this formula within the cell, so that it can pull the information of not only the first match, but all matches proceeding it. Right now it only pulls the first match it finds, but I would like it to add every time a row matches the criteria of the formula.

=(LOOKUP(2,1/(('Paste SFHS'!$A$2:$A$9=A2)*('Paste SFHS'!$B$2:$B$9="08-Wave/Stu. Goals")),'Paste SFHS'!$C$2:$C$9))

View 5 Replies View Related

Listbox Change Macro Not Working On Multiple Pages?

Apr 8, 2014

I am running into a problem with a macro. I have the block of code below repeated about 30x in vba. When I went to create a new list box, ie: "List Box 2", in a new sheet it is not working.. The code is the exact same, but it is not working at all.


This is the second code for the second Sub

[Code] .....

View 2 Replies View Related

Printing Multiple Pages With Increasing Cell Number?

Jun 28, 2014

I've got an excel sheet that has a series of successive numbers down the side from 1-15 per sheet. I've done this by putting the cell formulas as previous row +1. (these are being used as unique reference numbers)

I want to be able to print this out multiple copies of this in one instance without having to manually adjust the first number multiple times then print the sheet. I also want it to be automatically saved as the most recent page printed, so that when it's printed the number continues on from the previously printed sheet.

I found a macro online which I have adjusted to increase a cell by 15 each time it is printed (to change the first number of the row). But I've realised that I'm printing the final page twice if I run the macro again. Is there any way to get round this? If I print 1 sheet there is also no adjustment in numbers.

I also haven't got onto the save part.

This is the macro I am currently using:

"Sub PrintSequence()
' PrintSequence Macro
' Macro recorded (altered) 8/16/2005 by Roy Wagner


View 1 Replies View Related

Excel 2007 :: How To Use Query Tables With Multiple Web Pages

Apr 22, 2014

I'm trying to query a web site and export the data to a single sheet in Excel. I've used the record macro function in Excel (2007) and come up with the following but I want to query over 20 pages from this site and wondered if there was any way in looping this macro to do the hard work for me;

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;", Destination:=Range("$A$1"))
.Name = "players_1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False

[Code] ........

On the second page the URL changes to;

URL;FIFA 14 Ultimate Team Players - FUTWIZ

and the .Name field changes to;

.Name = "players?page=1_1"

and on the 3rd page I get;

URL;FIFA 14 Ultimate Team Players - FUTWIZ


.Name = "players?page=2"

View 3 Replies View Related

Making Column Headings Apply To Multiple Pages ()

Dec 21, 2006

I work with an excel sheet to produce a list that gets distributed (in hard copy). A problem that I have is sometimes, the list spansmultiple pages, so I have to manually use the page break preview to put the column headings on the first row of each page.

View 4 Replies View Related

Select Multiple Files And Have Macro Repeat The Process

Sep 7, 2012

Im trying to get my macro to open allow me to select multiple workbooks, then have each workbook open up and copy A2:N2 and down and paste these into my active workbook, under each other, ie on the next available row (basically combining all the workbook data together to create a big list.

The below code works to open a single workbook, copy the data and paste it in at the next available row, but I have to keep running the macro for each workbook whos data I need to import!

How can I modify this code so I can select more than one file? I need something like for each wb the end next wb...until the macro has done the below for all selected workbooks.

Sub openandcopy()

Dim wb As Workbook
Dim ws As Worksheet
Set ws = ActiveSheet
Set wb = Workbooks.Open(Application.GetOpenFilename)

[Code] .....

View 4 Replies View Related

Combine Multiple Cells Into One Cell With VBA Code And Repeat Until Last Row?

Aug 26, 2013

I am using the code below to combine the rang of cell values into 1 cell. with this code I need to select the range of cells manually and run the code then repeat it on the next row manually.

What I need is automatically find the range from selected cell till last cell in the row and run the cod for this range then do the same on next row until last row of the sheet.

Sub JoinAndMerge()
Dim outputText As String[code]....

View 1 Replies View Related

Macro Won't Execute Code To Put Focus On "print To X Pages Wide By X Pages Tall"

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

Copy Column Data From Multiple Tabs Onto Specified Tab / Transpose / Repeat

Mar 25, 2014

1. The idea is that the macro will start on sheet1, look at column "Jon", copy the values down to the last active cell as well as the dates and paste special values and transpose them onto the "Jon" tab starting in B8 and B9. Each day all of the dates and values on the "Jon" tab should be overwritten with the data on sheets1 and 2, instead of it being cumulative.

2. The macro will then go to sheet2, look at column "Jon", copy the values to the last active as well as the dates and paste special values and transpose them onto the "Jon" tab starting in B18 and B19. Each day all of the dates and values on the "Jon" tab should be overwritten with the data on sheets1 and 2, instead of it being cumulative.

3. The macro would then save the "Jon" tab as a separate pdf in a specified location.

4. The process would then repeat for "Mike" and "Paul". Each day the number of columns can fluctuate, so it may be 3 one day (Jon, Mike, Paul) and 8 the next. The number of rows also may vary from day to day, and column to column.

I have attached a workbook that contains the data for the scenario above as well as the output (Jon, Mike, Paul tabs). Ideally there will not be new tabs that remain for Jon, Mike, Paul, just a default tab (e.g. "output" tab) that would receive the transposed data from the columns for Jon, Mike, Paul. I put all 3 in the workbook so you could see how each of them would output.

View 4 Replies View Related

Copyrights 2005-15, All rights reserved