Hello friends, hope all is well!
Please help me, I want and based on the numbers on column F, want to copy the ranges from A:E to another sheet.
i.e. if the cell in column F equals 4, then the range is copied 4 times and placed on top of eachother.
The sheet ‘desired results’ will show what is needed.
Thank you very much in advance!
You mean column GI want and based on the numbers on column F
You mean from A:F...want to copy the ranges from A:E to another sheet.
Please Login or Register to view this content.
Last edited by Special-K; 01-24-2018 at 06:58 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In the attached file, I have put zero in K4 (important) and this formula in K5 of the MANPOWER sheet:
=IF(G5="","-",G5+K4)
This can then be copied down as far as you like. This gives a cumulative count of the number of records that you need.
Then I have used this formula in cell A2 of the Desired sheet:
=IF(ROWS($1:1)>MAX(MANPOWER!$K:$K),"",IFERROR(INDEX(MANPOWER!$A:$G,MATCH(ROWS($1:1)-1,MANPOWER!$K:$K)+1,MATCH(A$1,MANPOWER!$A$4:$G$4,0)),""))
which can be copied across and down as required. Note that I have corrected the spelling in cell F1. You can delete columns H to O if you are happy that the formulae produce the same results.
Hope this helps.
Pete
Please Login or Register to view this content.
Last edited by bakerman2; 01-24-2018 at 07:08 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I salute and am grateful to you all, great effort!
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks