Ministers Directory - Data Manipulation

Combine data across Excel sheets in preparation for import into Indesign for print publication. Here’s a description of the files attached.

[url removed, login to view] - Portion of final InDesign page.

[url removed, login to view] - InDesign markup showing data and formatting codes

Dir. of Ministers (Person Info).xls - Base data file. Columns used and punctuation needed: H, F G. (L); P, S, T U; Office: X; Y; Z;

Dir. of Ministers (Employment).xls - Data to show where the minister previously served. To join with above, use CORE Yearbook ID. Multiple rows for each needs to be combined in order beginning with most recent—using date started, column AD. Columns used and punctuation needed: AG, AH, AI, AD; (Note: AD should print the year only)

CORRECTION (to include full address, home phone, and "Fax:")
Dir. of Ministers (Person Info).xls - Base data file. Columns used and punctuation needed: H, F G. (L); P, Q, R, S, T U; Home: W; Office: X; Fax: Y; Z;

In all cases, if a cell is blank, return nothing. For example, if no home phone is given, don't display "Home:"

Taidot: Excel, Visual Basic

Näytä lisää: visual basic directory info, png to txt, png employment, employment png, employment office, combine excel, AH, excel png, excel combine data rows, xls visual basic, txt file import excel, excel import txt, data base basic, year date column, excel combine, combine rows excel, xls excel data, png excel, print xls, excel manipulation, data preparation, sheets import, excel yearbook, indesign yearbook, xls data

Tietoa työnantajasta:
( 42 arvostelua ) Grand Rapids, United States

Projektin tunnus: #7075290

Myönnetty käyttäjälle:


A proposal has not yet been provided

50 $ USD 3 päivässä
(3 arvostelua)

6 freelanceria on tarjonnut keskimäärin 128 $ tähän työhön


Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

111 $ USD 2 päivässä
(26 arvostelua)

Hi I would love to work on this project. I have 8 years of experience in Microsoft Excel. Please contact with further details if interested. Regards Raghav Bansal

158 $ USD 3 päivässä
(27 arvostelua)

Hi there. I am an expert using and managing Excel files and can guarantee you an excellent job. I have checked the files and I have the knowledge to combine them together. Please contact me to discuss further details o Lisää

147 $ USD 3 päivässä
(8 arvostelua)

A proposal has not yet been provided

200 $ USD 3 päivässä
(0 arvostelua)

I have Experience doing things like this. This would be my first Freelancer project, but i'm confident in my abilities to deliver what you need.

100 $ USD 3 päivässä
(0 arvostelua)