Macro - assistance required

SesyB

New Member
Joined
Sep 30, 2014
Messages
3
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
Joined
Mar 13, 2006
Messages
1,296
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Sep 30, 2014
Messages
3
Hi Darren,

Thanks for your response.

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,

Ade
 

Darren Bartrup

Well-known Member
Joined
Mar 13, 2006
Messages
1,296
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Sep 30, 2014
Messages
3
Thanks Darren, please update when you get the chance to have a look.

Many thanks,

SesyB
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top