Week Number in excel column increasing in each cell

Help Activities
, ,
1

Hi, I have cell B2 which has value of Weeknumber Like WK 15. I want to copy down that same cell value to match the other columns row suppose upto D20. When I do that using auto fill range , it fills up to B20 but it is increasing week number on each cell like WK 16, WK 17, WK 18…

How to copy down same value?

2

Hi @pari_patel

Can you try this

A detailed Excel process automation workflow showing steps to read a cell value, iterate through each row, and write the cell value to a specific address in an Excel file. (Captioned by AI)
A detailed Excel process automation workflow showing steps to read a cell value, iterate through each row, and write the cell value to a specific address in an Excel file. (Captioned by AI)638×1301 44 KB

Input:

An Excel spreadsheet displays financial data with columns labeled Debit Acc, Debit Amount, Credit Acc, and Address. (Captioned by AI)
An Excel spreadsheet displays financial data with columns labeled Debit Acc, Debit Amount, Credit Acc, and Address. (Captioned by AI)667×334 5.88 KB

Output:

A spreadsheet displaying financial data, including debit account numbers, debit amounts, credit account numbers, and addresses, all associated with "WK 15". (Captioned by AI)
A spreadsheet displaying financial data, including debit account numbers, debit amounts, credit account numbers, and addresses, all associated with "WK 15". (Captioned by AI)777×523 7.71 KB

Regards,

1 Like
3

@pari_patel

Another approach

The image shows an Excel automation workflow which reads a cell value from "Sheet1" and writes it to a specified range in the same sheet. (Captioned by AI)
The image shows an Excel automation workflow which reads a cell value from "Sheet1" and writes it to a specified range in the same sheet. (Captioned by AI)585×997 32.8 KB

Excel.Sheet("Sheet1").Range("D3:D"+Excel.Sheet("Sheet1").DataTableValue.RowCount.ToString)

Regards,

1 Like
4

Hi @lrtetala
Thanks for the solutions. Working absolutely correct.

Happy Automaton!

1 Like
5

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