Need different data each time from different sheet [Closed]

Question

Need different data each time from different sheet [Closed]

Report

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: 19539
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.??

Need different data each time from different sheet
How to transfer data in excel from one sheet to another - How-To - Excel
How to auto populate data from master to multiple sheets ✓ - Forum - Excel
Excel - Copy data from a range of sheets to a master sheet - How-To - Excel
How To Auto Transfer Data from Master to Sub Sheets in Excel - How-To - Excel
Populate Multiple Sheets Based on Data Entered in a Main Excel Sheet - How-To - Excel

1 reply

Ask a question

xpcman · Answer 1 · 2018-02-12T13:29:14-0500

Answer 1 / 1

xpcman

Posts: 19539
Registration date: Wednesday October 8, 2008
Status: Contributor
Last seen: June 15, 2019

1,695
Feb 12, 2018 at 01:29 PM

I suggest you contact a development Programmer to design a series of Macros for you.

Good Luck

Need different data each time from different sheet [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!