Results 1 to 2 of 2

VBA to run multiple macros, combolist and copy/save data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-13-2022
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    110

    VBA to run multiple macros, combolist and copy/save data

    Hello helpers,

    I've attached a scheme of the issue I face. Basically I have a combo box with list of products which I want to run. Each product that is run returns results in cells G10 and G11. I already have two other macros (get data and clear data). Here is how I wanted the operation of the VBA code to go:

    1. Run clear data macro
    2. Select product A in the combo box
    3. Run get data macro
    4. Copy value in G10 and G11 to columns E and F of sheet 2 respectively
    5. Run clear data macro
    6. Select product B and loop the process until the last product

    I am sorry I'm unable to share the data. Please assume that the two macros would perfectly well.

    Thanks in advance for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Save copy without macros while saving main workbook
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2018, 03:18 PM
  2. Save Copy Filename As Without Including Macros
    By mudajaya in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2016, 02:52 AM
  3. [SOLVED] Need to Copy/Save Entire Workbook as .XLSX but Keep Macros Running
    By bryanmarks in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2014, 07:43 PM
  4. Copy data into multiple rows using macros and insert zero
    By DeepthiBas9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2014, 07:35 AM
  5. [SOLVED] How to develop a macros to auto copy and save data on series basis to another sheet
    By warriorpoet7176 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-06-2014, 05:21 AM
  6. Macros running when I save a different copy of excel workbook
    By chidmas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2013, 12:49 PM
  7. Save a copy of workbook without macros
    By nnram123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2009, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1