resources

The migration of the MrExcel Message Board to Xenforo has consumed the better part of 2019. But now that we have migrated, I would like to take advantage of the excellent editor that we have in the new software. I frequently meet a person or co-worker in real life who has an Excel question. In...

Hi, I'm looking to have 1 sheet that has a list of resources that can be booked. On that sheet if you choose a date and time it shows which resources are free on that date and which are not. If you then want to book one of them, you enter say a "Y" and it then pulls through to a calendar style...

Overheard at work today... They say that you should not dress for the job you have, but rather dress for the job you want. So, here I am, sitting in Human Resources, dressed as Batman!

Hi Everyone, The short question would be this: Is there a way to insert slicers for each of the subcategories from a Pivot table? To expand the question and give you a bit more details: I'm working on updating the UI for an excel sheet with a long list of columns that contain information about...

So after several years of doing the impossible with Excel. I started a new job recently where my primary function will revolve around pulling in data (of all types) and turning it into something usable. So I've collected a small library of resource material. My question is what ( Books...

I have a table on one sheet called BOOKINGS that has information for who booked a room, what room they booked, the date and what resources they need. I can look up and display every entry for a particular room easily enough but what I'd like to do is to display only the entries for that room...

I'm launching a user form from a worksheet. I then concatenate the values from that form to make a string and sending its value to a cell on another worksheet. Private Sub SaveButton_Click() Dim resources As String Dim r As Integer r = ActiveCell.Row If ProjectSponsorBox.Value <> "ERROR"...

Hello Everyone, Requesting your help. I have two excel work book named "Inventory.xls" and "Resource.xls". In a resource workbook, I have a set of resources available for the day and everyday the data may be change. In a Inventory workbook, I have a set of datas needs to be worked. I need...

Hi, My excel file calculation takes too long, I've been told to change to different formulas in order to use less system resources, thus, calculation will take much less time to run. Which of the following formulas uses less/more system resources...

Hi, I'm new here, I would love to get resources on VBA - very resourceful analytical materials, thanks guys

broad question but i have a report that ends up being close to 26KB and it takes way to long to open and function. most of the report is based off SUMIF statements, stuff like that any resources, tips anyone has i can use/check to try and make more efficient and shrink the size so the user can...

Hi, Can anyone point me to some good resources which show the changes implemented in VBA for Excel 2013/2016 from 2010 please? I have macros which I've built in 2016 and need to convert to use with 2010, including pivot tables and slicers, but I'm struggling to find anything which helps me do...

Hi guys, I need a simple VBA code that will open a new email in outlook and with the TO and CC recipients predefined and the subject line prefilled. Pretty much a newbie to VBA so any help resources for beginners you find useful would be helpful too. Thanks in advance.

I have a spreadsheet that is 1.3MB big. Not a large spreadsheet in my mind?! there are alot of formulas throughout though, it was fine yesterday but today it is showing up a excel has ran out of resources error...does anyone know how to work around this/fix it/get fir of it?!

I would like to replace the manually replenished production plan with (semi) automatic planning production plan is in (working) days the production process has 7 stages one after the other two stages: forging and grinding can overlap, i.e. the last day of forging can be the 1st day of grinding...

Hi, I'm trying to figure out the best approach to a problem and need some advice on tackling it. I have a set of data I need to import from one workbook into another. The source data is a forecast of time required by different resources to work on a given project and is presented like this...

I am writing an IF formula and though I searched here I couldnt find one. I am in need of a method to assign a value to every other resource. for example I have a list of 1000 potential assignments. Each assignment has certain other criteria assigned to it based on values like "State" and...

I wonder if someone could help me by pointing me in the direction of the resources needed to that I would be able to convert the dashboard that I have into an Internet Explorer webpage. The idea is that I supply a link and via VBA convert the Dashboard I have into an IE page which would update...

Hi gang, I'm a long time excel user but novice VBA writer. I've been working on this VBA and have cobbled together something that works when the data is in a range (for test purposes). Now I need to make this work within an Excel table for regular use. The table syntax is tripping me up. I'm...

I'm working on a databank of resources. I've created a pivot table so that other persons can search through the information seamlessly. These resources include an overview of information in the table, but if the person searching through the information would like a more in-depth description I've...