Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default copying values form one workbook to other

I have one workbook in which I need to copy data from other workbooks
So it's going to be some kind of a database.
Now the thing is that the database workbook has more fields than th
workbooks because not all workbooks are same. For example, in databas
workbook I have in column A something like this:

S 2
0.06 < S < 2
S<0,08 mm
S<0,06 mm

and in column B there are the percentages. Now in some workbooks ther
is no S<0,06 mm field. It was just left out. That's not bad, but th
problem is that the row numbers from the workbook do not match with th
database workbook anymore. So I need some kind of macro that wil
compare names in column A in both workbooks, and when match, copy th
data from the workbook and paste it into the database workbook to it'
corresponding place.
Please help

--
Message posted from http://www.ExcelForum.com

Reply
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
Copying a form jeanmhealy Excel Discussion (Misc queries) 1 July 17th 09 11:23 AM
Copying data entered into a form to another workbook zak Excel Discussion (Misc queries) 0 December 29th 08 12:14 PM
Copying data in a form into an alternative Workbook dave m Excel Discussion (Misc queries) 1 January 1st 08 06:06 PM
How do I call number values form one workbook to another workbook Teryn Excel Worksheet Functions 3 December 29th 07 09:21 AM
formula for copying values from one workbook to another ClareNaish Excel Worksheet Functions 1 October 3rd 06 03:07 PM


All times are GMT +1. The time now is 03:41 PM.

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

About Us

"It's about Microsoft Excel"