I have a long list of fabrics for a price book but would like to split these into equal columns and still in alphabetical order that will fit on to an a4 page. I usually do this by playing about with it for ages to make them fit and make them all the same but I am always adding in extra fabrics or taking them out so could do with this process automating.
Would really appreciate any help
Thanks
Hi,
Fitting to an A4 page can be set up in the Page Set Up area of the Ribbon. We don't know the text width of your fabrics so can't comment in how many columns across the page will look reasonable. You'll need to decide and use the Fit To 1 Page wide with the Fit to Page Tall blank, and change the number of columns in the macro below (currently set to 5). It assumes your list is in column A starting at A1.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Say we have a long list in column A and we want to display the same items in the same order in columns B & C. In B1 enter:
=IF(ROUND(COUNTA(A:A)/2,0)>=ROW($A1),INDEX(A:A,ROW($A1),),"") and copy down
In C1 enter:
=IF(ROW($A1)+ROUND(COUNTA(A:A)/2,0)>COUNTA(A:A),"",INDEX(A:A,ROUND(COUNTA(A:A)/2,0)+ROW($A1),)) and copy down
This approach could be extended to multiple columns if desired.
Last edited by Jakobshavn; 10-20-2012 at 10:07 AM.
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks