Are there really no formulas allowed in WorkbookA?
If the first field is given and the other fields are numeric I would use sumif. That avoids the issues (sort) with vlookup.
I guess a copy&paste will not work.
Cheers
André
Date
Votes
1 comment
-
Jet Reports Historic Posts 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 just 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
SD
Please sign in to leave a comment.