LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 :-)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF conditional to copy column from one spreadsheet to another TagTech Excel Worksheet Functions 4 March 6th 10 12:21 AM
How can I find duplicates in one column of an exel spreadsheet? Bill in Wichita Excel Worksheet Functions 7 September 25th 09 02:10 PM
Copy column to another spreadsheet but get value errors MoCollins Excel Discussion (Misc queries) 3 November 19th 08 05:03 PM
Find cell and copy value to column to the right Ixtreme Excel Discussion (Misc queries) 1 April 9th 08 12:17 PM
FIND LAST COPY OF A TEXT IN A COLUMN nastech Excel Discussion (Misc queries) 10 October 6th 07 03:11 AM


All times are GMT +1. The time now is 12:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"