I need your help in creating a Macro for preparing a Aging Report.
In the sample sheet I have
Raw Data sheet and in that it has to look for Close time column and if it is empty it need to copy the data in another sheet
named Aging Data (As in sample sheet).
I need the Pivot table as shown in the sample data and in that I have
added Column H & I using today () function & below code manually. Please help me to automate it.
=IF(H4<=3,"0 to 3 days",(IF(AND(H4>=4,H4<=7)," 4 to 7 Days",(IF(AND(H4>=8,H4<=15)," 8
to 15 Days",(IF(H4>15,"> 15 Days","")))))))
Note: The data is not constant and vary.
Thanks in advance for your help!!