Auto fill new rows from one workbook to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2311386%22%20slang%3D%22en-US%22%3EAuto%20fill%20new%20rows%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2311386%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20auto%20fill%20new%20rows%20in%20a%20workbook%20when%20new%20entries%20are%20done%20in%20another%20workbook%20with%20only%20a%20select%20number%20of%20columns.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2311386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315650%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20new%20rows%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315650%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041964%22%20target%3D%22_blank%22%3E%40mariahunt1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20need%20to%20give%20a%20few%20more%20details%20in%20order%20for%20anything%20but%20the%20most%20general%20suggestions%20to%20be%20made.%20And%20if%20possible%20even%20post%20a%20copy%20of%20the%20workbooks%20you%20have%20in%20mind.%20(Without%20any%20confidential%20information).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20absence%20of%20more%20detailed%20information%2C%20let%20me%20point%20you%20in%20the%20direction%20of%20one%20possible%20solution%20by%20means%20of%20suggesting%20you%20view%20the%20attached%20video.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2331779%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20new%20rows%20from%20one%20workbook%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2331779%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Mathetes.%20Great%20video!%3C%2FP%3E%3CP%3EHere's%20the%20example%3A%3C%2FP%3E%3CP%3EWe%20have%20a%20large%20spreadsheet%20with%20sales%20information%2C%20where%20each%20time%20a%20salesperson%20has%20a%20new%20sale%2C%20they%20enter%20the%20unique%20identifier%20for%20that%20sale%20with%20all%20the%20pertinent%20information%2C%20name%2C%20date%2C%20company%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20formula%26nbsp%3Bin%20the%20invoice%20spreadsheet%20that%20whenever%20a%20new%20row%20in%20sales%20is%20added%2C%20the%20identifier%2C%20name%20and%20company%20is%20automatically%20added%20to%20the%20invoice%20spreadsheet.%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EMaria%20Hunt%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

4 Replies

@mariahunt1959 

 

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).

 

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

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...

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

@mariahunt1959 

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.

 

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.

 

XLOOKUP is also available, a newer and more powerful function.

 

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.

 

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

 

@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