Simple copy/paste macro sheet to sheet [Closed]

Report
Posts
1
Registration date
Wednesday November 5, 2014
Status
Member
Last seen
November 5, 2014
-
Hello,

I am trying to use a receipt template in excel to print individual receipts. Once all data is entered, I will make single receipt printout of template. On sheet 2, I have a database set up to record the individual fields as I print the receipt. This is to be used as a list of all printed receipts thus entering the data in the next available row.

I've a elementary working knowledge of excel and cannot even begin to understand macros. Ive browsed the web and tried a few that I've found but none work. Would someone help me please? While I can get into Visual Basic and navigate, I can't debug the macros I've tried and I CAN NOT write them.

Thank you in advance!!

Sample:

Cell B6 sheet 1 = date copy to column b (starting at b4) sheet 2

cell b7 sheet 1 = name copy to column c (starting at c4) sheet 2

and so on for cells b8, b9, e6, e7, and e8 sheet 1 to columns d, e, f, and g

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!