user defined

I have a code that creates a new folder to a specific pathway but the issue is now we need to be able to allow the user to define the pathway (location changes weekly and by user). I can't figure out how to get it to allow me to let the user pick where to create the folder. Current Code: Sub...

Hello all, I have been working on this code to 1. let user pick file 2. copy all cells that contain data on sheet 1, 2, 3, 4 and over 30 3. paste into first blank row of source workbook on Sheet 4 For some reason this seems to only paste one cell into "A" on sheet 4 on the first blank row of...

Hi I am trying to plot a chart taking data from a single column on another sheet. On the same row as the data item is a date. The user inputs (on the chart sheet) a 'date from' (F3)and a 'date to' (G3)and I want the chart to display only the data between those two input dates. So in the...

Good morning! I created a friendly user dashboard (pivot tables and graphs) based off of millions of rows in power query. My table in power query has the entire universe of data, so when users try to filter for a particular category in the pivot table of the dashboard, they see the entire...

Hello, I have a PC, Windows 7, and Excel 2013. This is my first time working with a UDF, and I'm sure I've done something wrong... but I have no clue what. The function is supposed to take 3 cells, Year, Job Type, and Margin, and based on the three criteria, the output should be the proper IC...

Dear all, I would like to insert the following function in my VBA, but I have no idea if it is even possible, since I just started with VBA. I would like to prompt a message box (or similar) so that the user could insert the "Initial number", the "final number" and the "step". Then, the VBA...

Morning All Below is the code I am using to return the full name of the current PC user. I am using this in a selection of workbooks to create user logs, track behavior and speed up data entry. In one project I would like to get the value for the user Login (not name). This is the initial ID...

I use these two UDFS to find the differences between two strings of text, i would be great if they were case insensitive. If anyone knows how to change these ones or has a better UDF for comparing two text strings ( like with options for choosing different / multiple seperators etc that would...

I have a macro that requests the user to input a date. This variable is then used within a filter to select the dates required. The date is entered in UK format and the variable is showing in the Locals window just how the user is inputting the data - as you'd expect. Here's where it gets a...

What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA, please post the code. Thanks.

I need a VBA macro that will unprotect the worksheet with password prompt the user for one field to sort ascending or descending sort the worksheet protect the worksheet with password exit The worksheet has many calculation fields that are locked and not selectable but a locked field may be...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Using Excel VBA I am looking to automate a basic Copy and Paste routine which amounts to little more than copying row 3 and then pasting it in the next blank row below.<o:p></o:p> <o:p> </o:p>...

Dear Excel Experts- We use SAP system and whenever I copy any data (from SAP) and paste it to excel, it paste it in following format (which is incompatible to sum): 1,468.98 29,463.83 2,281.10- 12,684.40- 64,254.04- So this causes us manually to change it to: 1,468.98 29,463.83...

how can i use sendmail where i want the user to type the email address they wish to send the workbook to? if i do it via a form, what will the code be for the send button as the sendmail code i have at the moment is the one where you have to type in the email addresses in the actual code...

Is there any way to block editing cells or columns for certain users? Let's say i want: John to edit column A Peter to edit Column B Peter and John column C. Is this possible? I don't know the information they are entering, so i can't restrict the content, but want to restrict the lines they...

I'm just getting into functions, so please bear with me on this as I start to understand how they really work. I do have the VBA and Macros for MS Excel book which has been a great help! Normally on this I would use a simple array formula to gather a total calculation from a timesheet, but in...