user

Hello, Still new to excel and needing a little help. I have a workbook that i need to have the user save weekly into their archive folder located within the same folder the workbook is held, however the file path changes depending on the user. I know i had it close as i can get it to save into...

wonder if anyone has a fix for this problem. it is not related to actual calculation time as the effect occurs even with a new blank sheet. I will do my best to explain and hope someone has come across the problem as well. With a new and blank sheet changing from Automatic to manual causes...

I have created an overview sheet for a project where I also want the user to include a map of the location. The map should go in a special place of the overview (certain cells or a shape) and preferably look nice. Some user will have very limited experience. I have found that you could fill a...

how to avoid a user to input text in my dropdown.. all I want is to let the user choose on my items in dropdown list and avoid the user to input text that are not belong to my items in dropdown list

hi all, any idea on what's wrong with my formula below, i cant return Khloe Kung result same as others user with same formula.? what should i amend and fix my issue? thanks all

Hi I want to find how many hours a user worked. The start time was A1= 10:00 pm and shift finished B1=1:00 am, so this user worked 3 hrs, so when I did C1 = 24 * (B1-A1) I got ################....... How that can be fixed. Thank you very much

Hi I work at a company with a "Shared" drive, however, any files saved on to this drive by a user are owned by that user and it means nobody else (with their own respective logins) can then open the file in NON Read-Only mode. It always opens the file in Read Only. Is there any way within VBA...

Hello, I've below two sets of data in different excel sheets 1) Training data - it contains User ID, Training Start date and Training Due date 2) Leave data - it contains User ID, Leave Start date and Leave End date User can have multiple training which are assigned through out the year and...

I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user. My data has User name Time landed on the page Any Links clicked on the page As I have the time the user landed on the page via the link clicked I need...

Hi There Good Morning Need a formula that only show the set cost figure once for eachunique User Id I am looking for a formula that give me the result in ColumnC, The formula needs to only count the set cost figure that doesn’t change (ColumnB) for the user ID (Column A) just once ...

Hi, I have created a workbook with some code running on each sheet. The code allows a user to select multiple items from a drop down list (rather than only one as allowed by "Data Validation" too)l. If I select some of the data on one of the sheets (for one user for example) and move it to a new...

I need two Formulas to help me display the cost in Power Bi: one for total cost and one for single cost: Formula One Request: I need it to add up thetotal cost of services (column C) per user (column B). Example, User ID A230would be £180 and User id F222 wouldbe £60. Formula Two Request...

I have a userform that the user will pick from the combo box list and then enter in a value in a textbox 1. Once the user clicks the OK command button I would like it to search the combo box value in column A on Sheet1 and place the value from textbox 1 in the next available row below in column...

Hi all, I've built a VBA macro within a .xlsm file, but I want to make the user interface look a little more professional - at the moment, when the user opens the file they see a standard Excel blank workbook with a large 'Start' button in the middle of it (not very subtle). Is it possible to...

Hi I know how to protect workbook in vba using workbooks(1).protect workbooks(1).unprotect What I want to do is to ask user this question: do you want to protect workbooks? yes/no If user say yes then I do wrokbooks(1).protect If user say no then I do workbooks(1).unprotect Any idea how...

Hello all! I don't have any sample data to upload at the moment but the question is fairly straightforward I believe. I put a table below to help visualize what I'm looking for. I have one worksheet with many ranges of the same size and I need a way to move one range to another range with a...

I have a userform that has a combo box (cboEmployee). This combo box is a drop down list of employees the user will pick from. Then there's a text box (Textbox1) the user will enter data in. There are 5 tabs representing each day of the week (Monday...Tuesday...Wednesday an so on). Each day...

Hi, I have a macro which is used by different users, has been working for years with no issues but now, due to an IT change, different users have been given different network addresses which I can't get to be changed so all have the same path. In order for the code to run for all users, One...

Hello all, can you help please, I have inherited a workbook to look after, it has a sheet called “TIMESHEET” and one called” FINGER PRINT LOOKUP” first on has the following columns, date, user id, and finger print hours worked. last sheet records user id, in, out, and total time. (there are...

I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name. Would I use a user form or formula...