Need different data each time from different sheet [Closed]

Report
Posts
1
Registration date
Monday February 12, 2018
Status
Member
Last seen
February 12, 2018
-
Posts
19539
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
So I'm making an invoice form in which i need to insert data from another excel, which is a list that includes names/e-mails/amount paid/etc.
Is there any way I can make this proccess more automatic since the number of data is very big.

The data in my list worksheet are presented along the row, is there any way i could type that if this invoice is invoice number 2, then, this box should take the data of D2 (from the list worksheet) , then that box C2 and if 3, then D3, C3 etc.??

1 reply

Posts
19539
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,695
I suggest you contact a development Programmer to design a series of Macros for you.

Good Luck

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!