Transfer A Row From Sheet 1 To 2

[GeorgeF]

On Sheet #1, I make a listing of all jobs that come in consisting of
row of 9 cells for each under common columnar headings, includin
Startup Date, Customer No. and Name, Job Number, 2 Job Descriptions
and Invoice Date, Amount and Number. The job is considered complet
when the Invoice info is entered (3 cells). Many of the Customers ar
active enough to suggest activity analysis, such that they have thei
own sheet. I want to transfer the appropriate row of data (9 cells
for select customers to their respective Sheets (#2,3,4,etc.) in a
orderly and automatic fashion, i.e. upon entry of the Invoice info.
know I can copy and paste, but that is so old fashioned and I'm onl
semi-automatic. I have combined some IF/AND statements, but I have ro
spaces on the Customer Sheet equal to their infrequency of occurrence o
the Journal Sheet #1. Am I heading in the right direction and just hav
to work harder, or is their a magic relationship that I must learn

 

[Kassie]

Hi GeorgeF,

Shall I say welcome to the world of Macro's! That's the way to go my
friend. I don't know how much you know about macros, and I cannot really
give advise with the limited info at hand, but that is the way to go.