+ Reply to Thread
Results 1 to 2 of 2

Loop Through Multiple Worksheets With Different Formats and Grab Data From VBA R[] C[]

  1. #1
    Registered User
    Join Date
    12-27-2021
    Location
    Kansas City, Missouri
    MS-Off Ver
    2013 (upgrading soon)
    Posts
    1

    Smile Loop Through Multiple Worksheets With Different Formats and Grab Data From VBA R[] C[]

    Hello VBA Community,

    I have recently expanded from mostly working with imbedded formulas in Excel to working on learning more on the capability of VBA. I am struggling with transitioning from sheet imbedded to VBA content with relative references. On top of that, I am working on a project that will run through around 100 worksheets that have 2 different formats so I will need to distinguish which format to choose based on an in worksheet identifier.

    So far I have an independent macro that combines all data worksheets into one workbook, then in "copycell()", copy formulas to all sheets for the data, then pull values only from each one of those sheets and combine it into one master sheet, then delete all of the rows that have zeros in column "AM".

    As many of you are guessing, the runtime for this is slow and when I am able to include the case for the other sheet type, which I am not sure how to do, it will likely slow down more. Would anyone give me some guidance on how to make this faster as well as imbedding it into VBA rather than cell formulas? I would think the relative references would need variables and a counter because some inputs will apply to multiple lines while others are unique each line, but repeat further down the list.

    I have included my workbook for you to check out what I have. On the Formulas tab you will see the formulas that I am using starting at "AJ7." I really appreciate any help you are willing to give me as well as I can provide more information if needed. This is my first post but I have already learned a lot from this forum by reading other's posts and am looking forward to learning more.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,463

    Re: Loop Through Multiple Worksheets With Different Formats and Grab Data From VBA R[] C[]

    As the macro is dealing with text files, it is better to upload a few sample text files and the result that you want in Excel workbook, clearly showing the process/calculation etc.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 05-10-2016, 09:33 PM
  2. Replies: 1
    Last Post: 03-20-2015, 08:47 PM
  3. Loop through and grab data from same cells
    By puzzlelover22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2015, 01:00 PM
  4. [SOLVED] Open worksheets, grab data problem
    By andysmith84 in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 01-31-2013, 02:46 PM
  5. Replies: 2
    Last Post: 01-21-2013, 02:26 PM
  6. Copying formats - column widths, formats, outlining to worksheets
    By DavidBr318 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2005, 09:05 AM

Tags for this Thread

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