Input Data on one sheet and populate another sheet .. input data is not being captured

Hi. I am trying to input data on one worksheet and populate another worksheet. Then I want to get back to the original sheet and clear the input cells to enable the user to enter more data. Well, my first attempt is not working and I'm sort of stumped.

Right now I am not pulling the data from the input cells properly. Can you help me with this "project" of mine?

Here is the macro (ProcessEntry) that is executed by a command button on the input sheet. It is followed by a called subroutine (FillRow) to populate the data in the subsequent worksheet:

Note: The target sheet has a "marker" row with "xxx" in the first column. This indicates the "last row" and the next available row would be 1 row above that row. If there is no available row, I am inserting a row.

Note: All other called functions to populate local variables to hold particular column and row numbers are executing properly. I have traced the logic to the call to FillRow and see that the input data is not being passed in the call. The values are not being "pulled" properly prior to the call.

Please Login or Register  to view this content.

Hi !

Follow the process via the step by step mode hitting F8 key then you should find out where the issue is …

Marc,
Thank you for your reply.
I'll get back to the forum after I do that.
Sue

Thank you. This is no longer a problem. I'm trying to find out how to mark it as SOLVED.