• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy Monthly data from one spreadsheet to another

S

spk1009

New Member
I have two spreadsheets Template.xls (where data needs to be inputted each month) and second one Monthly-DataInput.xls (monthly raw data file).


Template file has 4 tabs, By ID, By clien, TCM-1, TCM-2

Monthly-DataInput has 2 tabs TCM-1 and TCM-2


I need to easily be able to update the template tabs with data from the raw data file; TCM-1 tab from data file to template TCM-1 tab and TCM-2 tab from data file to template TCM-2 tab. BUT columns E and F in the Template file comes from ONE column in the Monthly-DataInput file column E. Column E from datainput needs to be parsed (first 3 nubmers before "-") gets inputted into colE in the template and the numbers after the "-" (in column E datainput) goes to colF in template file.


Thank you all....


http://speedy.sh/2axZa/TCM-Template.xls


http://speedy.sh/nrWhr/TCM-Monthly-DataInput.xls
 
You must log in or register to reply here.
Back
Top