Software

Ask something
Question Locked

Populate an Excel Template from a different excel file?

0 helpful
3 replies

by rothman_24

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

There has to be an app out there that can take columns A,C,F and X (for example)of one spreadsheet and paste them into a template spreadsheet (one that has the columns already designated).

Thanks!

3 replies

by thumbsup2

There are a couple of ways to make Excel do it for you.

One way is to place linked formulas in the template which references cells in the first spreadsheet. However, each time you change the first file name (like you may do annually?), you'll have to change the links in the template spreadsheet to reflect the new file name.

Another way is to create macros in the template that, when executed, can open a spreadsheet, extract data from it and paste it into the template spreadsheet. These macros can get as fancy as you want them to be. The downside is that to do it right, you have to learn Visual Basic.

I use the 2nd method to populate a master list that gets reset back to empty each year and filled from data residing in several other spreadsheets, CSV and DBF files. The programming is quite extensive, but it sure beats opening files on a weekly basis, locating the data I want, then copying and pasting into the master list.

by daniel

I have been trying to figure this out forever. I need to take the information from cell "E47" in excel document "A" and transfer it to cell "B5" in excel document "B" is that possible? and if so what are the steps?

Thanks so much, this will make my work much easier.

This discussion is closed to new replies.