Moving or copy data from three sheets (same workbook) into a new workbook based on cell

**sag74** · 09-14-2012, 05:09 PM

Dear all, i'm new here and struggling with a vba issue.

I have a workbook with three sheets in it. They all are raw data (downloaded from a CRM program at my workplace). In another workbook i have a sheet called INDEX and VRD. VRD is basicly the cleaned data from the three sheets as i mentioned before. INDEX is a sheet whith calculations.

What i want is to use a vba statement to copy the data from the three sheets based on a criteria. The criteria is the cellvalue (A2:A698) of sheet INDEX. So far i came up with this code:

Please Login or Register  to view this content.

So to continue: LOK should be the INDEX!$A2:$A698..... from here i'm stuck. Could someone help me out?

So far thanks in advanced

**xladept** · 09-14-2012, 07:27 PM

Hi sag74,

Your code worked-and, I got A2:A57 for all the EW's - what is the problem?

**sag74** · 09-15-2012, 03:09 AM

Hi xladept,

The problem is that i need to use workbook TEST and specific sheet INDEX col A row 2 to 698 as the criteria for LOK.

LOK is the criteria for the statement.
So far i came up with LOK =("C:\....[TEST.xls]INDEX!$A$2:$A$698.. but from here the code is generating error 1004(out of range etc)

**Cutter** · 09-15-2012, 02:02 PM

@ sag74

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

**sag74** · 09-15-2012, 02:18 PM

@ cutter,

Thanks for mention it

Regards

Moving or copy data from three sheets (same workbook) into a new workbook based on cell

LinkBack

Thread Tools

Rate This Thread

Display

Moving or copy data from three sheets (same workbook) into a new workbook based on cell

Re: Moving or copy data from three sheets (same workbook) into a new workbook based on cel

Re: Moving or copy data from three sheets (same workbook) into a new workbook based on cel

Re: Moving or copy data from three sheets (same workbook) into a new workbook based on cel

Re: Moving or copy data from three sheets (same workbook) into a new workbook based on cel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions