VISHAL120
06-18-2011, 02:25 AM
Hi to all,
I have a planning data file on which I plan the work load on the loading Sheet and I used VBa to copy and paste the data on the Fleche Cell sheet for display which is then given to concern person to follow and execute the work load. The only problem I faced with this is when I plan the work .load on more than 265 rows the vba cannot copy paste its because of the limitation on the number of column available.
I needed help on that if same can be copy and paste through VBA as I have illustrated on the NEED_TO_DISPLAY_AS_SUCH sheet.
This will make things more easy as I will copy and paste after each row which is blank instead of using another column. Together it shall has the arrow which starts with the all the info data like order, opr, cap and end when the qty is finish.
I have attached a sample file for better understanding and also given an example of data for one cell on the NEED_TO_DISPLAY_AS_SUCH sheet.
Many thanks in advance for the guide lines that I will be having.
I have a planning data file on which I plan the work load on the loading Sheet and I used VBa to copy and paste the data on the Fleche Cell sheet for display which is then given to concern person to follow and execute the work load. The only problem I faced with this is when I plan the work .load on more than 265 rows the vba cannot copy paste its because of the limitation on the number of column available.
I needed help on that if same can be copy and paste through VBA as I have illustrated on the NEED_TO_DISPLAY_AS_SUCH sheet.
This will make things more easy as I will copy and paste after each row which is blank instead of using another column. Together it shall has the arrow which starts with the all the info data like order, opr, cap and end when the qty is finish.
I have attached a sample file for better understanding and also given an example of data for one cell on the NEED_TO_DISPLAY_AS_SUCH sheet.
Many thanks in advance for the guide lines that I will be having.