management

Maybe a silly topic, but I'm still novice and quite unsure about some details. I have a Userform. Left side column has the menu, consisting of 7 options/"buttons". Those buttons are actually images which change when their area is hovered. E.g. they are originally blue, the hovered state is...

Hi guys, I'm setting up an Excel sheet to maintain a spreadsheet for asset management. We have an asset management system in place, but there are occasional times where it's offline(Or I am), so I wanted to make something that I could chart these items on, and I wanted to get a little fancy. So...

Hi, I have tried the following which does work when run in another module but when I put it at the beginning of my main macro (which worked previously) it will bring an error. Further on down I have a macro relating to the newly created worksheet and I also amended it to include ThisWorkbook...

I can import data from SS Management Studio into Excel using VBA and ADO. Is the process the same if the data is in SS Reporting Services instead of SSMS? If not, how would I go about it? Thanks

Hello all, I am a beginner in macros. Here is what i wish to do. From a given cells in a column i want to select a particular pdf file and combine all those files into a zip file. For eg if the excel sheet contains the following columns: Roll number, Preference. So if i have the following data...

Hi I am really stuck with my formula! Any help is much appreciated I have created my countifs statement which is working fine and returning a result of 3 - but i want to take this one step further and do a count only of unique values to show that although there are 3 headcount assigned to tasks...

Hello, I'm looking to match delegates at courses to interest columns based on the topic of the course. The original data looks like this: DATA EXPORT <tbody> Course Email Bookkeeping Basics richard@aaa.com Bookkeeping Basics peter@bbb.com Bookkeeping Basics sally@ccc.com Management...

Hi guys . . . I'm after some help / guidance.. I have 8.5 hours a day available (Monday to Thursday) and 4.5 for a Friday (07:00 - 15:30 & 07:00 - 11:30 respectively) I need to plan in a number of activities that could span over multiple days (in hours & minutes) I want to enter a start date...

Hey! Unfortunatelly, I am still not good at defining own functions in power query. May someone of you can help me. I have the following table: Date - Value 01.01.2018 0.75 The aim is to get for weekdays a maximum value of 0.75. So if the value ist 0.76 and its...

Hello! I would like to ask you for help programming inventory management system in excel using VBA and userform. I would like to form one easy excell file, which gives you information about stock level (I am starting with small business for parents and my 2 parents besides me will pack...

background: I'm building a reference file of branded product names. My aim is to have a clean list that can be used to search through a free text fields from a CRM system. I want to find brand-names, but do not want common words like "account" or "management", since that will return almost...

Please help A1 has the list has specialisation ( From a data validation list ) B1 has the semester no. ( 1 to 6) Now from Cells c1 to j1 the values should change based on the value of cells a1 and b1 like if the specialisation is marketing Management and semester number is 1 cell c1 till cell...

Hi This may get complicated so please be patient with me. A management tool was developed to track staff performance. There are three tabs that my administrator will paste information into which is extracted from our different onlinr management systems. There is a tab that automatically...

Hello - HI used to SUMIFS statement to read from closed workbooks to find out this doesn't work. I'm having trouble converting the SUMIFS statement to SUMPRODUCT. I'd very much appreciate it someone would help me re-write to a SUMPRODUCT. =SUMIFS('[State Funds Financial Management...

I want to see if this is possible. I have data like this: there are 1000 rows like this and 17 sheets of this. If we gave access by mistake for all, or want to change an no access to a has access, i have to go into 17 sheets and locate the row and change. Could a macro do this based on the...

Hi, I have a data set with four columns (A,B,C,D) having a different style of data in each column. I want to combine these four columns in column E while preserving the format of each cell (for example, cell C is italic while rest are normal). Can anyone help please ...

Greetings, I am a facility manger who is really in need of something that will work...I've tried IF statements, ARRAYs, but so far VBA has gotten me the furthest. Can anyone please assist with code for a bed management system. nothing too complex, 143 bed facility. bed numbers remain the same...

Hi, need to automize the description based 3 criteria. - Personnel number (#3 and #4 are letters short for department) - Personnel code (random) - Appointed period would like to have the description within such format: e.g:Finance_Department_01.01- 01.07.2012_PN_876789 (Indicated in red)...

Hi everyone, I am trying to get the following macro to work. The first tab has a column (F17:F2000) with hyperlinks that return the value on the cell thats clicked. When a user click the cell F17. It will return the value on that cell (User ID) to another cell. The worksheet has a large...

I need help on removing sections of text out of a huge workbook I'm building. For example, it currently reads this in one of them (they all follow the same pattern): • Examine: Access control policy; procedures addressing account management; security plan; system design documentation; system...