Auto fill new rows from one workbook to another

Question

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.&nbsp;

mathetes · Answer

mariahunt1959&nbsp;&nbsp;You would need to give a few more details in order for anything but the most general suggestions to be made. And if possible even post a copy of the workbooks you have in mind. (Without any confidential information).&nbsp;In the absence of more detailed information, let me point you in the direction of one possible solution by means of suggesting you view the attached video. https://www.youtube.com/watch?v=9I9DtFOVPIg&nbsp;

mariahunt1959 · Answer

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.&nbsp;I would like to create a formula&nbsp;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

mathetes · Answer

mariahunt1959&nbsp;Again, without seeing the actual spreadsheet--rather than just a few words that provide at best a very general description--it's hard to give anything but the most general of suggestions.&nbsp;How familiar are you with Excel? My guess, since you're asking this question, is that you're fairly unfamiliar. One of the most popular functions is VLOOKUP. The appropriate use of VLOOKUP could well do what you've described, looking up the relevant data from each row in that sales information sheet and populating the appropriate cells in the Invoice spreadsheet.&nbsp;XLOOKUP is also available, a newer and more powerful function.&nbsp;And then, too, there's MailMerge, with Excel serving as the source data and Word as the creator of the Invoice. Going that route would give you a LOT more flexibility with the layout and look of the invoice, a more professional result.&nbsp;If you are able to provide either the actual spreadsheets you're working with, or a mockup or two with dummy data, somebody here could give more specific and direct solutions. Short of that, here's another internet source with descriptions of the lookup functions I've mentioned.https://exceljet.net/search?query=lookup&nbsp;

yea_so · Answer

mariahunt1959&nbsp;That would involve defining the&nbsp;[&nbsp;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.&nbsp;Then&nbsp;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.&nbsp;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&nbsp;&nbsp;

Forum Discussion

Auto fill new rows from one workbook to another

4 Replies

Resources