EXCEL: Need help
 

I'm trying to creat a daily sales tracking sheet. Users will be able to
track their sales and then excel would register it on a different sheet. Can
anyone help?

EXCEL: Need help
 

Could you please give more information?

For example,
1) How's the layout of data like on the sheet which you "track the sales"?
2) What information do you want to "register on another sheet"?



On 1/15/05 11:27 PM, in article
, "VZWJRM"
wrote:

I'm trying to creat a daily sales tracking sheet. Users will be able to
track their sales and then excel would register it on a different sheet. Can
anyone help?

EXCEL: Need help
 

You might start out with Sheets named Salesperson1, Salesperson2.... one
for each Salesperson. You will likely want to create the first one and save
it as a Template (in the Save AS dialog, below the file name, there is a box
for file TYPE. Select "template")
Then when you open a new one it will all be laid out for you identical to
the first one.
In your Template use a layout similar to this:
Col A = Date
Col B = Salesperson's Name
Col C = Sales Amt
optional columns

Then create a Master or Summary worksheet that will gather the data for all
salespeople:
Same columns

Then Right-click on the Excel Icon which is at the far left on the top Menu
Bar (to the left of "File". Click on View Code and insert:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Dim Mast As Worksheet
Dim Dest As Range


If Not Sh.Name = "Master" Then 'adj Name as needed
If Target.Count 1 Then Exit Sub
If Not Intersect(Target, Range("C2:C65536")) Is Nothing Then 'adj
to your Sales Amt range
Set Mast = Sheets("Master")
With Mast
Set Dest = .Cells(.Rows.Count, 1).End(xlUp).Offset(1,
0)
Target.EntireRow.Copy Dest
End With
End If
End If
Set Mast = Nothing
Set Dest = Nothing
End Sub


"VZWJRM" wrote:

I'm trying to creat a daily sales tracking sheet. Users will be able to
track their sales and then excel would register it on a different sheet. Can
anyone help?

EXCEL: Need help
 

Charles,
http://www.cpearson.com/excel/newposte.htm
see Item 9.

Please don't post attachments. You can post notification to the user that
you have a sample workbook if they would like to contact you with an email
address. then send it directly to them (for example).

--
Regards,
Tom Ogilvy

"Charles Harmon" wrote in message
...
Hi,

Attached you will find something I put together. When the workbook opens
it
will display a userform with the current date. Input all info and click
the
"Log Job" button this will place the informantion on "SalesData" sheet.
You
can click the clear form to reset the text boxes. When done click the
"Exit"
this will remove the userform. To re-activte the form click on the
SalesData
picture.
I also have a button for future uses. "EndOfDay" this can be set to take
the
information on the SalesData sheet and send it to a master file.
HTH

"VZWJRM" wrote in message
...
I'm trying to creat a daily sales tracking sheet. Users will be able to
track their sales and then excel would register it on a different sheet.
Can
anyone help?

EXCEL: Need help
 

Tom,

Thanks, I'll read cperson's site so I won't make that mistake again.

Charles

"Tom Ogilvy" wrote in message
...
Charles,
http://www.cpearson.com/excel/newposte.htm
see Item 9.

Please don't post attachments. You can post notification to the user that
you have a sample workbook if they would like to contact you with an email
address. then send it directly to them (for example).

--
Regards,
Tom Ogilvy

"Charles Harmon" wrote in message
...
Hi,

Attached you will find something I put together. When the workbook opens
it
will display a userform with the current date. Input all info and click
the
"Log Job" button this will place the informantion on "SalesData" sheet.
You
can click the clear form to reset the text boxes. When done click the
"Exit"
this will remove the userform. To re-activte the form click on the
SalesData
picture.
I also have a button for future uses. "EndOfDay" this can be set to take
the
information on the SalesData sheet and send it to a master file.
HTH

"VZWJRM" wrote in message
...
I'm trying to creat a daily sales tracking sheet. Users will be able
to
track their sales and then excel would register it on a different
sheet.
Can
anyone help?

EXCEL: Need help
 

Thanks,
and it was just a heads up on common practice (and you are always free to do
what you want - this isn't a moderated group). Everyone appreciates your
willingness to share your knowledge/expertise and the quality posts and
assistance you have been providing.
Keep up the good work.

--
Regards,
Tom Ogilvy


"Charles Harmon" wrote in message
...
Tom,

Thanks, I'll read cperson's site so I won't make that mistake again.

Charles

"Tom Ogilvy" wrote in message
...
Charles,
http://www.cpearson.com/excel/newposte.htm
see Item 9.

Please don't post attachments. You can post notification to the user
that
you have a sample workbook if they would like to contact you with an
email
address. then send it directly to them (for example).

--
Regards,
Tom Ogilvy

"Charles Harmon" wrote in message
...
Hi,

Attached you will find something I put together. When the workbook
opens
it
will display a userform with the current date. Input all info and click
the
"Log Job" button this will place the informantion on "SalesData" sheet.
You
can click the clear form to reset the text boxes. When done click the
"Exit"
this will remove the userform. To re-activte the form click on the
SalesData
picture.
I also have a button for future uses. "EndOfDay" this can be set to
take
the
information on the SalesData sheet and send it to a master file.
HTH

"VZWJRM" wrote in message
...
I'm trying to creat a daily sales tracking sheet. Users will be able
to
track their sales and then excel would register it on a different
sheet.
Can
anyone help?

EXCEL: Need help
 

Thanks for the compliment. I've learned a great deal from this group and the
forum. Thanks to you and the rest of the "Team".

Charles
"Tom Ogilvy" wrote in message
...
Thanks,
and it was just a heads up on common practice (and you are always free to
do
what you want - this isn't a moderated group). Everyone appreciates your
willingness to share your knowledge/expertise and the quality posts and
assistance you have been providing.
Keep up the good work.

--
Regards,
Tom Ogilvy


"Charles Harmon" wrote in message
...
Tom,

Thanks, I'll read cperson's site so I won't make that mistake again.

Charles

"Tom Ogilvy" wrote in message
...
Charles,
http://www.cpearson.com/excel/newposte.htm
see Item 9.

Please don't post attachments. You can post notification to the user
that
you have a sample workbook if they would like to contact you with an
email
address. then send it directly to them (for example).

--
Regards,
Tom Ogilvy

"Charles Harmon" wrote in message
...
Hi,

Attached you will find something I put together. When the workbook
opens
it
will display a userform with the current date. Input all info and
click
the
"Log Job" button this will place the informantion on "SalesData"
sheet.
You
can click the clear form to reset the text boxes. When done click the
"Exit"
this will remove the userform. To re-activte the form click on the
SalesData
picture.
I also have a button for future uses. "EndOfDay" this can be set to
take
the
information on the SalesData sheet and send it to a master file.
HTH

"VZWJRM" wrote in message
...
I'm trying to creat a daily sales tracking sheet. Users will be
able
to
track their sales and then excel would register it on a different
sheet.
Can
anyone help?