Using the variable x, copying the value of the cell to the right using offset.

[Andysmith1983]

Hi,

This is my very first VBA post so I apolgise in advance if I miss something vital. I've spent a little while looking at forums but cannot find many posts where variabes are used alongside offsets. I need help in VBA completing the following steps which is activated by the click of a button.

- Find the value of x (used as a counter) within the range B5:B11 on the sheet called "Site Costs".
- Once the value of x is found in the range B5:B11, offset one cell to the right to obtain the Primary Value for x.
- Paste the Primary Value into the cell B13. (temporary test as I aim to complete the below).

- Copy the value from the Primary Value cell back to the main "Customer Site and Core Costs" sheet in the relevant x row.
- Paste the Primary value into the Primary Circuit Cost field which has an offset of six to the right.

Its the block of code in between the >>>>>>>>>>> <<<<<<<<<<<<<<< that is causing the problems for me as I have tested the loop already and it works.

Please Login or Register  to view this content.

Any advice would be appreciated.

Thanks in advance


Moderator Edit:

Welcome to the forum, Andysmith1983.

Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[HaHoBe]

Hi, Andysmith1983,

you either have to loop through the range in the other sheet as well or use Application.Match to find the value. The change to your code is untested:

Please Login or Register  to view this content.

An example how to use Application.Match:

Please Login or Register  to view this content.

Ciao,
Holger