Loop. Compare. Paste.

  • Hello OzGrid Community,

    I need some help. Here's what I'm trying to do. I have a workbook that analyzes schedule and cost information. The workbook has over a dozen tabs, using the same set of data/information, but just calculating different types of variances.

    In the first tab, there is an abundance of raw data pulled extracted from an MS Project file. The raw data includes the following columns of data:
    1. Task Name
    2. Milestone
    3. Summary
    4. Pct Complete
    5. Successor
    6. External Task
    7. Constraint Type
    8. Constraint Date
    9. Duration
    10. Baseline
    11. Start Date
    12. Finish Date
    13. Critical
    14. Recurring
    15. Total Slack
    16 Actual Finish
    17. Actual Start

    There are 20 subsequent tabs, where various inputs (e.g., Task Name, Milestone, Summary, etc.) are required to do various different types of automated calculations. How do I use macros to pull desired information from Tab 1 into the subsequent tabs? A lot of it is repetitive information, and cut and pasting this would be easy but time consuming and tedious. I'm hoping there's a quicker way to accomplish this task with macros.

    Any help or insight would be appreciated.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!