$$Excel-Macros$$ Auto convert excel files to PDF

2010-08-31 Thread AlwaysLearing
Hello, I have a spreadsheet as shown below: Name ID Start Date Company John A 1011/1/2010 A Vicky T 1151/8/2009 A Tim H 1126/1/2009B Mike B 1137/1/2010 C What I want to do is automatically create a pdf file for each company with company name as

$$Excel-Macros$$ Combining mulitple rows into one row

2010-01-11 Thread AlwaysLearing
Hey Guys, I have a spreadsheet that has multiple rows of data for each employee with each row containing the date they worked and for how long. For example, Mr. Smith worked on 7/1/09 for 8 hrs and on 7/2/09 for 8 hrs and 7/3/09 for 8 hrs. Is there a way to combine all 3 rows as Mr. Smith worded