Copy and paste with VBA from internet

[PGD15]

Hi guys i've set a macro up to take me to a webpage. ... now i want to select all and paste all information into "sheet1" cell a1 on my excel document and then copy and paste the data as vales into another tab (don't know the cell ranges yet depends on how the data is important.

however on the paste special i don't want to paste all the data it will be like cell b2 "sheet" copy value to tab2 cell d1 etc (just before u question why i would paste it onto one tab before the next one)

 

[PGD15]

Hi guys i've set a macro up to take me to a webpage. ... now i want to select all and paste all information into "sheet1" cell a1 on my excel document and then copy and paste the data as vales into another tab (don't know the cell ranges yet depends on how the data is important.

however on the paste special i don't want to paste all the data it will be like cell b2 "sheet" copy value to tab2 cell d1 etc (just before u question why i would paste it onto one tab before the next one)

Update: the cells i want to do a paste special I need a lot of criteria :') which i forgot about ... this is the value will need to paste into column XXX into the next none blank cell ... provided todays date is equal to the data in column B. (bascailly the jist, i can tweak these for each value i need to paste)