ONGOING DATABASE ENTRY PROBLEM

[APPPRO]

I posted a request to how you can enter multiple entries for a uique item under one template at the same time. The board master gave me a macro that might help. BUT even if it works - it still leaves the problem of "updating and or fixing" the original entry - without going into the database itself. Templates will allow me to do multiple entries, albeit one at a time, but it will only Update the LAST one.

HELP!

apppro@aol.com

 

[PaddyD]

realy not clear enough! If your previous post contains relevant info, include a link, if it doesn't provide the details here - starting data, problem, expected outcome etc.

paddy

 

[APPPRO]

I've come up with the following. It works great to enter several lines of data on Sheet FORM to the next empty row on Sheet MAIN.
But I would like NOT to have to Activate Sheet B inorder to do it.

Actually, I would like to have 2 WorkBooks instead.

Any ideas?

Sub ENTER_TO_DB()
'
' ENTER_TO_DB Macro
' Macro recorded 10/16/02 by ANDREW P. POLSKY
'

'

Range("E1:L4").Copy
Sheets("MAIN").Select
Range("M16").Select
Cells.FindNext(After:=ActiveCell).Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("FORM").Select
Application.CutCopyMode = False
End Sub
This message was edited by APPPRO on 2002-10-16 09:42