Edgar Saravia
New Member
- Joined
- Apr 15, 2022
- Messages
- 3
- Office Version
- 365
Hello.
I have an Excel power query for a daily list of payments that we received. Every day I run a payment report from the bank and the query populates the list of payments by date. This query populates columns A - F, I have manually added an additional column called Status which is how I keep track of the status of each payment. The problem is that after I am done with the current day and I save my work, the word "PAID" shifts for this example from cell G3 to G6 after I click to refresh the query with new data. I other words each time I click refresh the last cell in column G shifts to the last cell in the new date. can someone help figure out how to avoid this?
I have an Excel power query for a daily list of payments that we received. Every day I run a payment report from the bank and the query populates the list of payments by date. This query populates columns A - F, I have manually added an additional column called Status which is how I keep track of the status of each payment. The problem is that after I am done with the current day and I save my work, the word "PAID" shifts for this example from cell G3 to G6 after I click to refresh the query with new data. I other words each time I click refresh the last cell in column G shifts to the last cell in the new date. can someone help figure out how to avoid this?
