Chirag R Raval
Member
Dear all experts,
After long, need your little help....request to shorten my manual effort on splitting & printing .
Daily , often ,there are need to update & print long stock list, if data is 2 column like quality no & stock in Mtrs. (rows always dynamic, not fix how many rows) split/distribute total rows /4 & put 2nd part of 2 columns next to 1st, put 3rd part next to 2nd, put 4th part next to 3rd left to right (2 column group) so in 1 A4 size page contain 4 part of 2 columns group (total 8 columns in 2 column group) .... , count of pages is based on how many rows you have. So salesman tick mark on necessary items on printed list for take order based on proper stock item.
If data have 3 column wide, then require 3 parts of 3 columns group, ( total 9 columns ) if data is 4 columns wide then require 2 part of 4 column group...(total 8 columns in 1 page in 2 group) of if data is 5 column wide then not need to split..5 columns, not need to print side by side vertically in 2 part , (total 10 columns on 1 page? No.....please no) because losing readability & uncomfortable for tick mark..so if 5 column data , there are no need to do splitting, no macro require, & not need to generate this thread
Unfortunately, each sales person' s need is different, base on database..that how many columns they need base on different product criteria...(some one want qualy no, units with rate, some one with rate & with unit length...etc..)
In other words if data have heading, , 2 columns, 100 rows, then first part become 25 rows, next 26 to 50 rows data(of course 2 columns) , shift to 3rd column , next 51 to 75 row"s data ,shift on 5th column , next 76 to 100 rows shift on 7th column so rows distribute evenly , & I can print 2 columns group's data in 4 part on 1 paper...( obviously if 1350 lines, then number of pages increase) ..
Heading must be carry on on each grouped data.
Daily, multi time, updated stock need to print & hand over to diffrent salespersons..as per their requirements, manually its take hard effort & time, how can be done with macro?
Hope I can describe well my situation...please help...
Regards,
Chirag Raval
After long, need your little help....request to shorten my manual effort on splitting & printing .
Daily , often ,there are need to update & print long stock list, if data is 2 column like quality no & stock in Mtrs. (rows always dynamic, not fix how many rows) split/distribute total rows /4 & put 2nd part of 2 columns next to 1st, put 3rd part next to 2nd, put 4th part next to 3rd left to right (2 column group) so in 1 A4 size page contain 4 part of 2 columns group (total 8 columns in 2 column group) .... , count of pages is based on how many rows you have. So salesman tick mark on necessary items on printed list for take order based on proper stock item.
If data have 3 column wide, then require 3 parts of 3 columns group, ( total 9 columns ) if data is 4 columns wide then require 2 part of 4 column group...(total 8 columns in 1 page in 2 group) of if data is 5 column wide then not need to split..5 columns, not need to print side by side vertically in 2 part , (total 10 columns on 1 page? No.....please no) because losing readability & uncomfortable for tick mark..so if 5 column data , there are no need to do splitting, no macro require, & not need to generate this thread
Unfortunately, each sales person' s need is different, base on database..that how many columns they need base on different product criteria...(some one want qualy no, units with rate, some one with rate & with unit length...etc..)
In other words if data have heading, , 2 columns, 100 rows, then first part become 25 rows, next 26 to 50 rows data(of course 2 columns) , shift to 3rd column , next 51 to 75 row"s data ,shift on 5th column , next 76 to 100 rows shift on 7th column so rows distribute evenly , & I can print 2 columns group's data in 4 part on 1 paper...( obviously if 1350 lines, then number of pages increase) ..
Heading must be carry on on each grouped data.
Daily, multi time, updated stock need to print & hand over to diffrent salespersons..as per their requirements, manually its take hard effort & time, how can be done with macro?
Hope I can describe well my situation...please help...
Regards,
Chirag Raval
Last edited: