Your assumptions are correct but not often followed. Some may not know about
the other groups or they just don't care.

--
Don Guillett
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
I'm new to these newsgroups, but have a lot of VB (compiled version)
experience, a lot of which should be applicable to Excel VBA programming
(as VB makes use of a subset of VBA underneath). Anyway, a question was
just asked in this newsgroup with the Subject "Date Conversion". Two
responders answered the question with Workbook Functions and I answered it
with a VBA response. I figured that is what was wanted since the name of
this newsgroup is "programming" and there exist another newsgroup named
"worksheet.functions".

So, my question is... should I assume posters to this "programming"
newsgroup are seeking VBA solutions, those to the "worksheet.functions"
newsgroup are seeking embeddable cell formulas and those to the "misc"
newsgroup could be either? Or is there no hard and fast rule for this?

Rick

Look what I just did in worksheet.functions

You said formula but that would eat up a lot of resources so,
right click sheet tabview codeinsert this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
Sheets("sheet3").Cells(target.row, 1).Value = Target
End Sub

--
Don Guillett
SalesAid Software

"David" wrote in message
...
I want to reference one (1) cell on sheet one (income) A4 and copy the
information (either text or an amount) on Sheet 3 (Income and lose) A4.

InsertNameDefine ='Cash Receipts'!$A$4 (this is actually the date the
cash was received.)

I am able to accomplish this task. It works fine for the one column and
row
only. The income on Sheet one - A4 - is automatically entered on to sheet
three - A4 -when I enter the necessary information in the defined column
and
row A4 on sheet one.

Now I want to be able to do the same for all the cells in Column A on
sheet
one (enter dates income was received) so they appear on column A on sheet
3.
I can't get this to copy down the column.

How do I copy this information down the column so that all the information
I
type on sheet one will appear on sheet three?

I hope this is clear?