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:"
6 freelancers are bidding on average $128 for this job
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
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