search and copy info

Hi everyone, I am trying to extract data from a website using VBA. This is the web site: https://gmsip.com.pa But i can not add my range of data to search bar is there any solution to this problem ? no i want to add IMO numbers for ship in the excel sheet and VBA run them in website and...

Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA...

Hi, I'm trying to find a medication displayed on sheet 1 within a list of medications (displayed on sheet 3) and output its relevant usage (relevant totals cell displayed on sheet 2) - for example if Allopurinol 100mg tabs is the medication displayed on sheet 1, then the quantity cell should...

So what I am trying to do is if data in the DATA tab in columns 1 & 5 match with columns 1 & 2 in the INDEX tab then take the data in the 3 adjacent columns and place it in the UPLOAD tab. After this is done I need to go to the next row and do the same Example. if Robert def in the DATA tab...

Hello, I have a search functionality in an Excel workbook which searches according to a cell value from worksheet, "Search students", searches within worksheet, "2017-18 student list", then copies and pastes the find results in a third worksheet, "Search Results". My problem concerns the...

So I am looking to make a macro to do the following: Find the number of tabs with "Test" in the first cell (A1) For each tab: Copy sheet name and paste into Sheet named "Main" Copy row 6 from sheet and paste into Sheet named "Main" Continue until all sheets with the "test" in the first cell...

Hello all,, please forgive me I posted a similar question a couple of days ago but did not explain very well Im trying for our local charity to write a medic logging VBA Excel,, one of the user forms is to log up eight drugs (ufmedication) the form consists of a listbox (lbdrugs) sourced from a...

Hi All, I was wondering if any one could help with a some coding that i'm trying to find. I have created a user form which contains a text box, which i will be copying multiple rows into from another workbook. i was wondering if anyone has ever created some code to the copy the information...

I would like to be able to use a macro that ask for apart of an web address then use that address to get the information I want. Example: Items bold and underlined needs to be changed Sub Macro1() ' ' Macro1 Macro ' look at me ' ' With ActiveSheet.QueryTables.Add(Connection:= _...

Hi Guys, It's been a very long time since I've done anything in VBA and I'm struggling to get a Macro to do what I want. Basically I have a customer database I've setup an entry form (sheet 1) and macro to copy the data to the database (Sheet 2) which automatically calculates a follow-up date...

Hi all, I am looking for some help with writing a macro to copy and paste some data between worksheets if it meets certain criteria. I have been trying to write a macro that works in a loop as the amounts of data I am refering to will vary. Basically, I have 3 sheets; IMPORT - this contains a...

Good day to everyone! I need help with VBA. Here's the specific steps that the macro should do: 1. macro should go to this URL: http://faces.tap.ibm.com/ 2. text box will appear to ask for the name of the employee to be searched 3. paste name to the search box 4. open that person's profile 5...