Hi everyone, My name's Corey, from Toronto Canada, and I am a material planner for a manufacturing facility. I have been using Excel for about 3 years, and also use Crystal Reports. I can write good code in Crystal, but I haven't written anything in Excel yet - I'm not familiar with the syntax. I need some help!
I haven't been able to google up what I'm looking for, so I thought this would be the best place to ask.
I'm going to have a lot of excel files that will be just lists with two fields - a part number and a description. From these lists I wish to make cards to give to production. I basically just wish to have groups of part number above their corresponding descriptions spaced equally about a printable page. Maybe I get 4 or 6 cards per page spaced evenly.
I just need a good link or some advice on using macros and formatting data. I would need to size columns, bold text, move records around. Also, if anyone knows the loop structure for reading records and recognizing EOF, or a link to syntax, I'd appreciate it!
Well, sorry for the general newbie questions - I'm not inept, I just don't know where to look. And googling up 'excel' gets a million hits!
Thanks in advance!
Corey.
Bookmarks