pages

Hi all I am unsung Excel 2013. I have an userform with textboxes. I have created some multiple pages underneath the main userform textboxes. However when I click the tabs in the multi pages, the screen moves and only shows the content of the multi pages. I would like to keep the main form...

I'm looking for a function/formula or 1-off change solution to stop Excel printing blank pages. I have 100 rows of data and formulae, in case there is that many data entries to make, but most of the time there will be 10 or 12 data entries which should fit one page, the other rows returning...

I have report that consists of two columns and 451 rows; rather than print 10 pages where the two columns only take up half a page, I would like it to have 4 columns--in other words, the 44 rows on the left, then the next 44 on the right, then page two...etc etc...so that I cut the printed...

I have a userform in which I have a multipage control with three pages. Of the three pages, the first page (value=0) is considered my "default". The user can step through the pages in any order and everything behaves as expected. The page changes are controlled with the multipage_change event...

Hi! Sp this is not exactly excel related but somebody might have an idea. When we use Adobe Acrobat to convert a perfectly normal PDF report into Excel, some of the top rows on pages don't get added to excel. This happens randomly. Once it was 4 out of 11 pages, once it was 22 out of 67...

Is there ANY WAY to keep the graph when doing Report Filter Pages in Excel? Is there a Macro/VBA? Can it be done in PowerPivot? Can it be done in PP? What about Access? Thanks so much!!

This code runs and creates a pdf file, but it is skipping the pages that don't have the word "Information" on it. I am searching for the word "Information" and every time it finds it, it should print that page up to the next page where "information" shows up. 95% of the time it will be on every...

Hello, The following single file contains approximately 250 pages named by date. I need that opening new page in the file and take all pages' Y and Z columns starting from new page's D columns (I have to enter the names of the first three columns). I don't know it is possible but an other need...

I have a file where I need to print the pages from last to first. We're using Excel 2013 and Xerox Phaser 7500 printers. Is there a way to specify this either from the Excel print menu or from the printer options? I could do it using VBA but I'm hoping there's something more obvious. TIA

Hi, On a daily basis I have to process documents where each page is divided into two. For example if I get a 24 page long document then the first page's right half is going to be the 13th page, the 2nd page's right half is the 14th page, so first all the left side of page is presented first...

Hi all, I’ve been tasked to try and see if I can make distributing pages from an excel spreadsheet easier. I need to be able to send around 70 different pages from excel to 70 different peoples email address. Is it possible to create vba code that at the click of a button sends an email with...

I'm sure this is an old coconut, but it's driving me crazy! How to copy a formula through many pages (tabs) of a workbook WITHOUT the formula referring continually to the first page or tab of the workbook. Example: ='1'!N31 where N31 contains a simple formula =N30+L31 where N30 was a previous...

Is there some kind of option or code to clear/replace VBA code? I have a workbook with about a hundred pages and I have just a snippet of code that needs to go on most but not all of them to make a toggle button work by calling the sub from the right module. I can't just find/replace because I...

I have been trying to import data from a website into power query (or one excel worksheet). The data I need extends over 5 "pages" http://flyeia.com/flights/departures#sm.0000ysr85e9vnctez8n2h6y6ywlq0 http://flyeia.com/flights/departures?page=1#sm.0000ysr85e9vnctez8n2h6y6ywlq0...

I have a worksheet that I'm currently viewing as page break. I want to loop through all print-area pages and on each page determine how many chart objects are on each page. Any suggestions? -- VBA obviously. Thanks

Hello, I've spent hours searching and can't find why what I'm trying to do won't work. I want to sum the same cell accross multiple pages but using the Address function to determine the cell to sum. SUM(First:Last!$C$4) works, and ADDRESS(4,3) returns a value of $C$4, but...

Hello, I would like to know if there are any ways to improve how quickly excel refreshes pages of external data from web. I'm planning to use VBA to refresh each page individually because refresh all didn't work. There are about 2000 to 2100 pages in 6 or 7 (not done yet) worksheets. Any tips...

I have a dataset with about 500 rows, each row resembling a page. Each page had so many visitors, generated x amount of dollars, and had x number enter on it as their first page view. I'm trying to give an overall rank for each page based on the visits, revenue, and entries and compare across...

Hi I have got a work book in page 1 I have a summary sheet (Lists of names) from which I have formulated it to other pages for cells fill up. So they all have a sample template i.e 1 page. i am trying that to automate like look at the lists and if it needs more than one page to fill...

How to download flip books magazine (SVG format) all pages from google chrome in PDF