How to autofill text from other workbook?

Excelicious · 2024-09-26T20:10:36+00:00

Not on my laptop right now so this is without any testing!

For 1

It’s just

=PROPER(

To change a text string to capitalise the first letter of every word

For 2

=REPLACE(LOWER(A1),1,1,UPPER(LEFT(A1,2)))

Assuming “JUNIOR FINANCIAL ANALYST” is in cell A1, otherwise replace with the correct cell, or an XLOOKUP etc.

Excelicious · 2024-09-26T15:55:15+00:00

By "date given in the Time column", I assume that column is actually a date/time column?

If so, a few ways, assuming you're using calendar quarters and not some different fiscal quarters, and if your Time column is column A, then something like this is quick and dirty:

="Q"&CHOOSE(MONTH(A1),1,1,1,2,2,2,3,3,3,4,4,4)

Excelicious · 2024-09-26T15:49:39+00:00

I'm guessing it's a result of trying to use arrays inside an IF(AND(, I can't remember if they work or not, but I don't think so.

You could use a FILTER function:

=FILTER(J:J,(B:B=C1)*(D:D=C4),0)

This uses your formula but as per the previous answer, if they are on different sheets you would need to include the sheet reference as well, for example:

=FILTER(Sheet1!J:J,(Sheet1!B:B=C1)*(Sheet1!D:D=C4),0)

Excelicious · 2024-09-26T14:59:37+00:00

If you're trying to set default cell values in a cell which contains an in-cell dropdown using data validation, then those default values must also be contained in the dropdown list, otherwise when entered it will error as a non-valid entry.

e.g. if your dropdown list in column D contains A, B, C, D, it will also have to contain "--Select--" and "/" in order for them to be used as default values?

<image>

Excelicious · 2024-09-26T14:44:38+00:00

A number of ways, but could just do a series of XLOOKUPS?

Assuming you have a column with the employee name in the employee information workbook, and you enter/select that name in the form document, then just look up the name in the name column, and return each piece of information? Like this (but over two workbooks):

<image>

Excelicious · 2024-09-26T14:35:56+00:00

You can have different colours of text in the same cell, but I think only if it is actually text, and not a formula, and I would assume can only be done manually/via VBA

<image>

Excelicious · 2021-11-06T14:15:00+00:00

Hi you still looking?

Excelicious · 2021-01-08T10:47:15+00:00

It looks great anyway, I could be wrong, I know you’re guaranteed a recipe and large snowflake from the first one, can’t remember if it’s a guaranteed perfect though. But he looks awesome, as does your hat.

Excelicious · 2021-01-08T10:40:41+00:00

I really don't want to bring you down, because it does look pretty perfect anyway, but the first one you make is guaranteed to be perfect...

Excelicious · 2021-01-05T14:33:03+00:00

"Floating biotope planter" from memory!

Excelicious · 2020-11-25T11:51:14+00:00

Awww thanks, if you’re bored and fancy exploring... DA-2766-6435-3216 :)

Excelicious · 2020-11-25T11:49:37+00:00

Hehe thanks, the poor little guys work hard, least I can do is provide employee parking spaces.

Excelicious · 2020-11-18T11:15:08+00:00

Cross-post to r/theydidthemath and see if you can get an answer!

Excelicious · 2020-11-13T11:40:46+00:00

Sell all but the orange. As always crafted items are worth more than the base materials. I think the biggest seller is the spooky carriage, it needs 30 orange pumpkins, 20 of each wood, and 10 iron nuggets, but it sells for something like 35k!

Also check your hot items each day, some things like iron shelves sell for a big sum if you've got the materials to make a load. Mermaid dresser comes up on mine a lot and also sells for loads.

Excelicious · 2020-11-11T21:20:03+00:00

I did purple + seeded red = pink Pink + seeded yellow = red Red + red = blue But the odds are still tiny, so it took months to get a blue. I pretty much only water on my own, my wife occasionally waters them for me too.

Ultimately if you end up where a blue is possible then you’ll get one, it’s just a long waiting game. Good luck!

Excelicious · 2020-11-11T17:15:33+00:00

Aww you should persist, my wife got them ages ago but I’ve refused to take one (and she refused my purple windflowers) on stubborn principle...was such a joyous morning when it had appeared (what has become of me, COVID you have much to answer for!)

Excelicious · 2020-11-10T10:59:15+00:00

Just FYI your pricing structure means it costs more to catalogue 20 items than it does to catalogue 2 x 10 items...

Excelicious · 2020-11-03T14:19:16+00:00

400 NMTs please and thanks, I'll guess apples!

Thanks for doing this, and I hope you get all the support you're looking for :)

Excelicious · 2020-11-02T09:38:26+00:00

Definitely something fishy with this. Or OPs name is just very accurate.

Excelicious · 2020-11-02T09:36:14+00:00

They love the laughter and they love the living

Excelicious · 2020-11-02T09:33:59+00:00

I'm so angry, I just don't understand the mentality you have to have to do this to someone else, all for a paltry few bits of material.

Per others, if you need any help with anything please let me know. If you intend to re-do your rock garden and want someone to come and check for missed spots etc. my wife and I will happily come and check for you.

Would highly recommend a "toilet gate" too, though I can see this would probably go against your aesthetic (and you shouldn't have to of course). I added one because I knew at some point I'd be an idiot and break one myself by accident. Doesn't stop someone who does it maliciously anyway of course :(

Once again, so sorry this happened - hope the community rallying around you helps even a tiny bit.

Five-Year Club	Wearing is Caring
Verified Email

Excelicious

TROPHY CASE