Attached is an example of the worksheet I need to update.
Columns A&B need to come from the database to ensure all the specifications are being addressed and Columns C thru Z are manually entered.
I have the query that refreshes Columns A & B, keeping the sort and I have the vba (not in the example) to insert an empty row on the change of Category.
What I don't have is when A&B are refreshed, how do I keep the manually entered column data with the appropriate Column A&B information?
Also, is it possible to enter the blank rows and populate the Category name (as in the example?)
Thanks for your help....