How to autofill the single cell with the reference of before cell dynamically

Help Automation Ops
,
1

How to autofill the single cell with the reference of before cell dynamically. The cell changes based on the column date. How to autofill horizontally.

2

Hi @anjani_priya

Can you input excel and expected Output.

Regards

3

sheet1.xlsx (12.7 KB)
yesterday date is 16 so in 16 th column it should autofill the actual % from 15 th column value

4

Hi @anjani_priya

Can you try the below

image
image900×2860 193 KB

Sequence17.xaml (21.3 KB)

Output:

sheet1.xlsx (12.7 KB)

Cheers!!

1 Like
Forum Engagement Daily Reports
5

Before cell contains formula, it should auto drag with the formula how to modify?

6

@anjani_priya

did you try with autofill range with giving range as horizontal cells?

like B1:F1

cheers

7

yes I have but i just need to auto fill for single cell

8

@anjani_priya

then give only single cell

cheers

1 Like
9

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