3 projects in one ( XL work and data typing)

Job ID: 35603691

Budget: $10 – $30 USD

This project is 3 in one.


Job 1
Tallying file

I need someone to show me how to create a spreadsheet that allows me to have a
list that takes the data from the blue cells and create the data as seen in the yellow
cells. You will not know the data in the Title_2 column beforehand and it should still work.

---------------------------------------------------------------------------------------------------------

Job 2
Comparison file

In this XL file, there are 3 tabs, 1, 2, and combined.
In tab1, I have highlighted the cells blue.
In tab2, I have highlighted the cells yellow.

In the combined tab, I want to reference the data from tabs 1 and 2 in it. I also want the
cells to retain the color so that when I manipulate the data I can see by color where
it came from. Currently, if I do a cell reference I get the data but not the color.

---------------------------------------------------------------------------------------------------------

Job3
Presentation_1

If you open the Presentation_1 pdf file you will see 22 pages. On each page is a list of pdf files.
I need someone to type the titles of each of those pdf files into a txt document.
For example, on page 1 you would type allowable_breaks_and_lunches, daily standards, etc..
Related categories: Visual Basic Data Processing Data Entry Excel PDF