Macro to copy value and paste to adjacent cells in the same row w/ defined # of copies

[ywang]

Hi,

I need a macro w/ a toggle button to look for Number values and copy them to the adjacent cells based on user defined number of copies.

For example, the 1st Number occurs on LR30 (in red for visual purpose) and based on the user defined number of copies in KU2 (Number of copies before LR30) and KU4 (number of copies after LR30) the macro will copy the cell in LR30 into the adjacent cells.

The macro will need to run on KU7:WG305 and the macro needs to ignore N/A and null values "".
This sheet will be used for multiple scenarios so the sheet will be copied and renamed.
The number of occurrences will change but it is consistent within the same sheet.

Any help will be greatly appreciated. Please see attached.

-Yong