+ Reply to Thread
Results 1 to 2 of 2

Code needed to rearrange data

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    83

    Code needed to rearrange data

    Hi All

    the attached file contains 2 tabs

    Sheet 1 & Sheet 2

    the target is to create sheet 2 based on the information in Sheet 1

    Sheet 2 A1 to P1 wil be already hardcoded so nothing to do in terms of code

    Sheet 2 A2 to D2 and rows below needs to be in the same format (white) as the attached
    Sheet 2 E2 to p2 and rows below needs to be in the same format (one row dark yellow the next light yellow) as the attached

    the key thing sheet 2 has to populate only data that contains the words "Renovation", "Disposal", "New sites" in sheet 1

    if we delete or add new rows in sheet 1, sheet 2 should update and reflect that change.

    Thanks in advance

    AC
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Code needed to rearrange data

    You may want to revisit the forum rules, especially to rules # 5 & 8

    cross-post: https://www.excelforum.com/excel-pro...criterias.html

+ 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. [SOLVED] VB Code or formula to rearrange data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2017, 07:35 PM
  2. [SOLVED] VB Code to rearrange the data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-29-2016, 06:12 AM
  3. [SOLVED] VB Code to find and rearrange
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-17-2016, 06:04 PM
  4. VBA code to collect and rearrange data coming from pivot table
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-02-2016, 02:56 AM
  5. [SOLVED] VBA code to rearrange data into multiple columns
    By shinobi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2013, 06:33 AM
  6. [SOLVED] Getting Error 1004 Object or Application Defined Error - Code to rearrange data
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-10-2013, 12:10 PM
  7. [SOLVED] Need code to rearrange select values
    By s4driver in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-22-2013, 10:16 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