Copy>Paste Block of Data

[Murtaza]

Good Day!

My query is to find how can I Copy different Blocks of Data & Paste them
accordingly.

For your understanding below is pictorial explanation.

Source Range:
A B C D Action
1 v v v v Copy
2 v v v v Copy
3 f f f f
4 v v v v Copy
5 l l l l

v = Constant Text / numbers
f = Formulas
l = Links

Now I want to copy all the V's and ignore 'Fs' and 'ls" then after copying I
want to paste them. Like below

A B C D Action
1 v v v v Paste
2 v v v v Paste
3
4 v v v v Paste
5

Points to consider is that all rows are pasted relatively i.e. R1 should be
on R1, R2 on R2, R3 skipped, then R4 on R4

I do all this Copy Pasting manually and besides its tedious there are more
odds of error.

I hope you experts have understand the scenario & must have some tricks to
overcome this. If you need more information, please ask.

Best regards,
Jeenat

 

[Dave Peterson]

As long as your formulas are on dedicated rows, you should be able to do this:

Copy your complete range to the new location.
Select that pasted range
Edit|goto|special
Click Formulas
Now just the formulas are selected (from that pasted range)
Hit the delete key on the keyboard to clear the contents of the selection.