Copy Visible Date and Paste into Visible Cells only

Hello
I have bid data and i am sharing my problem as a sample
I have attached workbook " Visible"
I want to copy the data from Main sheet against Alexander to Loans sheets against Alexander
I tried Visible Cells by using ALT+; but fail

I want ideas how can I do it
Note: Data in Main Sheets Already get by formula from somewhere else/other workbook and I just filtered required data which needs to copied and paste into Loans sheets.

Is it possible/allowable to sort the Loans" worksheet alphabetically? That would allow you to paste from "Main".

Without Sorting any other idea

Originally Posted by GeoffW283

Is it possible/allowable to sort the Loans" worksheet alphabetically? That would allow you to paste from "Main".

Using vba, this code can copy-paste value from a filtered range to another filtered range.

Please Login or Register  to view this content.

Thanks its working , can we do it without macro

Originally Posted by Akuini

Using vba, this code can copy-paste value from a filtered range to another filtered range.

Please Login or Register  to view this content.

Thanks AVK , but I have already tried it and fail

Originally Posted by avk

May be :
>Select filter data > Go to Home tab > Find & Selection > click on Go to special > Select visible cell only > ok

I have a sheet " Loans " which have some missing/blank cells against clients, on the other hand I have other workbook which contains the some information for the " Loans sheet " SO I filter the data from other work book and paste into Loans sheets against missing data/blank cells
We can fetch data via formula vlook or index match by using helping columns but i want to do it in a single go

Originally Posted by avk

can you explain in details, actual what happen? step by step

Originally Posted by vikas_newports

Thanks its working , can we do it without macro

I don’t know, I wrote the macro because I couldn’t find a way to do it without macro.

I am sorry, I have mentioned that its the sample data thats why I used Filtered

Originally Posted by avk

But in your file their is no any blank row in both sheets.
As i assuming that, you need to unique name in loans sheet & sum amount with name criteria.
see attach file.

Thank you for this code. It partially does what I'm looking for too.
One thing of note, though: the section below only skips hidden rows

Please Login or Register  to view this content.

I modified this to skip hidden columns

Please Login or Register  to view this content.

So far, those sections are of either-or use. As I'd like to skip both hidden rows and columns I also attempted to merge both loops. So far I did not succeed. The following section not only overpastes all hidden row and columns but also adds addition pastings to the right and down. Perhaps s.o. else might be able to complete it.

Please Login or Register  to view this content.

Originally Posted by Akuini

Using vba, this code can copy-paste value from a filtered range to another filtered range.

Please Login or Register  to view this content.