Excel Not Recognizing New Row of Copied Data from VBA as Next Formatted Table Row

[bjankowski]

I have a very elaborate spreadsheet that has multiple tabs representing different customer account delinquency categories. When a customer does something that moves them from one category to another, the user can change the Current DLQ Category via dropdown, and click a button that will move that row of customer data from the current tab to the applicable new tab. The tabs that are labeled DCAT, P30, 30, 60, 90, 120, 150, 180 and BK are all in formatted tables, and the VBA is supposed to copy the data into the applicable table, which normally would recognize the data as the next formatted table row, but instead it's copying and pasting the data, but it's not formatting like the rest of the table (the DLQ category is not centered, the account number isn't reading like the others, and the conditional formatting isn't copying down. I just need the copied data to be recognized and formatted along with the table data in the rows above.
I've attached the Excel file itself, as well as a snapshot Word document to show what it's doing.

Here's the actual VBA code that's resulting in the data being copied from P30 tab to 30 tab:

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[bjankowski]

Hi Alan, I apologize, I am still very new to the forum! Do I need to repost the question?

[alansidman]

No reposting. Continue here as others will chime in.