Populating Further Cells with Previous Input

[Aliarcy]

Hello! Thanks in advance for the help -

I'm trying to build a set of rules for an animal rearing worksheet. It's tedious and error-prone to add it all into a calendar by hand, so I'm hoping to save time. Ideally it would be something like:

If cell = X (fed), cell+5 = Y (eggs)
If cell+5 = Y (eggs), then cell+8 = Z (hatch)

I'm trying to populate this into a compressed pseudo calendar. Would this be feasible? I've sorted how to change my cell based on what's within it, but that's not quite far enough for what I'm trying to do.

Cheers!

[Pete_UK]

We can't see your workbook, or deduce what cell and cell+5 actually mean.

Attach a sample Excel workbook - the yellow banner at the top of the screen explains how to.

Pete

[Aliarcy]

If I put "AAEG Feed" in C2 I would want it to populate C5 (AAEG Egg) and C13 (AAEG Pupae). I've attached the workbook, but also copy/pasted it here to show an example. Thanks!


December Date Tasks
1 AAEG Feed
2 ROCK Feed
3
4 AAEG Egg
5 ROCK Egg
6
7
8
9
10
11
12 AAEG Pupae
13 ROCK Pupae
14
15
16

[ChemistB]

You'll need an event driven macro. Right click on the tab key and select "View Code" and paste this code into the large white text box in the VBA Editor window that will open up.

Please Login or Register  to view this content.

Then close the VBA Editor (no need to save). You will need to save your workbook as a .XLSM file. Any questions?

[Aliarcy]

Thank you!! That's super useful. I don't need to change it now, but in the future I may need to adjust pupation dates for different species. How would I write it? (I'm very new to code) I've put below what I would expect it to be, but it isn't running so I must have messed it up at some point.

Please Login or Register  to view this content.

[ChemistB]

Okay, let's say the only two species that have a different time frame (from a multitude of species) are AAEG and AALB. Instead of separate IF statements for each one, you can use Else If...
I don't think this is correct for you either (from your post) [let me know if I'm mistaken]

Please Login or Register  to view this content.

I think you want

Please Login or Register  to view this content.

Here's how I think the entire code will look

Please Login or Register  to view this content.

[Aliarcy]

Thank you all so much! That worked perfectly! I really appreciate it - my job just got a lot easier.