Looping Problem

[Varun13]

Hi
I have written a Macro. It checks the value in one in "Workbook1" (i.e A1), if true it copys the selected cell and paste the value in "Workbook2" cell A1
I'm able to loop it so as it selects the checks value in "Workbook1" (i.e A2), however it paste the data in "Workbook2" cell A1 only, not A2, nested loop fuction not working.
Is there a way that it checks that if there is data in "Workbook2" A1, it automatically paste the value in "Workbook2" A2.

Any help is Appreciated.

Thanks

[mike7952]

something like this maybe.

Please Login or Register  to view this content.

[Varun13]

Please Login or Register  to view this content.

This is the code that i have written. At this moment its pasting value in Cell B4 & C4. I want it to move to next cell when loop runs. Hope its more clear now

[Cutter]

@ Varun13

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 top of the page and read Rule #3.
Thanks.

[Varun13]

Thanks once again cutter

[mike7952]

give this one a try

Please Login or Register  to view this content.