How to write data from Sheet 1 to Sheet 2 depending on the month, year and department

[rosina.flores]

Hello, I am having a problem with my project. I want to transfer data from sheet 1 to sheet 2 in specific locations. For example, from sheet 1 in the Cost table, in cell HR where the month Jan has a value of 250, I want to transfer this value to sheet 2 where it says 2024, below cell 1 (which represents January), and place the value 250 since it corresponds with what sheet 2 says, and so on. In my sequence, I am having a problem:

In the write cell activity, I have the following error: Argument Cell: BC30512: Option Strict On disallows implicit conversions from ‘String’ to ‘IReadWriteCellRef’. The selected value is incompatible with the property type.

Additionally, the sequence has a warning: One or more children have validation errors or warnings and the following error in Debug:

Sheet1:

Sheet2:

Excel file:
Copia de RPA2 2.xlsx (14,5 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @rosina.flores ,
You can get data form sheet 1 from C3 then write to sheet2 from M3
You can get index 3 by dynamic find 1st Jan in sheet1 and 2024 in sheet2
Regards,

[naveen.s]

@rosina.flores ,

Use this (below) expression under “Where to write”

Excel.Sheet(“Sheet12”).Cell(“E1”)

Replace E1 as per your requirement