Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically populate cells jon boy Excel Discussion (Misc queries) 0 January 23rd 08 12:13 AM
User Name Automatically Populate nabanco Excel Worksheet Functions 7 October 29th 07 04:41 PM
Populate lists automatically New2XL Excel Discussion (Misc queries) 5 September 22nd 06 10:08 AM
How to automatically populate the next available invoice # Laurie Excel Worksheet Functions 1 June 19th 06 05:30 PM
create a userform to populate a diagram with the forms info Mic Excel Discussion (Misc queries) 0 July 22nd 05 08:07 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"