+ Reply to Thread
Results 1 to 2 of 2

Manipulating and populating the data from sheet X to sheet Y using dynamic VBA script

  1. #1
    Registered User
    Join Date
    04-21-2020
    Location
    toronto
    MS-Off Ver
    2017
    Posts
    23

    Manipulating and populating the data from sheet X to sheet Y using dynamic VBA script

    Hi guys, just wanted to ask for your suggestions on how to approach the 2 following issues in terms of writing the script that I need to populate data from sheet X into template within sheet Y.

    1) Multiple items divided by “;” are in column B within sheet X and need to be split once moved to template Y, but in the separate row of the same column. E.g. x;g;h; in the cell B2 (sheet X) would need to be populated into template Y as B2 for x,B3 for g, B4 +h. How should I go about it?

    2) I have a shortcut of signs in the identification section of the sheet X (lets say in column D), the values are in the following format (all in D2): (ID):1234;(IB): 321; (IC):213.
    Now I need to move the following to template Y where ID = Identification; IB = Internet barcode and IC = Identification of court (as per the created lookup table). How do I write a code that reads from look up table and populates this data into new table as new expanded/ expressive form? E.g. (ID):1234;(IB): 321; (IC):213 in sheet X -> (Identification):1234;(Internet Barcode): 321; (Identification of Court):213 in sheet Y (e.g. also column D2)

    3) This is related to issue 1..How do I copy multiple records from sheet X populating them into Y, if I want the next record to be populated into A column and the first (full) available row? Given the scenario in section 1 (i.e. according to example given above, the new record would start in A5 as x;g;h was moved to C2-C4).

    Hope the above makes sense!

    Thank you so much - Any guidance/help would be appreciated!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Manipulating and populating the data from sheet X to sheet Y using dynamic VBA script

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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: 11
    Last Post: 12-19-2016, 10:37 AM
  2. Replies: 1
    Last Post: 10-10-2015, 01:54 PM
  3. Automatically populating data from Sheet 1 to Sheet 2 ONLY if certain criteria are met
    By Spifferific in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-12-2015, 01:03 PM
  4. Replies: 1
    Last Post: 10-17-2014, 02:59 PM
  5. [SOLVED] edit a script that gets data from one sheet and displays on another sheet
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2014, 01:44 AM
  6. Replies: 6
    Last Post: 04-14-2012, 02:37 PM
  7. Populating Summary Sheet From Data Sheet
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2011, 11:11 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