+ Reply to Thread
Results 1 to 8 of 8

Changing each record in a database to 5100 records of each

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Changing each record in a database to 5100 records of each

    Hi guys,

    I'm hoping someone can help me with a "brute force" or other method of changing each record in my database (.csv) into 5100 records of each individual record. I've attached a sample of the database containing 106 records down column A.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Changing each record in a database to 5100 records of each

    .
    What is meant by : " into 5100 records of each individual record." ??

  3. #3
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: Changing each record in a database to 5100 records of each

    In the database I would like what is presently A2 to be the same A2 through A5101. What is currently A3 I would like to be A5102 through A10201.... and so on

  4. #4
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: Changing each record in a database to 5100 records of each

    So I have 5100 instances of each record.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Changing each record in a database to 5100 records of each

    .
    Will Column A be the only data on the sheet ? Will the other columns be empty ?

  6. #6
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Changing each record in a database to 5100 records of each

    .
    Presuming Column A will have the only data on the sheet :

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-25-2014
    Location
    Alabama
    MS-Off Ver
    Excel MAC 2011
    Posts
    39

    Re: Changing each record in a database to 5100 records of each

    This worked beautifully Logit!
    Thank you so much. Sorry I couldn't get back to you when you asked a question, I had a lunch meeting and didn't see it until my return.

    This does exactly what I needed to do! Now I just have to run it on 2 dozen databases. We will be pulling the data from these databases to print a barcoded label. 5100 each of around 2200 different sku numbers. You saved me hours of headache!

    Thanks again, Chris

  8. #8
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Changing each record in a database to 5100 records of each

    .
    Glad to help ! You are welcome.

+ 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] Adding a record without seeing other records
    By Finalfrontier1976 in forum Access Tables & Databases
    Replies: 5
    Last Post: 03-23-2018, 04:25 AM
  2. Find the initial parent record based on the records in the last child records
    By Journeyman3000 in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-30-2017, 08:46 PM
  3. [SOLVED] excel navigate records if end record display end of record
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2017, 06:04 AM
  4. Changing OnExit event for control prevents changing records...
    By jik_ff in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-31-2014, 03:09 PM
  5. [SOLVED] How can I identify if a record has two different records?
    By jgomez in forum Access Tables & Databases
    Replies: 5
    Last Post: 01-27-2014, 02:43 PM
  6. Userform - search database for matching records, find next if more than one record
    By beaterfred in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 11:56 AM
  7. Massive Excel File 5100 ROWS,10 COLUMNS subcategorized + sharepoint HELP
    By earlybird in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2008, 11:37 PM

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