I have a simple macro set up to copy information from one worksheet to another. The way it run's now, it paste's the information into the cell that I clicked on while recording the macro.
The info I am coping is three numbers, first being the sheet number from which the info came, second being the item piece number, and the third being the quantity (each in their own cell). I would like this information to be copied into a seperate worksheet that has rows listed 1 thru 100. If the first number (the sheet number) is 1, I want it to paste into the row labeled 1, if the first number is 2, I want it to paste into the row labeled 2, and so on.
How would I go about doing this?
This is the maco I currently have:
Range("DD7:DF7").Select
Selection.Copy
Sheets("JOIST INPUT SHEET").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("SS").Select
Application.CutCopyMode = False
Any help would be appreciated.
dlb
Bookmarks