VBA Help with Data inserts

[JayB0730]

Hello,

Here's what I'm trying to do:

- WHAT I NEED TO DO: From "Transaction Codes" sheet take each "X" transactions codes (X= number of total codes), listed in the first column (not all rows have a transaction code) and enter them on "Checkbook" tab and add additional data

- HOW I WANT TO DO IT: I already have a macro that automatically enters a new row--AddRow(). I would want the macro to call "AddRow()" which already puts me in the first active cell and do the following:

First Cell - Enter today's date
Third Cell - Enter Transaction Code

And I want this to repeat until all transaction codes are entered.
TIA!

Jay

 

[JayB0730]

Just wondering if anyone could help with this?

 

[mumps]

Can you post a screen shots of the 2 sheets? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.