Division amidst aggregation macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

efader - 21 Jun 2007 00:47 GMT

Hi:

I am aggregating data from multiple workbooks into one workbook. Due
to the way some of the data is formatted, I want to divide one of the
metrics by 100 prior to the macro pasting it into the aggregated
workbook.

How can I accomplish this?

Thanks,
Eric

Reply to this Message

Jim Cone - 22 Jun 2007 03:12 GMT

Dim X as Double
X = Range("B5").Value
Range("B5").Value = Range("B5").Value / 100
ActiveSheet.UsedRange.Copy
Range("B5").Value = X

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"efader"
<eric.fader@gmail.com> wrote in message Hi:

I am aggregating data from multiple workbooks into one workbook. Due
to the way some of the data is formatted, I want to divide one of the
metrics by 100 prior to the macro pasting it into the aggregated
workbook.
How can I accomplish this?
Thanks,
Eric

Reply to this Message