admin

I suppose this is the right forum for this topic, my apologies If I am mistaken. The story (introduction) Time came for some colleagues at work to get new computers. WinXP was obsolete by far. A new PC arrived with its own HDD and a not so old OS. The issue is: to transfer the files from the...

Hello , I have an excel file which is the source document and I have other excel files which are destination files all in one location. - I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY. - Check if column A has the word 'SIGNAPAY' , - If true then...

Hi there, Sorry to bother you but I was wondering if any Excel experts could give some guidance on a VLookup question? I am trying to look-up two combined records. I have a sheet with Entity 1, Entity 2, Entity 3 as columns, then as rows (headers) I have departments (Accounts, HR, Admin). I...

Hi ...My excel have multiple sheets as below: 1) Master Data 2) Region A 3) Region B 4) Region C 5) Region D I need to have a VBA coding that will COPY entire row automatically into a respective sheet if the cell value match according to the "REGION". Whenever changes was made in the Master...

Hi Everyone, I have a problem with dropbox we have a number of users that have access to my dropbox account but i'm getting problems with them opening other documents in dropbox using VBA with my filepath. the code " Environ$("UserProfile")" and the first part "Fold1 = "Dropbox (ALL)" " work...

Hello. I have an 2003 access database (mdb file) with all tables having Unknown as owner except one table which has Admin as owner. Is there a way I can use VBA to transfer tables ownership from unknown back to Admin?

I have a workbook with about 16 admin and finance sheets. Then the rest of sheets contain the data for each job, like job cards. These sheets are coloured blue and the admin sheets are coloured green. I have been asked to create another admin sheet with a dynamic list of sheet names with...

:confused: Hello All, I have a VBA that will save the current workbook to a folder for the current year and month. It will first check to see if the folder already exists and if it doesn't it will create it prior to saving. My problem is that I created my folder structure using the month...

Hi Expert, I am new in a Excel. I have created a trainee project for my learning and which is attaching hear. In my project all are okey, but i don't want to show any work sheet in this excel, is it possible? if possible please instruct how can i do this. please note that UserForm1 and...

Hi all I have a spreadsheet with over 5000 records however I need to do very little with some of them so I am looking for a VBA to do a lot of my work for me. I have made a start but with little success. Basically, I want to run the VBA to take the following actions: 1. Delete Rows if Column F...

Hello, I'm doing a template to check availability and coordinate common slots for 3 different groups of officers (admin, relationship and finance). So I have a template that has a list of dates (B1 to V1) and with the list of officers (admin: A2 to A6, relationship: A7-A12 and finance A13-18)...

I've been driving myself crazy this morning trying to make this work, but I know someone here can point me in the right direction. I have some premiums collected sorted by month received on the horizontal axis and three breakdowns for the premium in column D. I would like to sum these for each...

Hi All I have Log In Security within a Workbook which is activated by Clicking a button [CommandButton2]. However, what I need is, if a User clicks the other button [CommandButton1] then it will open the workbook and all sheets [except Admin & Lists] so they can view the content. I cannot work...

Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...

Hi i need help. I have create workbook that has a userform. I have users and admin accounts. However with the user accounts they are still able to copy/delete worksheets. Is it possible to make these options only available for my admin accounts? I have looked at protecting the workbooks...

Hi Forum I am try to set up a spreadsheet to count our team's training records. On sheet 1 - I have the data in 4 columns as below <tbody> Date Role Staff Member Name Training (mins) 21/09/2018 Admin Staff 1 20 21/09/2018 Technical Staff 2 120 01/10/2018 Admin Staff 3 30 </tbody> On...

I am trying to create a filtering scenrio. Ex. The value of Sheet1 in cell A2 is username "Admin", if that happens all Username with admin in Sheet2 will be filtered from the table of raw data.

I am very new to vba and some help creating a code. I need to cut each unique Name record and paste it into it's own new sheet. I tried to find an existing code but had no luck. Can someone help me with this? <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> Name...

so a while back a very knowledgeable user DMT32 helped me update his macro to meet my needs and all of a sudden it started having issues. Works great for users defined as admin but everyone else gets a Subscript out of range error. The Macro does do what its supposed to do, but the error...

I need to sum data for each department. This seems simple but my data's columns are not always in the same order. I'm sure there is a way to find the 'department column in an array then find the wages column and sum particular department names. It just needs to work with dynamic data. <tbody>...