Replies

great wizard

PERFECT ! adjut alla for your experince and professionality; Sure you have understood which it is my idea on the years!
i have make the formulas because i dont know VBa for Excel
Tks.

PERFECT ! adjut alla for your experince and professionality; Sure you have understood which it is my idea on the years!
i have make the formulas because i dont know VBa for Excel
Tks.

For a macro, I need to know
You only want to do this to H2? or every row in col H of Rate? for every rows
Do you need to keep the formulas in H2:H20 or are the values sufficient? sure KEEP
Do you plan to run this manually or do you want it triggered in some way (perhaps checking when the workbook is open?) when the workbook is open

Tks, Tks, Tks,

For a macro, I need to know
You only want to do this to H2? or every row in col H of Rate? for every rows
Do you need to keep the formulas in H2:H20 or are the values sufficient? sure KEEP
Do you plan to run this manually or do you want it triggered in some way (perhaps checking when the workbook is open?) when the workbook is open

Tks, Tks, Tks,

Delete the cell in the range H2:H20 of sheet RATE when is the same date in D1 of sheet ANAGRAFE , and move to left the other cells of this lines, i have attached my file.

Note: i make an experiment and i have delete H2 and move to left the remainnig cells but the other cells lose the refered formuals! Arg………………

Delete the cell in the range H2:H20 of sheet RATE when is the same date in D1 of sheet ANAGRAFE , and move to left the other cells of this lines, i have attached my file.

Note: i make an experiment and i have delete H2 and move to left the remainnig cells but the other cells lose the refered formuals! Arg………………

post 335840

my dear i have reposted with new attache file.
Tks for your help

post 335840

my dear i have reposted with new attache file.
Tks for your help

i m very sorry!

I M SORRY HERE IS THE JUST FILE!

Your correction are refered for the range G2:BN2 of sheet RATE and put the value of last cell active in O2:O20 of sheet ANAGRAFE. I m very sorry!

This modify is valid for every line G2:BN20…

Tks for all.

Tks. Make me a macro…
You are very gently to help me!

Tks. Make me a macro…
You are very gently to help me!

OK! IT WORK FINE!!!

NEW PROBLEM:

Delete cell in H2 when is the same date of today, and move to left the other cells of this lines and when this cell is deleted put in O2 of ANAGRAFE the date present in the last line of this new range.
Tks, and sorry for my english

OK! IT WORK FINE!!!

NEW PROBLEM:

Delete cell in H2 when is the same date of today, and move to left the other cells of this lines and when this cell is deleted put in O2 of ANAGRAFE the date present in the last line of this new range.
Tks, and sorry for my english

TKS! But i have many difficult to translate your function in italian.
here why I would want my file modified.? Thanks
for gently to re-attache my file with your modifcation.