PDA

View Full Version : Dynamic Linked Ranges (Format & Content)



Za_Dia
07-14-2015, 04:37 PM
Please can some help me save what's left of my hair. :bug::bug:

I have a worksheet which compares the planned and actual hours and highlights the difference. The goal is to use the same format and content for the three sections (Planned, Actual, & Difference) with only changes to the number for hours. (See below)

1392713928

When there are changes (such as additional department or employee) the content and format would automatically update in Actual and Difference section with the number of hours left blank.
There is also a second worksheet that compares planned and actual pay rates and their difference. This would be a replica of the first worksheet with a few changes such as the format being currency instead of integers and the amount space left blank to fill.

The idea seems to be a relatively easy one but I can't seem to wrap my head on the execution. I would appreciate any help such as a direction to approach this from or a vba/function that actually achieves this. Thanks in advance.