+ Reply to Thread
Results 1 to 2 of 2

Creation of labels with database outpu and qr

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Switzerland
    MS-Off Ver
    Office 365
    Posts
    1

    Creation of labels with database outpu and qr

    Dear All

    I have following issue in Excel Office 365. From the database my company is using we receive the following table (Here is a dummy as the Database output is not ready yet):

    See first sheet (Input)

    From This Table I want to create labels which will look like seen here:

    See sheet Result.

    So what I want to do take the info from every even row until row x in the first sheet and transfer the information to the label so it can be filled in the results sheets in as seen above. I found a solution how to seperate every secon row as seen here I used the Offset function in a separate sheet which will be hidden later:

    See sheet Conversion_1 (e.g. =OFFSET((Input!$A$2);(ROW()-2)*2;0))

    The issue is now if I now try to fill in the Result page with all the info combined it is always incrementing the results by 4 rows.

    Now is there a function to take the table from the last picture and make another table automatically where between each data row are four blank rows?


    The QR-Codes which I use I create so far with Google Sheets as it has a function built in to create it, meaning i will just copy the Codes from the sheet and adjust them in size. Is there a similar function from base Excel?

    Thank you for your help, this is my first post here so If I made mistakes or did not describe the issue good enough please tell me.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Creation of labels with database outpu and qr

    Hello Ethandir and Welcome to Excel Forum.
    Perhaps this will get you closer to what you want.
    As modeled in column Q on the Conversion_2 sheet the following Get & Transform advanced editor code to produces a column that has four rows per HGT code:
    Please Login or Register  to view this content.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Database creation
    By OSanmie in forum Excel General
    Replies: 1
    Last Post: 01-21-2020, 01:05 AM
  2. Database creation
    By mvidusek in forum Excel General
    Replies: 5
    Last Post: 10-24-2017, 03:10 PM
  3. Contract Database creation
    By mc1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2017, 10:15 AM
  4. Database creation
    By senjuti.sarkar in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-18-2013, 08:16 AM
  5. Database creation
    By garethdjohn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2012, 10:34 AM
  6. Creation of a database through a questionnaire
    By gkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2011, 06:46 AM
  7. .xml database creation
    By Miguel Braz in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 02-14-2005, 08:06 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