I need help with a macro. I am showing the sample sheets below. The
Macro needs to go to SHEET 2 and copy the amounts and paste into SHEET
1. Now into more detail. The info in SHEET 2 might contain some hidden
rows which should be omitted. It should go through all the visible rows
(besides the first one) and display an input box for each row. The
input box should display the "amount" and "Description" column info for
the row (needs to be done one by one for each visible row). The input
box would be prompting me for input. The input decides into which ROW
in SHEET 1 the AMOUNT info (not the description) is pasted. The macro
should paste automatically into the column in SHEET 1 based on the
"Dacct" info from SHEET 2. The user only picks the row and the macro
picks the column based on matching the "Dacct" numbers in both sheets.

Let's make an example based on the first row (after header) . I need
the macro to paste 500.5 from SHEET 2 into "Jan" row and "15000" column
in SHEET 1.
An input box would pop up showing me : "Amount: 500.5 Description:
good" . It would be prompting me: "Please choose date: " The
input would decide into which row in SHEET 1 the 500.5 is pasted. The
macro would then decide based on the "Dacct" value in that row in SHEET
2 which column in SHEET 1 to pick.
The input answer for the prompt would be 1-12 for the rows "Jan-Dec".
"P" would be the input for the "Previous Year" row.

I do not even know where to begin... Really hope somebody can help me
on this one. I am not a programmer so anything can help.



SHEET 1:


Previous Year

DAcct 15000 16000 17000

Jan 500.5
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec


SHEET 2:

Prod# Asset# Amount Dacct Type Description
F1550 B55 500.5 15000 Lunch good
F1560 B55 600.3 15000 Lunch bad
F1570 B55 800 15000 Lunch not so bad
F1580 B55 98 15000 Lunch pretty good
F1660 B55 789 16000 Auto pretty good
F1670 B55 4564 16000 Auto cool
F1690 B55 785 17000 Loca nasty
F1700 B55 7227 17000 Loca terrific