Pasting one sheet cell value to multiple rows in another sheet

Help Studio
1

In my use case I have 2 sheets

Sheet one contains a table within one column having links and another column has some name in it. If you look at the image, I am talking about the column W and Z

So when I open each link in column Z, it opens in browser and has a table which can have few rows of data (varies from link to link)

I have already written a For loop to open each link and copy the data table in that link and past it in sheet 2 (column A-E which is automatically pasted by workflow and the data for next link is appended).

Now where I am stuck is, for each link in sheet one, there is corresponding name in W column which I want to past in sheet 2 column F.

Example, if I open link one, there are 2 rows of data in the data table on the website which is pasted in sheet 2 and for both these rows, of data I want to write the cell value in W adjacent to link 1 which is Alfa

Could someone suggest?

Example
Example742×727 61 KB

3

@girishankar09

Please try this inside the for loop

  1. After the data extraction into datatable use add data column activity and add ResourceName column
  2. Use assign as follows dt.Columns(“ResouceName”).Expression = "'" + currentrow("W").ToString + "'"

Hope this helps

cheers

4

Thanks for your time Anil, sorry but I could not get info about filling each line based on your suggestion, any chance you could suggest by this screenshot

Capture
Capture431×651 26.2 KB

I have 3 cells to fill, Column, Column name and DataTable

5

@girishankar09

This is what you need to include after extract datatable

image

Hope this helps

cheers

6

@girishankar09 -

  • When you are opening each link in each row, make sure you are also reading the respective “w” row and save it in a variable.
  • I’m hoping you are doing the extraction in the website using data scraping (output:DT), after extraction, add a separate column as Resource Name to the existing data table (DT)
  • Use For Each Row, then update the “w” column value (which must be in a variable) to the last column of DT
  • Write this data table(DT) to the excel, clear the data table. Repeat the same steps for the next link
1 Like
8

You are Amazing as always, thanks

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.