Hi
am facing an issue which need an expert to solve, I have this workbook which contains two sheets (Registration & Refunds)
now in sheet 1 (Registration) I keep register each new card dispute I received & there is a flag column.
If the flag column has the value "R" then I want selective cells in same row to be transferred to sheet 2 (Refunds)
The real challenge is, Registration sheet will keep increase in the rows so if for example row number 2 and row number 7 are flagged with "R" the challenge is to make them appear in Refunds sheet in sequent rows 1 & 2 without empty rows in between. (Below each other)
Sheet 1 (Registration):
if column K has the value "R" then transfer the value in cells (Account, Amount, description 1 & 2) to sheet 2 (Refunds)
Sheet 1.jpg
Sheet 2 (Refunds):
The requested cells are transferred but in same row number of sheet 1, the challenge is instead of the values be in row 11 in Refunds sheet to be in row 3 direct under the first row
sheet 2.jpg
and her I attache a sample excel with comments inside
Bookmarks