Formulas with conditional Formatting using a dynamic Range

**sonny.thind** · 12-21-2011, 09:20 PM

again this may seem very easy but I really need to get this to work..
This is a sheet of Markets that I export into excel every day. So I recorded a Macro using the Macro Recorder which formats this sheet(see Code Macro8 in the Sheet Summary Report ) columns are for Dates and Rows are for the markets that list available deliveries , Number of Deliveries and the Percentage(that’s where the formula is) .The Formula needs to be copied into the percentage cells of all the markets.
Since I Recorded this macro sometime back we had only certain amount of Markets (rows) and only for 16 days (columns)but now we are growing and need this for two months and maybe more in future— instead of recording the macro again with additional rows—I need to create a dynamic range macro to automatically adjust the formulas to match the newer and additional rows along with more dates.
.
How Do I amend this particular code and make it smaller in size ?

**sonny.thind** · 12-23-2011, 11:49 PM

Just hoping I could get some help with this ( i know its not policy to ask for help) but it being Christmas and all... Hopefully could get some Christmas cheer on this . I just really need to change this recorded code into VBA.
Merry Christmas Everyone!

**dangelor** · 12-24-2011, 03:17 AM

Give this a try...

Please Login or Register  to view this content.

**sonny.thind** · 12-24-2011, 12:47 PM

WOW! this works Like a Charm.. Thanks a Lot brother. You don't know how much you made my day. God Bless you and your Family a bountiful.

GOD bless all you wonderful people out there who help the less fortunate....like its said.."Sometimes a little for someone goes a long way for another"

Have Safe and Merry Christmas.