excel for mac VBA copy and create new xlsx

I have a spreadsheet that comes out every day that has new data on it.

There is some header data in the first 4 rows and spanning about 30 columns, that I want repeated on each newly created spreadsheet. The bottom line is a sum line for the numbers, which also must be repeated.

Columns A and B are mostly static and do not change day to day. Column A is who an account belongs to and Column B is the name of the account. Columns C and following report unique data for that account (how many tests yesterday, how many this month, how many this quarter, etc) One person can have several accounts, but one account is only tied to one person.

Every week I send every Person their own spreadsheet. Which means I have to break out the data with a whole bunch of copying and pasting into new spreadsheets, naming each spreadsheet by a set date and then their name. Example: "2013-11-18 - Person [url removed, login to view]”

I would like a vba program to generate each person’s excel spreadsheet (with proper heading rows and columns) and place it into the same folder the existing folder currently resides in.

I'd also like it to format the each spreadsheet to print similar to the attached file. (one or 2 printed pages per person)

Each week I create a new folder based on the date: So the attached spreadsheet would go in the “2013-11-12” Folder.

I then email out each of the spreadsheets using Apple Mail.

Included is a sample file.

I'm using Excel for Mac 2011 version 14.2.5

Habilidades: Excel, Mac OS, Visual Basic para Apps

Veja mais: m format in excel, vba for mac, vba day of week, vba create folder, print vba, excel 2013 vba, create folder vba, xlsx, vba mac, how to mac, excel for mac, attached mac, vba excel copy, excel 2013 version, excel 2011 vba, copy excel spreadsheet email, send email using excel, excel vba report, excel unique, mac excel spreadsheet, file mac format, excel vba print, vba excel 2011, excel vba spreadsheet, vba excel mac

Acerca do Empregador:
( 5 comentários ) choctaw, United States

ID do Projeto: #5149231

Concedido a:


Hi, I can help you with this macro as I have done several similar projects recently. Am available now to start on it if you're ready ---------------------------------------------------------------------------------- Mais

$111 USD em 0 dias
(17 Comentários)

3 freelancers are bidding on average $119 for this job


Hi, I have little confusion that I guess we can clarify over chat. Wish to hear from you. Best regards, Nishith Gupta

$155 USD in 3 dias
(0 Comentários)

I am a software engineer and i am professional in my field so that i can do this job perfectly. My skills are that, Microsoft office, adobe Photoshop,Link Building, SEO, website design, logo design, software and hardwa Mais

$90 USD em 1 dia
(0 Comentários)