Paste to visible cells only (without VBA or VLOOKUP)?

[dalesea]

Hi All,

I've been trying to solve a long-standing bug bear that's got me stumped.

To give an example:
> In WorkbookA, A1 = "Customer A", B1 = 1000; A2 = "Customer B", B2 = 0; A3 = "Customer C", B3 = 500. Row 2 is hidden.
> In WorkbookB, I have A1 = "Customer A", B1 = 1000; A2 = "Customer C", B2 = 500. All rows visible.

Going from WorkbookA to WorkbookB, I would use GoTo > Special > Visible Cells only > Copy > Paste (works). But how do I copy/paste WorkbookB!A1:B2 to WorkbookA!A1:B3 (excluding row 2 in WorkbookA)? I guess I want to know if there is a way to Copy > GoTo > Special > Visible Cells only > Paste (error).

I would use a VLOOKUP formulae then paste values or achieve it via a do/loop macro - but there's a specific requirement that these methods aren't used.

Any thoughts?

Thanks

 

[Al Chara]

As I understand, Excel will paste into a contiguous range, not just the visible cells.