system

Hi all, I am trying to send multiple sections of my userform as email the current code I am using (below) works but if I try and add more code in to add say SYSTEM 2 DETAILS it would no longer show SYSTEM 1 DETAILS on the email and just the latter. Private Sub CommandButton1_Click() Dim...

My Google Chrome crashed on Wednesday. I can' start Chrome, I get the aw-snap not enough memory message. I can't access office 365 - I tried to reinstall it and I get an error message about a storage dll missing. Yet, I get the message that everything is installed and ready to go. Or, if I try...

I need to change my ERP system to a serialized inventory system, i have list of products and their total quantity. all i am trying to do is take a product and if the total quantity is 10, create 10 records so i can assign a unique number to each product. Example of data i have: <tbody> 2018...

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...

I am create a excel with using of multiple font , but client dont have the same font in their system, can i save this file with Font as well, or can i lock cell with font remain same, at the client system.

Dear all, I need a formula to search Col C for "6-Kadobon-Behandeling", and if found, copy the amount on the same row in Col H into Cell H10, but then as a negative. The data is exported as CSV from a POS system and needs to be converted and imported into a digital accounting system which...

Hi I have alot of data, that i need to convert. <tbody> value in system new value (the formula that i need) 8726,36 9000 8971,84 9000 56724,62 57000 7000,1 9000 846618,09 847000 </tbody> what i got so fare is =ROUNDUP(ODD((ROUNDUP(R3;-3)));-3) but it doesnt work i need the...

I currently have a template which I can upload onto our database system. This template is filled in with sales data across consistent products. The caveat is that the data that we receive from 3rd parties to put into the DB system can be in many formats e.g. Excel but worded differently, or in...

Hi, please forgive me if this question has been asked but for the life of me I cannot figure out how to do this. I have a list of work hours that our timekeeping system posts in decimals and fractions of hours. For example, if someone worked 5 hours and 45 minutes, the system writes it as 5.75...

Hi, Opened a spreadsheet relating to room accommodation for my son on a school trip and a new drop down menu appeared in the toolbar entitles 'system'. I assume it relates to Visual Basic and some macro. However, the spreadsheet does not appear to have any macros and as I have no access to the...

Hello everyone I need a meeting request system. I've tried myself, but at this point I might need a little help from the community as I'm not an expert at all. The basic idea is as follows: 1. A bunch of command buttons in an excel sheet (setup by time, day and meeting room), and when clicked...

So I made a worksheet, and want to start selling it. The thing is, I want to make a login system, making a login system is simple, but the one I want to make an online login system for my sheet, so there can be only 1 user at a time loged in it for a specific login. Is there a tutorial on how...

I have made a excel workbook with at couple og VBA and userforms. On my computer the workbook works completly fine, when i send the workbook to some of my colleagues it shows this failure: System Error &H8000FFFF (-21474181113) catastrophic error Out of memory Does anybody have a clue whats...

The code below (1) locates the Temp folder on the user's system, and (2) exports the print range of a worksheet to a JPG image, then saves the image to the Temp folder. The code works exactly as intended on my own system. On the user's system a JPG image is generated and saved, but the image...

Hello, I have following system for updating contracts and their prices: <tbody> Portfolio Service Start End Monthly cost (Period 1: 1.4.2016-30.3.2017) Monthly cost (Period 1: 1.4.2017-30.3.2018) Portfolio 1 Service 1 1.5.2016 100 € 200 € Portfolio 3 Service 2 1.7.2016 1.8.2017 300 € 200...

Hello, I have a table of data related to an invoice approval workflow where I would like to evaluate each invoice (request key) for the appropriate approver. Unfortunately, the workflow software doesn't store the final approver in a field, so we have to apply logic to the workflow data to...

I have been tasked with creating an Excel sheet to rank employees for annual leave pick priority. The issue I am having is trying to meet specific criteria since we have two groups of individuals, military and civilian, and each team has three subgroups, crew chiefs, driver/operators, and...

I have a master sheet which has different build ups of roofing system. I would like to be able to (select or type) the system in column B of a separate workbook and the have Column C autofill with the components (this can be anything from 1 to 10 rows) hen have a blank row and continue with...

i have one user form,it have Label1 I want to link my Label1 with "user administrator name" i mean "windows user name" can we get it automatically when userform pop up