Macro to paste data based on date

[RiaMelissaJaravata]

Oh, wait, before you go, I have one last question... There are instances that the values are percentage. Your code does not support percentage values It copies them as a whole number. Is there a code that can copy percentage values? I was trying this:

myValue = WorksheetFunction.Round(ivr.Sheets("Dettaglio rilascio ISUP Milano").Range("A6").Offset(myDate - 1, 71).Value, 4)


But does not work.

 

[NARAYANK991]

Hi ,

OK. I will take care.

Narayan

 

[RiaMelissaJaravata]

I was trying this too:

Const PERCENTAGE = "%"
myValue = Format(ivr.Sheets("Dettaglio Canali di Accesso").Range("A6").Offset(myDate - 1, 10).Value, PERCENTAGE)

But does not work

 

[RiaMelissaJaravata]

Ok thank you so much, Narayan!

 

[NARAYANK991]

Hi ,

Try this :

Const PERCENTAGE = "#.##%"
myValue = Format(ivr.Sheets("Dettaglio Canali di Accesso").Range("A6").Offset(myDate - 1, 10).Value, PERCENTAGE)

Narayan

 

[RiaMelissaJaravata]

Thank you, Narayan

 

[NARAYANK991]

Hi ,

See this file. The Start Time is specified within the code , in this line :

StartTime = "00:50 - 00:55"

Change the above to what ever other start time you want entered.

The code is not looking at whether the data is filtered or not.

Narayan

 

[RiaMelissaJaravata]

Hi Narayan,

It is not working It does not copy any data

 

[NARAYANK991]

Hi ,

I forgot to undo some changes at my end ; if it works for me , it will not work for you , because of the date formatting.

See if this works.

Narayan

 

[RiaMelissaJaravata]

Hi Narayan, it works perfectly. Thank you soo much, it is a very big big help!