Excel help required

Go to: Forums > Technology: Applications and Software

There is only one posting to this topic on our Member website and this page runs 7 days behind our Member website. For the full topic click to sign up to OUTeverywhere.

Topic started by Ananga Of Glastonbury (ananga)

MAJOR PROFILE OVERHAUL TO BE COMPLETED SUMMER SOLTICE (20 June, 23.59) creative polymath, ex-urban utopian, musical, love languages, mathematical dialogues looking for partners in artcrime.

A topic from Technology: Applications and Software

anangaFri 18/01/08 09:11

I am exporting the products from one EPOS till system to a new one and need the help of an Excel sorcerer/ess!

I have a spreadsheet in xls format with a header and each subsequent row representing a product item each of which has a different supplier given by a integer supplier reference number (in row H!)

What I need to do is create an individual CSV file for each supplier. We have about 320 suppliers so I would like to automate the process a bit, maybe with a macro.

If I were doing it by hand I would do the following:
1:select data -> filter -> autofilter
2:choose the supplier I want (filtering by supplier number)
3:select the rows
4:open up a new spreadsheet
5:paste the data (including the headings)
6:save each file as CSV (clicking about 3 dialog boxes on the way) using the supplier number(column H) as the file name.

We are using Excel 2000 if that makes any difference.

nb. the supplier numbers are not contiguous ie. there are gaps!

crosses fingers in anticipation!

Ananga

Enjoy chatting with our members

Imagine joining a social network of people from all around the country and see how you'll feel a year from today. You're increasing your circle of friends. You're doing more of the stuff you enjoy. You're having a great time meeting new people in your area. You're seeing all the benefits of becoming a member of OUTeverywhere. It still feels great making new friends and every day you're hearing more and more about the stuff that everyone's doing. You're joining in. Now, that was easy, wasn't it?

We make meeting people easy. Click to sign up to OUTeverywhere and get up and do something different!

PLEASE NOTE: Events are listed on this website on behalf of organisers in accordance with the Terms of Membership of OUTeverywhere and only if they have chosen broad publicity when adding their event to the Member Events calendar. As such, events are not necessarily affiliated to or endorsed by OUTeverywhere and may not be organised by the person who has listed the event: the person listing this event may simply be attending an event organised by another person or organisation and may wish to meet other people sharing their interest in the event. The mention or appearance of any person or organisation featured on these pages is not to be taken as any indication of sexual, social or political orientation of such persons or organisations. We cannot guarantee that the information is accurate and recommend that you always seek to contact the organiser directly to confirm full details of any event. Under no circumstances will we be responsible for any loss or damage resulting from reliance on, use or misuse of, the information on this website.

Our Vision | Our Team | Privacy Policy | Identity Theft Protection | Terms of Membership

Chat and Meet People

Enter one or two words to tell us something you enjoy:

Or enter a postcode or the name of a place:

Latest Shout OUT

Broadcast to the gay world with our public Shout OUTs service! Post on our member website or from your mobile phone and raise your profile.

Chad R (badlands) from the Leicester area in United Kingdom shouts OUT: "Why are all the hot guys taken?"

Events Calendar

< July 2008 >
S	M	T	W	T	F	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

This Topic's Tags

Members tag topics with key words to help us find similar topics.

Discover GMEET

Add all your web profiles to the new GMEET.com website profiles directory service. Supports Facebook, YouTube, MySpace, Bebo, LinkedIn and dozens more. For social and business networking, web personals and online dating.