Auto fill new rows from one workbook to another

I would like to auto fill new rows in a workbook when new entries are done in another workbook with only a select number of columns.

excel

mariahunt1959

Copper Contributor

May 06, 2021

Thank you Mathetes. Great video!

Here's the example:

We have a large spreadsheet with sales information, where each time a salesperson has a new sale, they enter the unique identifier for that sale with all the pertinent information, name, date, company, etc.

I would like to create a formula in the invoice spreadsheet that whenever a new row in sales is added, the identifier, name and company is automatically added to the invoice spreadsheet.

Thank you,

Maria Hunt

Yea_So

Bronze Contributor

May 10, 2021

mariahunt1959 That would involve defining the

[ large spreadsheet with sales information, where each time a salesperson has a new sale, they enter the unique identifier for that sale with all the pertinent information, name, date, company, etc.] to be formatted as an excel Table.

Then

Using a Function in a formula that has the spill feature to populate the details of the invoice such as Vlookup(). We can't suggest anything specific unless you provide us with a map of what your spreadsheet looks like otherwise our suggested specific formula will not work due to lack of the geographic information about your specific solution.

We have to know what your spreadsheet looks like in order to know where what field is in which row and in which column to suggest a specific application of the formula.

cheers

Forum Discussion

Auto fill new rows from one workbook to another

Resources