Dear Forum Members,
Please can someone help me with the following;
I Sheet2 I have invoices data (containing formulas) starting from
B2:K7000
Every month it keeps on increasing downward.
B1:K1 are column headings
Column K is the payment date
Currently, I copy the data of Sheet2 manually in Sheet7 and then delete the rows that have been paid in column K, to get an upto date list of the pending invoices.
I am pasting the data using paste special to remove the formulas.
Please can someone help me to automate this task?
Thanks in advance.
Please can someone help me with the following;
I Sheet2 I have invoices data (containing formulas) starting from
B2:K7000
Every month it keeps on increasing downward.
B1:K1 are column headings
Column K is the payment date
Currently, I copy the data of Sheet2 manually in Sheet7 and then delete the rows that have been paid in column K, to get an upto date list of the pending invoices.
I am pasting the data using paste special to remove the formulas.
Please can someone help me to automate this task?
Thanks in advance.