Hi there,
Yes i'm a noob, i try to make myself a simple invoice and keep data for my taxe, for my tiny side line.
I got on the sheet'' Facture Papillon'' 15 cell i want to be copy when i run the macro, on a range '' A2 to O2'' on sheet ''VENDU''. But each time on the next empty range. (A2:O2), next time (A3:O3)
Like this:
Sheet''Facture Papillon'' cell(F4) TO Sheet''VENDU'' cell(A2)
Sheet''Facture Papillon'' cell(F5) TO Sheet''VENDU'' cell(B2)
Sheet''Facture Papillon'' cell(F6) TO Sheet''VENDU'' cell(C2)
Sheet''Facture Papillon'' cell(D11) TO Sheet''VENDU'' cell(D2)
Sheet''Facture Papillon'' cell(D12) TO Sheet''VENDU'' cell(E2)
Sheet''Facture Papillon'' cell(D13) TO Sheet''VENDU'' cell(F2)
Sheet''Facture Papillon'' cell(D14) TO Sheet''VENDU'' cell(G2)
Sheet''Facture Papillon'' cell(D15) TO Sheet''VENDU'' cell(H2)
Sheet''Facture Papillon'' cell(D16) TO Sheet''VENDU'' cell(I2)
Sheet''Facture Papillon'' cell(FD17) TO Sheet''VENDU'' cell(J2)
Sheet''Facture Papillon'' cell(D20) TO Sheet''VENDU'' cell(K2)
Sheet''Facture Papillon'' cell(D21) TO Sheet''VENDU'' cell(L2)
Sheet''Facture Papillon'' cell(D22) TO Sheet''VENDU'' cell(M2)
Sheet''Facture Papillon'' cell(D23) TO Sheet''VENDU'' cell(N2)
Sheet''Facture Papillon'' cell(D24) TO Sheet''VENDU'' cell(O2)
I search here a lot, i found thing looking a bit like that but never be able to modify it to make it work for me.
Il give you a link to my invoice in gdrive
Don't worry about my sheet being in french, i will translate all.
And no i'm not posting on the french side, because everytimes i've done that nobody was anwsering after some days.
I know the english side to be more visit then the french side.
Thanks in advance to you mister or miss VBA pro
Michellin
Yes i'm a noob, i try to make myself a simple invoice and keep data for my taxe, for my tiny side line.
I got on the sheet'' Facture Papillon'' 15 cell i want to be copy when i run the macro, on a range '' A2 to O2'' on sheet ''VENDU''. But each time on the next empty range. (A2:O2), next time (A3:O3)
Like this:
Sheet''Facture Papillon'' cell(F4) TO Sheet''VENDU'' cell(A2)
Sheet''Facture Papillon'' cell(F5) TO Sheet''VENDU'' cell(B2)
Sheet''Facture Papillon'' cell(F6) TO Sheet''VENDU'' cell(C2)
Sheet''Facture Papillon'' cell(D11) TO Sheet''VENDU'' cell(D2)
Sheet''Facture Papillon'' cell(D12) TO Sheet''VENDU'' cell(E2)
Sheet''Facture Papillon'' cell(D13) TO Sheet''VENDU'' cell(F2)
Sheet''Facture Papillon'' cell(D14) TO Sheet''VENDU'' cell(G2)
Sheet''Facture Papillon'' cell(D15) TO Sheet''VENDU'' cell(H2)
Sheet''Facture Papillon'' cell(D16) TO Sheet''VENDU'' cell(I2)
Sheet''Facture Papillon'' cell(FD17) TO Sheet''VENDU'' cell(J2)
Sheet''Facture Papillon'' cell(D20) TO Sheet''VENDU'' cell(K2)
Sheet''Facture Papillon'' cell(D21) TO Sheet''VENDU'' cell(L2)
Sheet''Facture Papillon'' cell(D22) TO Sheet''VENDU'' cell(M2)
Sheet''Facture Papillon'' cell(D23) TO Sheet''VENDU'' cell(N2)
Sheet''Facture Papillon'' cell(D24) TO Sheet''VENDU'' cell(O2)
I search here a lot, i found thing looking a bit like that but never be able to modify it to make it work for me.
Il give you a link to my invoice in gdrive
Factures Les papillons de Francois.xlsx
drive.google.com
Don't worry about my sheet being in french, i will translate all.
And no i'm not posting on the french side, because everytimes i've done that nobody was anwsering after some days.
I know the english side to be more visit then the french side.
Thanks in advance to you mister or miss VBA pro
Michellin