Share
Report
2Hello, I am extracting data from a webpage and pasting onto my excel sheet, but when it pastes, it pastes the entire column.
My current code is:
Count2 = First Free Column
Count = 2
- For Each CurrentItem in DataFromWebpage
- Write to Excel worksheet (write value datafromwebpage onto column Count2, row Count, in excelinstance)
- Count2 + 1
- End
Lets say:
| Webpage Data #1 | Webpage Data #2 | Webpage Data #3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
What is happening is the all cell value is being pasted from datafromwebpage and spilling over to other values:
| Name | Pasted Value | ||
| A | 1 | 1 | 1 |
| B | 2 | 2 | 2 |
| C | 3 | 3 | 3 |
| 3 | 3 | 3 | |
| 3 | 3 | 3 |
What I want is:
| Name | Pasted Value | ||
| A | 1 | 1 | 1 |
| B | 2 | 2 | 2 |
| C | 3 | 3 | 3 |
Categories:
I have the same question (0)
All responses (
Answers (
