Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zak Zak is offline
external usenet poster
 
Posts: 144
Default Copying data entered into a form to another workbook

Hi

I'd like to know if it is possible to do the following:

1) I have created a form, but as well as wanting the form to copy the data
into a worksheet within the workbook the form was created in, I would like
the same information to be copied into a different workbook at the same time.
Is this possible?

i.e. the form prompts for name, date and time. I would like this info to be
copied into a worksheet in cell ref a4,b4,c4 respectively, BUT also into a
different workbook in cell ref a4,b4 and c4.

Thanking you in advance.
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
data from one workbook automatically entered into another workboo. cfrt Excel Discussion (Misc queries) 1 September 10th 08 01:11 AM
Copying data entered in the last cell of a row on the same spreads Jennifer Excel Worksheet Functions 2 February 6th 08 01:11 AM
Copying data in a form into an alternative Workbook dave m Excel Discussion (Misc queries) 1 January 1st 08 06:06 PM
Highlight if Data entered appears in another workbook mg_sv_r Excel Worksheet Functions 0 May 23rd 06 03:40 PM
Copying data form website gunny1979 Excel Discussion (Misc queries) 2 April 3rd 06 01:56 PM


All times are GMT +1. The time now is 10:23 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"