Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to import list into Excel to make pricelist

Status
Not open for further replies.

sevenone

Technical User
Nov 6, 2002
10
GB
I hope somebody can help me with this, I've now got a headache trying to find a solution.

I'm trying to create a pricelist from a csv file. I want to automate it so that I can import the csv file and have it formatted into multiple columns per page. I want each page to have a custom header and footer with logo. When the list reaches the bottom of the page it should continue to the next set of columns until it reaches the page width and then onto the next page.

I have 4 columns in the csv file, Category, Code, Item and Price. I want to display only 3 columns with the first column being used instead to group the lists into categories.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top