I had the devils own time writing a solution to this post if you could please take a look and advise?
I had the devils own time writing a solution to this post if you could please take a look and advise?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi Orrin,
I tried your code in the OP’s uploaded workbook,…. Like this:
I copied the OP’s “BEFORE” Worksheet and named that copied worksheet “OrinAfter”
I put your code from post #10 ( https://www.excelforum.com/excel-pro...ml#post4679024 ) in a normal code module.
Then I ran your code with Worksheet “OrinAfter” active.
The code ran with no problems. It appears to reproduce the OP’s “AFTER” worksheet almost perfectly, ( just the last digits is a bit different on some numbers , but might be some number formatting at my end )
Enclosed the file after running the code.
Alan
(I am using XL 2007 )
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks