My company uses a webpage created by ASP.NET to upload data from difference sources (people). Employees from different regions input data on the webpage and I consolidate the data into a report.
I am writing a vba code to pull (scrap) info from the page to an Excel sheet.
The first part of...
Someone else sent me this code example and it worked perfectly for the task I was working on. He admitted that he didn't know enough about the workings of the code to offer much advice, but was able to find it for me...so thanks!
So I'm using this code for it's intended purpose, but now I'm...
Hello all
I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?
Thanks in advance for your information.:(...
Hello to everyone
I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?
I have divided a 900-page pdf file into single pages numbered according to the number of pages (1,2,3,4, etc.).
I would like to combine only the pages according to the order indicated in column a of the excel sheet (example: 1,2,3,7,8,9,13,14,15 etc.).
Is it possible to do this with a macro...
I have 10 pages of all the same textboxes but named "Page1Reg1.Text" or "Page10Reg.Text" for example. I would like to know if you could have the multiselect values paste in each page.
ListBox1.List(ListBox1.ListIndex).Value = .Page1Reg1.Text
ListBox1.List(ListBox1.ListIndex).Value =...
Lets say, for example I have a spreadsheet with data in column B-K, and the potential for data in row 1-100. Is there a way, using some sort of flag to tell Excel only to print rows that contain said flag in Column "A"?
Alternatively, I know a complete spreadsheet is 10 pages long, if data is...
Good Day Gentleman,
I am hoping someone could help me out with the problem I am currently having - believe me that it would be beyond appreciated if anyone is willing to offer some of their time to help me with this.
Currently I have a very large spreadsheet(Approx 3080 Rows and with approx...
Hi.
I got a MultiPage with several pages, and a userform to input data on the next line on spesific sheets, but i got a issue.
I've had 4 pages for a long time, no issues what so ever, but then i added more pages, and copied the same code as i used for the 4 others, and just modified the names...
all the links stopped working to day 14/2/19 when i click on a hyperlink i get the message. cannot load the data to open. I have a file with 400-500 link to facebook pages. only about ten of them follow the link. big help i have tried every thing. thank you Frank Rowley
I have a range of cells that need to be printed and different ranges are to be printed depending on a filter that has been applied. I have had to set up some manual page breaks to make sure the pages are printed correctly, but the problem I have is when the filters are on there are some blank...
I have a worksheet with a multipage object. On each page I have a series of frames, and within those frames a series of checkboxes.
Is there a way that I can set the lock properties for all the checkboxes of all the pages without having to set each one on their own? Each of the pages has 50 or...
Hello everyone ,
Suppose there is an excel page that I don't want instead of searching for and deleting it manually. Is there a method to delete that page that if it contains a specific (Word) on it?
For example, Page 1 : strawberry juice is written inside it , If i have to locate it among...
I have 20 worksheets, named page 1 to 20,with data. To enable me to export a selected number of pages to a .pdf file, I have given a certain range a name. Example, page1 cells A1:G10 and cells A100:G110 the name is Page1 but ( Page1_A1:G10,A100:G110 when viewed in the name manager) I then...
Hi,
I have a user form with a number of pages within it.
When I click on the tab to a different page, the userform scrolls so that the start of the page is right a the top. Is there any to make sure that it's scrolled to the top of the userform?
Stephen.
OK have a print macro that works well and combined it with Post #12 from
https://www.mrexcel.com/forum/excel-questions/39788-old-excel-macro-language-2.html
with a slight modification.
This is it from my spreadsheet
Application.Wait (Now + TimeValue("0:00:20"))
Application.Goto...
I really need help on this one.
I have a worksheet form with headings. I have an "Add Page" macro copying the form from a second sheet.
The worksheet will have between 1 and 20 pages needing to be printed.
The page needs to be scaled to 49%, each page is 61 rows.
Can someone please provide a...
Hi,
Sorry if this has been asked before.
I have a workbook with multiple tabs of varying numbers of pages.
What I'd like to do is highlight the tabs and print them all as 1,2, 3 etc of total pages numbers for that tab as opposed to the total pages for all the tabs highlighted.
I want to avoid...
Hi
I’m working on importing a table from a web however the issue I am having is that the table is divided into pages based on the number of records .
I need my my excel workbook to be able to import all the records into the workbook regardless of the fact they are dividing up into pages with...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.