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 moving data from a form to another sheet

I have data on a form that I need moved to another sheet based on a product
name. How do I do this


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default moving data from a form to another sheet

"Kimberly Heffernan" wrote
I have data on a form that I need moved to another sheet based on a product
name. How do I do this


If you mean auto-"copy" lines from a parent sheet (that would be your
"form")
to individual "child" sheets (sheets by product name) going by the product
names listed in a key col in the parent sheet, try this recent posting:
http://tinyurl.com/28mz9s

There's a sample file given which illustrates the functionality,
link reproduced below:
http://www.freefilehosting.net/download/3d0e4
AutoSlice lines by ID col to respective sheets.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


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
Moving data from master sheet to new sheets Midget Excel Worksheet Functions 8 May 8th 07 03:33 AM
moving data from one sheet to another David Excel Discussion (Misc queries) 3 February 1st 07 04:58 PM
Moving data from one sheet to another automatically holyman Excel Discussion (Misc queries) 2 July 4th 06 02:44 PM
how to get a data form to fill you own exel sheet (was data-form erik van buijtenen Excel Worksheet Functions 2 May 30th 06 05:31 PM
Moving data from one sheet to another- How to? mbqc Excel Worksheet Functions 2 May 8th 06 06:05 AM


All times are GMT +1. The time now is 03:27 AM.

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

About Us

"It's about Microsoft Excel"