Next empty column

Help Activities
,
1

Hi all,

I’m looking to copy cell A1 to paste on the first empty column of row 4.
Currently it is at column JL but this empty column will change.

I have read cell A1 and define it. Can I confirm how do i write this to the next empty column of row 4? Thanks!

image
image1055×230 78.2 KB

2

@victorialim

Use Read Range activity and declare a variable for Datatable

Now you can declare a variable for count and write as Datatable.Rows.Count

This will give you the rows count then you can decide where you want to write you results

Hope this may help you

Thanks

3

Hello @victorialim

You can write as below to get the first free column index. Using that you can write to the first free column.

image

4

Hi @victorialim,

In step 1, it is necessary to dynamically find the letter.

Then you can use this in step 2.

image
image1317×468 28.3 KB