A good way to learn is to record a macro while doing it manually. Then,
clean it up.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peterzh193" <u52491@uwe wrote in message news:976376fa566ea@uwe...
I am designing a €œbasic€� database in work and having trouble with some
macros

The database is a record of production. Information is added at pre and
post
production. Adding the pre-production information I have sorted. A form is
filled in, submit button hit and a new row is created with the information
in.
Along this row there are gaps where post production information is
entered,
but trying to get this information to paste into the correct row I cant
do.

I have a form to fill in the information (one each for pre and post
production) which I then want adding to the database against the reference
number. Converting the information from the input form into the database I
can do for pre production, but getting the post-production data entered
into
the database along the correct row I dont know how to get there.

I believe I want a search function that takes the database reference
number
(on the post-production form) and finds this in column A. once this ref
number is found, the cell is active and I can to paste the information
from
the post production form into the gaps on the correct row

Anyone have a clue?

how do i record a "find"?

Don Guillett wrote:
A good way to learn is to record a macro while doing it manually. Then,
clean it up.

I am designing a €œbasic€� database in work and having trouble with some
macros
[quoted text clipped - 24 lines]

Anyone have a clue?

on the toolbar menu
select your rangeEDITfind

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peterzh193" <u52491@uwe wrote in message news:9764abd6dd7b6@uwe...
how do i record a "find"?

Don Guillett wrote:
A good way to learn is to record a macro while doing it manually. Then,
clean it up.

I am designing a €œbasic€� database in work and having trouble with some
macros
[quoted text clipped - 24 lines]

Anyone have a clue?

ah right! ok...i am using Excel 2007 where do i find this???

Don Guillett wrote:
on the toolbar menu
select your rangeEDITfind

how do i record a "find"?

[quoted text clipped - 6 lines]

Anyone have a clue?

ok i have found it, but struggle to get it reference the cell

Peterzh193 wrote:
ah right! ok...i am using Excel 2007 where do i find this???

on the toolbar menu
select your rangeEDITfind
[quoted text clipped - 4 lines]

Anyone have a clue?

HOME tab, EDITING group

"Peterzh193" <u52491@uwe wrote in message news:97655425f8e38@uwe...
ah right! ok...i am using Excel 2007 where do i find this???

Don Guillett wrote:
on the toolbar menu
select your rangeEDITfind

how do i record a "find"?

[quoted text clipped - 6 lines]

Anyone have a clue?

Sub demoFIND()

Dim cell As Range
Dim addr As String
Dim what As String
what = "ABC"

Set cell = Cells.Find(what)

If Not cell Is Nothing Then
addr = cell.Address
Do
cell.Interior.Color = vbRed
Set cell = Cells.FindNext(cell)
Loop While cell.Address < addr
End If

End Sub

' NOTE that FIND is circular, so once its found all the cells it starts
again....so we save the first address and check until FIND loops back and
starts again

code was probably originally from HELP in Excel 2000.

Is this helpful?

"Peterzh193" <u52491@uwe wrote in message news:97655e2521620@uwe...
ok i have found it, but struggle to get it reference the cell

Peterzh193 wrote:
ah right! ok...i am using Excel 2007 where do i find this???

on the toolbar menu
select your rangeEDITfind
[quoted text clipped - 4 lines]

Anyone have a clue?