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 an Excel file from which I need to export specific colums and place them in a separate file. Is there a program in Windows or Mac, which allows me to set the rules and have these saved for further re-use, so that I can define which column data from FILE 1 goes into which column from FILE 2?

In addition, I also need to change some date formating, for example from DD/MM/YYYY to YYYYMMDD in certain columns. If I can automate this process and have it saved as a rule, it will be great.

The reason I need to save these "rules" is because I am working with a data Excel file which will later need to be updated with current data, reason why a second import or a new freshly updated import will need to be done.

I have access to a Windows computer with Excel 2010, and a Mac with Excel 2011 and Numbers 09. I also have Filemaker 11 in case it may be easier to accomplish this here.

Thanks,

share|improve this question

1 Answer 1

Have you considered creating a separate Workbook that reference your original file (and performs certain formatting)?

E.g. fill the required cells in the new workbook with references like this:

=[Workbook1]Sheet1!A1

That way an "export" can easily be made by opening the referencing workbook which would automatically use fresh data, and then copy/paste as values somewhere to freeze the values.

share|improve this answer

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.