vba & excel 2016

I'm working on a project that needs to hide entire rows if one of the cells in each row does not contain one of two text options. I have three tabs, titled 'Bidding', 'Open Jobs', and 'Job Results'. Bidding is used to enter new data, Open Jobs reflects all the same information from the Bidding...

Hi, I would like to ask for help. I need to extract rows when it meets the criteria >=1. EX: Complete Product Sheet: <tbody> ProdCode ProdDesc Qty 1001 Prod1 0 1002 Prod2 1 1003 Prod3 2 1004 Prod4 0 1005 Prod5 1 </tbody> Order Product Sheet: <tbody> ProdCode ProdDesc Qty 1002...

Hi I'm still searching for answer on how to achieve his task. I'm trying to copy a row with title BOE to an open workbook so the macro has to search for title BOE select the entire row and copy to the open workbook. I have this code however missing the search and copy paste as values. Can...

I am trying to get a pop up message to run if the following 2 conditions are met "No" & "True". No is in cell range G4:G10, G13:G17; True is located in W4:W10, W13:W17. However true is a Boolean answer. I do have a formula located in cell range x4:x10, x13:x17 that concerts the Boolean answer to...

Question How to copy from one workbook to another? I’m trying to search for text "Total LOE" that is on a closed workbook and copy the row to an open workbook. This macro works however I have to open the workbook that contains the "Total LOE" and copy it manually. I sincerely appreciate your...

Hi I've got some code which checked the if a file had 8 columns in it, before it allowed you to import data from the file into Excel. However, the data in that file started on row 1. I've got a file where the data starts in row 8, and I wanted to amend the code below, so it checks if the...

Hi, I hope someone can help me with this code. I’m trying to make it paste the information to summary sheet and then copy the same information from other worksheet. There are 15 worksheets in one workbook. Here is my code. Thank you in advance for your help. Sub SearchForString() Dim wsSource...

I have this macro that adds numbers (1,2,3) to words in cells. The cells are not going to be in alphabetical order. How can it be adapted to add letters instead? Sub AddNumbers() Dim i As Integer For i = 1 To Selection.Rows.Count Selection.Cells(i, 1) = Format(i, "00") & ". "...

Hi all, I need your help as i cant seem to figure out how to resolve the below issue within VBA. I need to be able duplicate the row based on the value in column M if column J cell value is "MIXED SEL". However the tricky part I need to duplicate the group of number in column I by inserting it...

Couple of macros below are doing what I need, but create an issue - it closes Internet Explorer window under certain conditions, instead of File Explorer. Catch is that without "Call CloseWindow(sPrev)" code keeps opening more and more File Explorer windows. On Excel worksheet in A3 there's...

i have the following vba code to copy values from the column A to the next column,but it copy the formulas,i want only the values to be copied, so that when i clear the cell in A not to be cleared in B. <code> </code><code>Private Sub Worksheet_Change(ByVal Target As Range) Dim A As Range...

Hi All I am hoping that someone can help me. I am attempting to open an excel file which needs a password at start up. I have tried using the code below: "Sub OpenWbWithPassword() Application.DisplayAlerts = False Workbooks.Open Filename:="S:\Site\Training...

I am looking for a macro that will enter the current date and time in one cell so that it will not change from the time entered. I see that I can enter Ctrl+; [Space] Ctrl+Shift+; but I am looking for a way to assign that to one key combination.

Hello Folks, I'm new to this community and to Excel coding. Need some urgent help. I'm trying to show specific row based on a drop-down list. Below are the methods I've tried so far but no luck, really appreciate if someone can help! Code 1: Giving Error - Compile Error - Syntax Error...

Hello everyone. I am a VBA beginner. I need your help to solve my problem. Suppose that I have an Excel table with the following fields: D: Account L: Amount M: Category N: Value Day What I need to do is the following: Compute the conditional sums of the amounts by all possible unique...

Hi I need import and need to select the pdf file and send the same file to mail via Excel VBA forms. Can insert selected cell that imported file?

Dear all, I am an advanced VBA user as far as using it on the default Microsoft office applications is concerned. But currently I am writing a macro where it would be very beneficial to know how to control third party applications from VBA. Up till now I was quite successful using the Sendkeys...

Hi revered Excel experts, Quick version of the request: Userform textbox > text is sent to a table on another sheet under the header that matches the value selected from a dropdown list on the excel sheet > text is also sent to another table as a new header I'm really happy to be on this...

On my Excel spreadsheet: web address is in B, username in C, password in D, UN ID in E, PW ID in F, Button ID in G, land page (to go to after logged in) in H. Right click triggers below macro for that particular row. Succeeds in opening address in B, however not seeing log in credentials being...

Hi I have created a sheet within excel 2016 which brings up several popup box asking questions to the user to so no information is forgotten to be inputted in to the sheet, but if I input a figure in to the input box above 32,000 an error is shown overflow (error 6) is there away round this as...