1
0
In retrospect, this is an issue of data-collection, but I want to see if there is an easy way to do it without doing each file.
I have about 350 separate Excel workbooks. Each workbook has a bit of information pertaining to one individual.
What I want to do is create a simply spreadsheet of everyone with the necessary data, so it is then usable.
To give you an idea. A1 lists "Name" with B1 having the person's name. A2 has "Last 4 SSN" and B2 has the 4 digits.
Then A3 has the word "Year", then A4 "2014 est", A5 - "2013", A6 - "2012, etc, to 2009.
Then in Row 3 from B to N there are different pieces of information.
What I want to do, if possible, is have a master spreadsheet with columns of name, last 4 ssn, and then years for each of the pieces of data. ie. 2013-Interest
Is this even possible?I hope this makes sense.
What have you researched or tried so far? – CharlieRB – 2014-07-31T19:04:47.290
I would think it is possible, as manually doing this would take a long time, but you could do it. Have you tried anything to date so far? – Mr. Hargrove – 2014-07-31T19:05:04.483
1Are you looking for a one-time consolidation, or do you want to continue updating the individual sheets and have those updates pushed to (or pulled by) the master? – Iszi – 2014-07-31T19:14:04.280
Take a look about consolidating data from multiple worksheets; this could give you a good understanding. http://office.microsoft.com/en-us/excel-help/consolidate-data-from-multiple-worksheets-in-a-single-worksheet-HP010342300.aspx?CTT=1
– Mr. Hargrove – 2014-07-31T19:35:16.323