Have a problem writing a macro that works

[Arnold Smailes]

Hi
I am new at using VBA macros and having problems understanding some of the methods

I am hoping that with the collective expertise of the forum I can not only solve my problem but learn more about VBA and increase my circle of friends

Have a great day

Arnold Smailes

(Arnie)

I am working on a set of spare part control cards (68 individual cards) which have inputs in column “B” for the Quantity Sold and column “C” for the date sold. The quantity and dates are to be picked up from cells “P1” for the Quantity and “Q1” for the date.

The stock card to be selected for the input comes from cell “R7” This cell gives the item number (ie. The card number to have an entry made)

The existing macro below selects the right stock card numbered in range “R7” and places the cursor on the first entry row in column “B”

I now want to enter the quantity sold and the date in the next empty cell down.
HOWEVER no matter what I try I cannot get the cursor to move beyond Worksheets("Nail Cards").Range("C2:C4012").Find(Range("R7").Value).Offset(8, -1).Select.

The following last part of the macro is what I thought would input the data into the appropriate cells but does not appear to activate

Lrow = Worksheets("Nail Cards").Range("B" & Rows.Count).End(xlUp).Row + 1
Worksheets("Nail Cards").Range("B" & Lrow & ":C" & Lrow) = Worksheets("Nail Cards").Range("P1:Q1").Value

End Sub

My apologies but I am new at VBA macros and will no doubt be overlooking something obvious.

[arlu1201]

Hello Arnold Smailes,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[Kaper]

Hi Arnold,

Please read the description of this sub-forum - this one is solely to introduce yourself.

So here I'd say: welcome to the forum. And that's it.

With your merit question, please go to appropriate sub-forum. Look what sub-forums we have: http://www.excelforum.com/microsoft-...el-help-forum/ and post a new thread in one of them (the most appropriate one).

Probably the macro sub-forum will be most suitable, but let me say 2 more sentences:
1) The attached file is xlsx - so for sure there are no macros inside
2) please observe forum rules about using CODE tags while posting code the rules are here: https://www.excelforum.com/forum-rul...rum-rules.html