Macro to paste special into certain cells

[jontyoc]

HI All
Been a while since I have been here - moved job and lost my excel go to person. Anyway, not sure how to do this.

I have a report that I copy data from, paste special as text into various different cells depending on days of week on sheet 1.
The cells are d7, d37, d67, d97 and d127 all on sheet 1.

Any help would be great.

TYIA.

 

[SteveO59L]

and where is your source value?

 

[jontyoc]

I thought I had replied to this.
My data is from html source.

If I was able to paste normally then I believe that I would be able to use the following:

Sub Macro1()
With Sheets("Sheet 1")
.Range("d7").PasteSpecial xlPasteAll
End With
End Sub


Then have a second macro with d37 and so on.