Dynamically writing in cells after filtering

Help Activities
, ,
1

Hello,

I am a beginner.

I have an excel sheet similar to

image
image191×517 4.95 KB

I want to be able to input data in column AE in the row of present date.
I have applied a filter to filter to present date. I don’t know how to input data in the cell AE.

image

let me know if there is any way of doing it. If this can be accomplished with or without filter, Any suggestion and solutions would help. It will be great if it can be a bit detailed

2

Don’t think of it as trying to write to specific spots.

Just read all the data in (Read Range) to a datatable, manipulate the data in the datatable to get it how you want, then write the whole thing back to Excel (overwriting the existing data).

3

Even in that case, I don’t quite know how to do it. Would be great of you can tell it indetail. Thank you :slight_smile: