View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stelllar_1@hotmail.com is offline
external usenet poster
 
Posts: 1
Default find value and copy column to new spreadsheet

Hi,
can someone please help me with this one?
I have one workbook where I have columns a-c containing common
information (a: app name, b: description, c: date),
then the rest of the columns contain translated info for several
languages. For instance it would be D:(German App name), E: (German
description), F:(French App name), G:(French description) etc.
What I would like to do is to create a new workbook for each language,
ie. GERname.xls, FREname.xls etc. where columns a, b & c are copied
there, and where the heading contains the word German, the whole column
is moved into the GERname.xls next to column a,b & c.

So all sheets will have the same info in a, b and c, but column d & e
are "localized" for each file.

I know how to do parts of it but put it all together is way over my
skill for the time being :-)