Need different data each time from different sheet

Closed
nisari Posts 1 Registration date Monday February 12, 2018 Status Member Last seen February 12, 2018 - Feb 12, 2018 at 06:23 AM
xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Feb 12, 2018 at 01:29 PM
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

xpcman Posts 19532 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,833
Feb 12, 2018 at 01:29 PM
I suggest you contact a development Programmer to design a series of Macros for you.

Good Luck
0