Copy various fields from one workbook to various fields in another by criteria

**ANDREAAS** · 06-18-2015, 01:17 AM

Hi

I have a sheet that is extracted from an application. Column 1 of the extracted sheet has "F numbers". I need code that can copy all the same "F numbers" and the entire row of said "F numbers" to certain blocks in my master sheet.

For instance, there is 6 instances of F4I in the extracted sheet, so I need all those rows to be copied to the first block in my master sheet and there is 3 F4D's which then needs to copy to the second block in my master sheet and so on....

I need this to work as a add - in where when the user has extracted the data sheet from the application and then press a add-in button it populates the master sheet.

The "F numbers" will differ each time that I extract the data to excel sheet from my application. The extracted sheet will have a different name each time as the application where it is extracted automatically names it with the area prefix and the current date.

The blocks that I refer to above in the master sheet is : block1 = A2:O21 block2 = A23:O42 and so on...

**ANDREAAS** · 06-22-2015, 05:25 PM

Bump no reply

**ANDREAAS** · 06-27-2015, 01:23 AM

Bump no reply

**ANDREAAS** · 07-03-2015, 01:34 AM

Bump no reply

**ANDREAAS** · 07-06-2015, 06:23 AM

Bump no reply

**ANDREAAS** · 07-08-2015, 09:04 AM

Is this even possible?

**ANDREAAS** · 07-10-2015, 09:08 AM

Bump no reply

**ANDREAAS** · 07-11-2015, 01:52 AM

Bump no reply

**ANDREAAS** · 07-14-2015, 06:22 AM

Bump no reply

**ANDREAAS** · 07-17-2015, 02:57 AM

Bump no reply

**ANDREAAS** · 07-21-2015, 09:18 AM

Bump no reply

**ANDREAAS** · 07-31-2015, 09:46 AM

Bump no reply

**ANDREAAS** · 08-15-2015, 12:30 AM

Bump no reply

**ANDREAAS** · 08-22-2015, 03:10 AM

Bump no reply

**ANDREAAS** · 09-07-2015, 10:35 AM

Bump no reply

**ANDREAAS** · 09-22-2015, 10:02 AM

bump no reply

**ANDREAAS** · 10-01-2015, 06:20 AM

bump no reply

**ANDREAAS** · 10-09-2015, 03:32 AM

Bump no reply

**ANDREAAS** · 10-10-2015, 03:54 AM

bump no reply

**ANDREAAS** · 10-22-2015, 05:54 AM

Bump no reply

**ANDREAAS** · 11-17-2015, 05:27 AM

Bump no reply

**ANDREAAS** · 04-24-2016, 02:58 PM

Bump no reply

**ANDREAAS** · 04-24-2016, 05:14 PM

Hi

I found the code below(thanks Ron de Bruin). not sure if this will help. I can't get it modified to work for me and this code will have to loop somehow...

Please Login or Register  to view this content.

the code gets stuck here :

Please Login or Register  to view this content.

before this runs I have a macro that runs to copy all the "Fnumbers" to A400 and then removes duplicates, so I only have the unique "fnumbers" left. Then the code above has to loop and do it's thing filtering by A400 and copying to A2 in the master sheet, then it must filter by A401 and copy that data to A23 in the master sheet and then A402 to 44 etc. etc.

Hope this will help you help me with this problem

**ANDREAAS** · 04-24-2016, 05:20 PM

sorry, never mentioned what the error is when it gets stuck. it highlights .range and gives the error :
Compile error :
method or data member not found

the code uses the lastrow function which I have set to A2 as below.....don't know if this is relevant???

Please Login or Register  to view this content.

**ANDREAAS** · 04-26-2016, 03:55 PM

tried another approach, but the code is very long. please could someone help to loop through the "copyfnumber" sections. I know how to loop, but have no clue how to loop if the criteria range has to change with every loop and the paste to range has to change with every loop. here is the working code that needs to loop :

Please Login or Register  to view this content.

Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Re: Copy various fields from one workbook to various fields in another by criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to put restricted areas or fields on same workbook until filing some fields first?

Bookmarks

Bookmarks

Posting Permissions