bringing data from one sheet at the end of a prticular row in anot
i have three rows in a sheet s2
they are Total Planned Hours Total Available Hours Difference now i want to bring in the three columns after each name which is sorted and merged(if there are more tahn one entry for a name). I want this to happen dynamically// how do i proceed to bring in the three rows every time a macro is run and at the end of every name. for eg, i now have colA colB............... row1 X sit row2 stand row3 Total Planned Hours row4 Total Available Hours row5 Difference row6 Y come row7 Total Planned Hours row8 Total Available Hours row9 Difference here since the name X gets over at row 2(actualy before inserting 3 rows after that) i shud insert 3 rows from row 3 and for name Y i should insert from 7. But the thing is that i wont know manually where the sit and stand ends. Th emacro should find out. Thanks for any help in advance |
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com