# Macro - assistance required

#### SesyB

##### New Member
Hi,

I need a macro equate a cell to another cell for only 7 days, etc.

So, every week, as i manually input the value in one cell, it automatically equates to the other cell as this is done on a weekly basis over a 52 week period.

I hope the above makes sense.

All help and advice will be much welcome.

Kind regards,

SesyB

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### Darren Bartrup

##### Well-known Member
Hi SesyB & welcome to the board.

I'd say it doesn't make sense. The question sounds like it should be easy, but I'm not sure what you mean by 'equate'.

So you put a value in a cell and it 'equates' to another cell.
So if I put the value 'A' in a cell what does it equate to in the other cell, or if I put a date in, or a number?

I'm guessing you put the week commencing date in a cell and somewhere else it will fill in the other dates within the week?

#### SesyB

##### New Member
Hi Darren,

Basically, I monitor a number of performance indicators, and I put in the numbers for 3 different shifts, e.g A shift, B Shift, and C shift.

I plot the average figures on a weekly basis, but I am now also plotting each shifts data for the 52 week as well as the average of the 3 shifts.

Now, the macro is needed just to display thee figure that is being plotted.

So the display cell {CONSTANT} {e.g D17} will be euqals to {week 39}, and then next week it will be equals to {week 40}, i.e.: whatever the figure in week is, and then for the week after, it'll be equals to week 41 etc.

I can send you the spreadsheet if you want, and hopefully that'll make more sense.

Kind regards,

#### Darren Bartrup

##### Well-known Member
Yep, send me the spreadsheet - I've mailed you my email address and will update this thread when I've figured it out.

#### SesyB

##### New Member
Thanks Darren, please update when you get the chance to have a look.

Many thanks,

SesyB

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,031
Messages
5,856,936
Members
431,841
Latest member
jaybeem

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back