Database --> Outroll with array vba

%3CLINGO-SUB%20id%3D%22lingo-sub-3463488%22%20slang%3D%22en-US%22%3EDatabase%20--%26gt%3B%20Outroll%20with%20array%20vba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3463488%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20try%20to%20get%20information%20from%20multiple%20databases%20in%20one%20worksheet%20on%20a%20specific%20row%2Fcolumn.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20explain%3A%3C%2FP%3E%3CP%3ESee%20pictures%20below.%20I%20want%20to%20start%20with%20an%20empty%20sheet%2C%20and%20when%20I%20press%20create%20outroll%20invoice%2C%20the%20vba%20code%20needs%20to%20look%20into%20other%20sheets(for%20example%20'sheet%201')%20row%20per%20row%20for%20specific%20information%20and%20put%20them%20in%20an%20specific%20order%20in%20a%20other%20sheet(sheet%202).%20After%20reading%201%20row%20from%20'sheet%201'%20he%20needs%20to%20read%20the%20information%20in%20the%20row%20below%20and%20put%20them%20also%20in%20sheet%202%20a%20few%20rows%20belows%20untill%20its%20empty.%20After%20reading%20sheet%201%2C%20I%20want%20to%20read%20other%20sheets%20as%20well%20and%20put%20them%20below%20in%20the%20outroll.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20seen%20multiple%20videos%20who%20are%20using%20array%20VBA%20to%20collect%20information%20and%20put%20them%20into%20other%20sheets%20and%20sometimes%20manipulating%20the%20numbers%20which%20is%20in%20my%20case%20not%20necessary.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20part%20to%20collect%20the%20information%20with%20array%20is%20clear%2C%20but%20to%20right%20them%20down%20in%20a%20specific%20order%20is%20for%20me%20not%20clear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20not%20clear%20yet%2C%20I'll%20show%20it%20with%20more%20examples.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Database_Sheet%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Database_Sheet%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377354i519F7DD31A820B19%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Database_Sheet%201.png%22%20alt%3D%22Database_Sheet%201.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Outroll_Sheet%202.png%22%20style%3D%22width%3A%20903px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Outroll_Sheet%202.png%22%20style%3D%22width%3A%20903px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377355iF8C869A2448C1E62%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Outroll_Sheet%202.png%22%20alt%3D%22Outroll_Sheet%202.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3463488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I try to get information from multiple databases in one worksheet on a specific row/column.

 

Let me explain:

See pictures below. I want to start with an empty sheet, and when I press create outroll invoice, the vba code needs to look into other sheets(for example 'sheet 1') row per row for specific information and put them in an specific order in a other sheet(sheet 2). After reading 1 row from 'sheet 1' he needs to read the information in the row below and put them also in sheet 2 a few rows belows untill its empty. After reading sheet 1, I want to read other sheets as well and put them below in the outroll.

 

I have already seen multiple videos who are using array VBA to collect information and put them into other sheets and sometimes manipulating the numbers which is in my case not necessary. 

 

The part to collect the information with array is clear, but to right them down in a specific order is for me not clear.

 

If this is not clear yet, I'll show it with more examples. Database_Sheet 1.pngOutroll_Sheet 2.png

0 Replies