specific

I know I've seen it here, but cannot find it, so apologies for a potentially duplicate thread: Checkbox added, when "checked", I need a field (AG70) to display specific text/value ("Incld"). How? Thank you!

https://www.mrexcel.com/forum/general-excel-discussion-other-questions/710212-vba-code-convert-excel-pdf-email-attachment.htmlHi, This is extension to the one thread paste here long time back. It automticaly save and send mail via outlook but only issue is it saved whole excel file,where as we...

Hi, I managed to login to site then navigate to specific URL which is a JSON After loading the page, a prompt comes up to open/save JSON Is there a way I can save this to a specific folder with VBA?

Hi all, will need some help on using excel vba to extract a specific row and column of a html table. I m actually trying to check on a values base on a specific row n column, if the value if true then it will click on the button at the end of the row. Please do explain on the codes as I do not...

The following code Inserts a blank row after a specific term Sub insertRow() Do If InStr(1, Selection.Value, "Research director:") > 0 Then Selection.Offset(1, 0).Select Selection.EntireRow.Insert End If Selection.Offset(1, 0).Select Loop While Selection.Value<> "" End...

We use Excel to fill out some preprinted government forms on a shared computer. Someone changed the font resulting in legal issues when the next document was printed out. How do I lock the font so data entered always uses a specific font? I can see how to do it in Word, but we have to use Excel...

Hi all I have to find a way to solve this problem. I have a column with different numbers for example x1 x2 x3..x1000, and a specific range of 125 y1 y2 y3.. y125 numbers. i want to find which x number is closest to a y number. So i was thinking to do y1-x1= and y2-x1= and y3- x1= and so on. the...

i have this to print specific worksheet using command button but i want to it can be set what pages will be printed base on cell data Sub printsheet() Dim ws As Worksheet, wks As Worksheet Set wks = Worksheets("Main") Select Case wks.Range("A1").Value Case 1...

I need to extract specific rows from all the spreadsheets in a directory. I can use the Query editor to load all of the workbooks but the there isn't a quick choice to select certain rows. For example, I would like to keep rows 4, 53, 57, 71 and 57 from all of the loaded workbooks. I suspect I...

Hi, I am trying to write data contained in a specific range from the active workbook to a new workbook and then the new workbook ought to be saved in a user specified location. I am using the following code: Dim x As Workbook Dim y As Workbook On Error Resume Next...

Guys. What am I doing wrong, please? I need a VBA message box to pop up if and when a specific cell has specific text in it as follows: Private Sub Worksheet_Calculate()If Worksheets("Home Quote").Range("D33").Value = "Selection Error" Then MsgBox "Please make another selection" End If End...

I have the following code in Thisworkbook in the VBA module. I would like to copy this code onto a specific sheet but not sure how to modify it. I think I would need to change the third line to the name of the sheet. Private Sub Workbook_Open() Dim sh As Worksheet For Each sh In...

Hi, I am trying to automate the following steps: Open a PDF file open a PPT file In the PDF, goto a specific page (e.g. page 5) and copy/screenshot the contents. In the PPT, goto a specific slide (e.g. slide 3) and paste the image. Adjust the image so that it is located in position 5 from top...

Hi. I want to align the text in a column so that a specific character (±) is in the centre. The number of characters either side will vary depending on the value, # decimal places etc, but the one constant will be the ± character. This is an example of some data: <colgroup><col...

Hello! I wanted to create a button that would copy a specific set of cells and paste in a specific location when clicked. I need it to copy B21:AC64 and paste it in B5 - on the same sheet. What's that code look like?

As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in the entire workbook - not specific tabs. I can provide these code if necessary. Thank you!

I'm basically trying to get specific reports from excel data. I have a table with data that has to be downloaded from the internet and I want that data to be placed in separate sheets according to specific cell qualifiers. ie if column C is Yes, I want A:B and T:V, copied to a sheet2. I can...

Hello How would I create a formula that updates automatically when I update/change the selections in my spreadsheet filters? I have a large spreadsheet with columns for school names, teacher names, class names, subjects, students and columns for test scores. I need to count the number of test...

Hi, i have this code that i've been tinkering around with - i'm trying to have it work so that it removes all external links only on a specific tab (Summary Tab). Am i headed in the right direction with this?

Using multiple questions & answers in this board, I've put together the following code to: create new sheets based on a list (range B11:B in "Master" sheet), each sheet copied from a Template and renamed from the list, skip names with a sheet already made, delete sheets named "*Template (*"...