Form puts data in wrong cells

[dldurbin]

I have created a spreadsheet for my church that tracks all the contributions that are coming in. I recently created a form for them to input the data into to make it easier, but the data is not going to the correct cells. The reason for this is that the form is looking for the 1st empty Row to input the data into & the Row has formulas that are not seen working in the background. What can I do to get the data to go to the 1st empty cell in a particular column or at least not recognize the formula in the Row until the conditions are met?
Any help on this will be greatly appreciated.

[PFDave]

Do you have a sample workbook you can upload as this will make a resolution much easier.

It may be that we can add the formula in after, or not.

[dldurbin]

I am attaching a copy that I have entered a couple of entries in both the Contribution & Expense sections. You can see that the upper lines the data was input correctly. Once I added the Autosum for Totals in the expense sheet it started putting the data down lower on the sheet & in the contributions sheet I have not found the data that I input into the sheet yet.

[Norie]

Sorry but there's no attachment.

Are you having trouble uploading?

[dldurbin]

Apparently the file was too big. Attempting to attach again.

[dldurbin]

2nd attempt to attach. File was too big the 1st time.

[Logit]

I was able to clear up the issue by highlighting all the empty rows and clicking DELETE. The CONTRIBUTIONS sheet was writing new entries all the way down to the bottom (somewhere around the 1millionth row).

By highlighting all the rows below the first few top ones that had entries and clicking DELETE, it in essence reset the spreadsheet. Try it on your side and see if it works.

Attachment

[JohnTopley]

I am not very knowledgeable about tables but using your "irow" statement in VBA placed the data at the bottom of the file.

I changed the worksheets back to "range" format and used the following for irow

irow=.cells(rows.count,"A").end(xlup).row

in the "with ws" loop where you add the data.

This added the data in the next (correct) row.

Hopefully a VBA guru will solve the issue of determining the "lastrow" using a table structure

Update: Logit appears to have resolved the issue!!

[dldurbin]

I see the changes that you have made but by doing so the total column no longer works & would have to be manually pulled down for every transaction. This is fine if I was the only person working with this sheet, but I have people who do not know much about spreadsheets or such that would not be able to manually make adjustments to get the sheet to total.
Thanks for your help,

[JohnTopley]

As per my previous post: Logit solved the problem.