Excel Tips and Tricks
There is a few things that you can do to save time and effort when adding your data to BUZ, generally we find that BUZ is easy to use, but it takes a lot of time to input all the information
Creating a Fabric list from a PDF or Word Document
An easy way to copy the fabrics to Excel would be to highlight the required area and copy paste it
This is my example layout
Curtain Price:
Budget: Wave Fold Or S Fold - $ + Gst Per Meter Width Upto 3m Drop Including Track Fabric: Nettex: Bahamas, Breeze, Lucern, Newport, Vevey
Group 1: Wave Fold Or S Fold - $ + Gst Per Meter Width Upto 3m Drop Including Track Fabric: A. Nettex: Bali, Banf, Bilbao, Cannes, Catania, Highlight, Infinity, Mira, Nimbus, Oasis, Orion, Romeo, Taos B. Charles Parsons: Hargrave, Beverly Hills, Venice C. Gummerson - Astra, Hood - Horizon, Summer and Strata Group 2: Wave Fold Or S Fold - $ + Gst Per Meter Width Upto 3m Drop Including Track Fabric: A. Nettex: Altitude, Aquila, Arena, Carina, Ditti, Kyoto, Malabar, Mood, Stratus Tricolour Zermatt B. Charles Parsons: Jartin, Casa, Caracas, Vida |
|---|
Highlight and copy the required data
Paste into excel
On the Data tab, in the Data Tools group, click Text to Columns.
The following dialog box appears.
Choose Delimited and click Next.
Clear all the check boxes under Delimiters except for the Comma and Space check box.
Click Finish.
Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated.
Next you can Transpose the list, simply