page

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...

I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user. My data has User name Time landed on the page Any Links clicked on the page As I have the time the user landed on the page via the link clicked I need...

I am trying to extract data from a web page through power query, new query using excel 2016 but unsuccessful as it requires to login to access the web page , Anyone knows a technique to achieve this.:confused::confused:

This macro should open up the file (Food room book 2), copy/paste the selected range into the SkutoSkutemplate and then close the page (Foodroom book 2). Range("A1:J810").Select Selection.Copy Windows("SkutoSkuTemplate1").Activate ActiveSheet.Paste...

Amazing how impossible it is to phrase this search on Google... I'm not interested in manipulating or viewing page breaks. All I want is to be in normal view. I am not interested in workarounds similar to attaching If ActiveWindow.View <> xlNormalView Then ActiveWindow.View = xlNormalView to...

Hi , I m New to VB and I was struggling to the code for upload a PDF into the web page. I need to upload a PDF in (https://draftable.com/compare) in this website please help here and provide any code to upload a PDF using VBA. I have tried to upload PDF but getting error when "Choose File...

Hello all, When I am trying to print, the pages contains too much white space and doesn't take up the entire page or have my data too small. Please advise what I can do. For the first tab, I am trying to print the data onto 3 pages(portrait) but there is too much white space. How can I have...

I have a button that inserts a signature at the bottom of a sheet under the last row but if the rows are nearing the bottom of the page, the signature image will be pasted half on one page and half on the next page. Here is the code to paste a set signature and code to paste a custom signature...

Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...

Hi, Can someone explain to me how I can get my print area centered out over the whole page? Currently it leaves most of the page blank, but I want it to be spread out whilst keeping to fit the sheet on one page.

Greetings Can the below VBA string be modified to add the word "Date:" before the actual date, and change the font to Ariel 12 point bold? I'm using MS Office Professional 2013 and Windows 10 Enterprise. RightHeader = Format(Date, "dd-mmm-yy") & Chr(10) & "Page: &P of:&P" As an example, the...

Hi all, I have a worksheet that has multiple sheets of data, and i want to consolidate the data into 1 page of unique values. I have this code written but want to shorten it by using some loops for the copying and pasting. What my code does: 1) copies data from column "Project Name" and...

This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another? What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information...

Seems our engineering friends at Microsoft are at it again. They love breaking things that work perfectly. I have a workbook with about 70 identical sheets. I wanted to print the same rows on each sheet. Well in the 2013 version you can no longer set the print area on multiple sheets. Fine, I...

Hi Everyone, OK not come across this one before but heres what i need. I have a sheet with 3 different Ranges Range B2:F10 Range J7:T37 Range AA3:AT40 Now the problem im having is I want these ranges to be my Page sizes but when i print i get everything shrunk to match the width of Range...

At some point, my hyperlinks (that use to open up in Excel) started opening up in a web page. I think this is due to a global change that IT made in at my company (not sure). I am looking for a setting to stop this from happening. I am using simple hyperlinks to open other Excel workbooks. I...

When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...

hey everyone, i need some help. I have finalized my workbook, each tab has one page per sheet in the workbook, i want to send this to my team however I want them to view these sheets as page layout view. my problem is i only want the active sheet in each tab and i can't get rid of any...

Is it possible to link an Excel file to the comments being generated in a Word file? I have a situation at work where we have a Word document that is being used by several different people who are adding comments to it. One of the guys is using an Excel file to create a snag list of issues...

Hi I have a workbook that has approx 12,000 entries but im trying to copy and paste into a new workbook but avoid line 1. At present im having to highlight all the data from line 2 onward down the page and copy and paste into new workbook. Is there any easier way I can copy and paste...