View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default code for storing data

Copy the function also in the module Maggie

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Maggie" wrote in message ups.com...
On Mar 16, 11:56 am, "Ron de Bruin" wrote:
Start here Maggiehttp://www.rondebruin.nl/copy1.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Maggie" wrote in ooglegroups.com...
I need help on trying to store data from one worksheet and move it
over to another worksheet row. I have set up an logical table to tell
what cell goes in what row for the worksheet but I do not know how to
command it to store now. For example I want cell A1 in sheet 1 to go
to row A in sheet summary. I am trying to make a database that would
store 50 different items instead of having a worksheet for each item I
want to fill out the form once for each item and move the data over to
the summary sheet. Any help would be appreciated. Thanks!- Hide quoted text -


- Show quoted text -


I tried to use the code that Ron provided but I still get an error
about the Lr. I But what I am trying to do is store data into another
worksheet in the same workbook.