Find Cell Value that is Same in Column and Paste That Row

[alex337]

Hello Everyone!

My first time on this forum so excuse my noobiness.

I need to create a macro that automatically checks to see if the current cell value has any other corresponding values in a different column on another sheet and if it does, copy the row that row to the current cell value.

EX:
In Filtered Data sheet, A1 which has value of say 100.
Macro goes to Raw Data sheet and goes down Column C looking for values of 100.
If corresponding cell is found that entire row is copied to Row 1 of the Filtered Data sheet.

Appreciate any and all help!

[AB33]

alex337,
Welcome to the forum!
Please attach an excel book sample. To attach a sample, go to advance then attachment.

[bos1234]

hi
i have posted a similar question here. Still waiting for an answer. Keep your eye on that thread also
http://www.excelforum.com/excel-prog...ding-cell.html

[alex337]

Okay here is an example excel file.

Upkeep Database sheet includes all animals and their respective costs for various factors.
My Upkeep sheet includes only some of the animals that I own.

What the macro has to do here is look at the animals I own (My Upkeep sheet) and copy the upkeep costs from the Upkeep Database.

I know the excel file here is very simple :P the one I am dealing with includes thousands of "animals" which explains my needs for a macro LOL

[Debraj Roy]

A simple Advance Filter, with criteria Range as "Your Upkeep sheet!a1:a" & n will work best...

I think, no need to jump in the VBA Well..

try and if required record it..

[AB33]

Try the attached.

[amiable]

Hi, Same issue look like mine, Mapping the Text Using macro. Still am not able to resolve this issue

[AB33]

amiable,
Please start your own thread as per form's rule.

[alex337]

Try the attached.

Worked perfectly thank you very much! *sigh* I should really start taking some course in bioinformatics, proteins are haunting in my sleep.

[alex337]

Okay if I wanted to make it more advanced (such as having multiple My Upkeep sheets) how should I adjust the macro without having to change "My Upkeep" sheet everytime in macro editor?

Please Login or Register  to view this content.

[AB33]

What do you do with the snacks? Are they venomous?

[AB33]

If you are trying to compare the database sheet with many multiple My Upkeep sheets, you need a completely different code.

[alex337]

Hehehe I just overdose on caffeine. *grabs another cup of coffee*

[Debraj Roy]

OP wants to use them in Your VBA.. to give a real feeling for this game

[alex337]

If you are trying to compare the database sheet with many multiple My Upkeep sheets, you need a completely different code.

Oh noes...well it doesn't matter I can just adjust the macro as I go as I only have 10 data sheets. You already help shave of several days off my research Original data revolves around comparing protein levels with various other tissue cells and the module you helped me was the final part in the comparisons! I can't thank you enough lol.

[alex337]

OP wants to use them in Your VBA.. to give a real feeling for this game

LOL that just brightened my day Gods Excel Macros are harder than python Q.Q