Dear all,
I am trying to fill up a range with the range row-1 where one or several cells are empty.
When running a macro in Staff Listing, it updates the Report sheet with new employees details range(A:J). The range(K:T) pull datas through formula. I need to copy range(K:T) for each new rows containing information in range(A:A)
The file attached gives a better idea of what I am after.
Thanks.
Use this code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Arlette,
It works well but I would like to modify it as the formula uses indirect and The reference cell needs to be incremented accordingly.
Cheers
If you need the references to increment, you will need to change the absolute referencing to relative referencing in your formula. For e.g. you have month($W$22) as a small part of your formula. Change it to $W22.
After changing the references, i realised that the references still dont get incremented with the earlier code. Use this instead:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks