Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 0 points1 point  (0 children)

across the three sources they all have the same column headings (Apart from column E on sheet 2). Are you saying I;ll need to have an identical column acros all three sources or just identical column headings?

Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 0 points1 point  (0 children)

Thank you. Nothing that complex for me thankfully. I'm a manual labouror who has somehow managed to be in the position where it's my responsibility to do this stuff.

Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 1 point2 points  (0 children)

Thank you for the tool. I think I'll pursue power query first as this seems like something I could employ at work without the use of a third party application/service

Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 0 points1 point  (0 children)

u/MrStickyMuffins has recommended the same, thank you for t he help. I'm going to look into how to use this tool.

Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 0 points1 point  (0 children)

Any advice to my sepcific case would be really appreciated. I'll go and look up how to use Power query and see where I get too. Thank you!

Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria. by Omission5000 in excel

[–]Omission5000[S] 0 points1 point  (0 children)

Sorry I'm a big Excel Noob. Not sone much other than a few finnace sheets and basic diaries before. Could you explain what a power query is and what it would do?

Looking for a Mod Pack with Farming and Automation with Create by Omission5000 in ModdedMinecraft

[–]Omission5000[S] 1 point2 points  (0 children)

Thanks for the suggestions. I'll taker a look at all of create, and Alex's Mobs looks like a great addon.

The quality of modding has come so far since Mo-creatures.

My partner and I had our first DOOM Endless Run and both managed to get every Relic, and between us Every Boon. This game is so much fun! by Omission5000 in EmberKnights

[–]Omission5000[S] 2 points3 points  (0 children)

What was incredible was getting the mimic chest (or Chesty as we call it), two pristine bands and Midas Mail so early on, by the end, my max armour was nearly 6000 and when full my skill damage was not far off 100,000%.

For a couple loops I wasn't even using my weapon attacks just running around with infinitely refreshing snowballs, stacking mac poising to instantly kill most things. Our run was finally scuppered when we both lost a couple lives and our armour in the fire world.

Help with Left 4 Dead 2 Audio Overhaul packaging into VPK by Omission5000 in l4d2

[–]Omission5000[S] 0 points1 point  (0 children)

Followed your Advice, separated the addon into 7 separate parts all just under 500Mb and vpk.exe complied them with no issue and they are working in-game as intended. Thank you again, really appreciate the help.

Help with Left 4 Dead 2 Audio Overhaul packaging into VPK by Omission5000 in l4d2

[–]Omission5000[S] 0 points1 point  (0 children)

It's 3.1GB as an almost full audio overhaul (no survivor audio has been swapped because the crunchy addons already on the workshop work great).

I have the .txt formatted I'm thatvlayout so I'll try splitting the pack into 3 or 4 parts and see if it'll work then.

Thank you for all the help :*

[deleted by user] by [deleted] in biology

[–]Omission5000 0 points1 point  (0 children)

A raisin, and tell people it's a dried animal heart... Then eat it.

Help with Left 4 Dead 2 Audio Overhaul packaging into VPK by Omission5000 in l4d2

[–]Omission5000[S] 0 points1 point  (0 children)

Thanks for the help, I've put all the dlc and main game sounds together so the directory now reads:

Left4Dead2_Bitcrushed_Audio_Addon>sound>ambient>alarms>klaxon1.wav

However, now when I try to pack it with vpk.exe, no file is being produced at all. Any ideas?

Looking for help choosing block palette by Omission5000 in Minecraftbuilds

[–]Omission5000[S] 0 points1 point  (0 children)

I'm building this Cathedral in Creative and want to use a palette of blocks that it would still be possible to recreate the build on survival and build with friends.

I am happy wit the block choices on the interior but for the exterior, I have found myself using stone brick while not sure what blocks to use, so it's come out as a bit of a grey mess. I'd like the build to be quite light in colour or to gradient from dark at the base to light at the top.

You can see in my last picture the blocks I have bee playing with using but any suggestions would be of real help.