ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Automatically populate forms (https://www.excelbanter.com/excel-worksheet-functions/190601-automatically-populate-forms.html)

excel_expert_wannabe

Automatically populate forms
 
Hi,

I'm trying to automatically populate forms and I can't figure out how to do
this. I have about 243 data records and I'd like to format each record in a
particular layout. In order to save lots of time, I'd like to create a form
that automatically pulls from each subsequent line in the dataset on separate
tabs. Anyone have any help for me?

Thanks!

Max

Automatically populate forms
 
It's quite tough to visualize what you have/seek to do ..

Could you upload your sample file/data/expected results
using a free filehost, then post a link to it here?

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

Then again, perhaps a possible close?? fit to your query ..

Try my recent response to another poster at:
http://tinyurl.com/68rjwo

There's also a nice sample file which illustrates:
http://www.savefile.com/files/1600987
AutoCopy Lines by Key Col to Resp Sheets.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"excel_expert_wannabe" wrote:
I'm trying to automatically populate forms and I can't figure out how to do
this. I have about 243 data records and I'd like to format each record in a
particular layout. In order to save lots of time, I'd like to create a form
that automatically pulls from each subsequent line in the dataset on separate
tabs. Anyone have any help for me?

Thanks!



All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com