Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have this time-sheet app that can output a csv file (with my check-in and out with project name and comments) that I would like to copy come row into the template used at my job.

For example, the template should always have the same 2 row (my name, formula for total time and column title) and export column 1, 2, 4 and 6 of the csv file to column 2, 3, 4 and 7 starting at row 3 in the time-sheet.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Double import the data from csv file during unwanted columns

Twice import the data from csv file, skip unwanted columns

Double import the data from csv

share|improve this answer
    
double? during unwanted column? And yea, I know how to copy paste, I'm more thinking about a script that would do it, something I could prepare once and it would do it faster the next time –  matmat07 Mar 16 '13 at 21:55
    
@matmat07 Import data is not copy-paste ... Create a template, where you get the data from csv file and use it. Change CSV - autochange data in open excel file. –  STTR Mar 16 '13 at 22:01
    
Played with the settings and it seems to work thanks –  matmat07 Mar 16 '13 at 23:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.