page

  1. S

    VBA to copy/paste data from already open chrome web page

    Hi, I have been searching with no luck to find a solution to copying/pasting data from an open chrome web page. I have chrome web page open (the web page has a title, so hoping to use the title). On the page there are columns with headers and columns of data. I'd like to select certain columns...
  2. F

    Can't query all rows from website table where URL doesn't change with pagination

    Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...
  3. O

    Using VBA in outlook form

    Hi all, I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form...
  4. I

    Worksheet activate question

    Morning, I have this is place at present. Private Sub Worksheet_Activate() Range("G13").Activate End Sub How can it be changed so i also see the 12 rows before it on the page. I mean sometimes even though cell G13 is selected its could be 1 inch down from the top of the page & i then...
  5. N

    Cannot delete page break in Excel

    I have a page break that is making the first page very small, I have tried everything to delete it and nothing works. Heeeellllpppp!!!
  6. N

    Looking to find cell value among specific sheets in workbook

    Hi, Thanks for looking at my question. I am working in Excel 2016. I want to look up a specific cell value from among a range of worksheets (in the same workbook) and have it return the worksheet name the value is found on. The sample page from the workbook is in the link below, i tried to...
  7. R

    Unable to publish tablein Outlook

    Hi All, I am getting publish error (.Publish (True))in below code in Clinet enviornment, However it working fine on my system. Even if i am trying to creating a HTML page manually, it is showing as "Page can't be displayed". Can anyone suggest here what setting needs to change for fix this...
  8. I

    Return to top of page icon always in users view on worksheet

    Hi, I have a long list in column E which is say 1000 + results down the page. I am in need of a Return to top of page code BUT a floating type if possible. I mean the Return to top icon which will hold the code must be in view on the worksheet whether i am on row 55, 239 or 850 then i can...
  9. S

    IFS function issue...

    Hello everyone, I'm assuming this is the ideal function, but I could be way off. Issue on "data" page: Need name of employee (column E) to register a "Division" (e.g. Administrative, Maintenance, Shipping, Production) in another Cell (column W) On "Employees" page I have a the four "division"...
  10. G

    Pulling Data from website using VBA

    Im pretty new to VBA coding and searching on online and youtube hasnt yielded much help, as they all have their own way to do it and its been very confusing. I can do this via "Data > Get External Data > From Web" but its pulls in way more then what I need, as it picks the whole page and not...
  11. B

    Pricing from homedepot.com

    I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the...
  12. D

    I want my spreadsheet looking good

    Is it possible to centre a worksheet on the page and have only that page visible? I tried to hide the pages but greyed out pages are still visible. I want nothing to be visible, except the active page and I would like it centred on the page. Can someone help me please? Is there a way to publish...
  13. A

    Sheet prints twice

    Good Day, I have button when clicked it prints a range of rows on a template. Application.Dialogs(xlDialogPrint).Show RowCount = Range("B2") Worksheets("Payslips").Select For i = 1 To RowCount Step 5 Range("B4").Value = i ActiveSheet.PrintOut...
  14. K

    Print area using table/range of cells

    I have a sheet with about 20 tables of data (one table per tenant), and I would like it to print as many of these tables as can fit on one sheet, but I don't want it to split any of the tables across two sheets. For example, if page 1 could feasibly fit 2.5 tables of data, I would want page 1 to...
  15. D

    Excel (2007) Web Query data -- how to stop annoying script errors in the built-in browser?

    When I click the Data...From Web option in Excel 2007, it launches an internal "browser" that I'm supposed to use to navigate to the site that I want to grab data from. The problem is that this built-in browser uses MSN.com as its default "home" page, and it generates several (sometimes 5+)...
  16. P

    Clearing worksheets

    I have a file that i was wondering if there was a way to write this code differently or easier. The file has 7 worksheets and a button page. i want to clear all worksheet and end up on cell A2 of the button page. Here is the code: Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets...
  17. L

    Power Query Does Not Import Multiple PDF Pages

    Hi, I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...
  18. S

    Pulling color choice for whole workbook from one cell in one sheet

    Basically, what I want to do is have one cell on the first of 8 sheets be the decider for all 8 sheets. Like you pick the cell color in M8 on the first page and that color is carried over to the appropriate spots on all 8 pages. But, I want this to be automated, like once it's selected its...
  19. I

    Specific print output - page with frozen panes

    Hello, I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows. I have set print titles according to instructions on this page. https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html Afterthat I select range F3:AC10 and then print...
  20. S

    Worksheet search including tab names

    Hi, I currently have an Excel spreadsheet that has multiple tabs and I am trying to find a way to make the first page be a search page that includes the tabs as searchable. So, for example, lets say each tab is named different states and then there is data in those worksheets from those states...

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top