Hi I am new and i don't know much about macro's yet. Sorry for my grammar.
I would like to import some date from a website. This i do manually (just copy paste). Then i would like to copy certain cells from this worksheet (1st worksheet) to other cells in another worksheet (2nd worksheet), so that i would only have the data i need and i would have my own lay-out. Finally i should be able to delete the imported data without this having an influence on the 2nd worksheet. I would like that excel does this automatically after i paste the imported data in my excel.
Explanation:
- cell C9 in 1st worksheet has a certain value.
- column A in 2nd worksheet contains values of the same kind as cell C9 in 1st worksheet
- A particular cell in column A from the 2nd worksheet has the exact same value as C9 in 1st worksheet.
- Data from some cells in 1st worksheet (let's say:B3, G8, G9, F3) should be autmotically copied to certain cells in the relevant row in the 2nd worksheet
- Data in 1st worksheet can now be deleted.
- 2nd worksheets keeps this data.
Thanks in advance
Bookmarks