create

Hi, I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities. Thanks in advance. Regards, Hiten

Hi, I'm looking for the most efficient solution to this problem... I have a workbook with 30+ tabs that contains stock items, supplier codes and their prices (6 suppliers per tab). I trying to create a new workbook that mirrors the former (data and format) but without the prices. I've no...

I’m trying to create CSV file with 52 columns. There is only data in field 1 and 8. There are no column headers and The problem I’m finding is after collimate there are no commas how do I create them please

Hi, can anybody help me do the following? Write a VBA function that changes the cell value of E3. Create a button on sheet 4 to increase the value by 1. Name this button "Higher". Then create a button below it that will decrease the number by 1 and name it "Lower". Save the function so we can...

Hello everyone! I have a VBA question on how to create a macro that will copy/paste names to specific worksheets if conditions are met. I get new data each month so this will be very helpful for me if it's automated. The data is 91 rows (90 reports) so this is just an example. The idea is that...

Hello, I am trying to create a worksheet with a timetable and some time slot needs some action and the detail of the actions needed to be entered. Can i create a form that takes input and store it as a comment and when the cell is selected the pop-up/window can displays the comment in a...

Hi, I have tried to find an answer to this but to no avail. I am trying to condense a full list of values into ranges (and there isn't necessarily a pattern). E.g. <tbody> Column 1 Column 2 1 1 2 1 3 1 4 2 5 2 6 3 7 3 8 3 9 4 </tbody> Would become: <tbody> Column 1...

Right now I have a data A1:A100 each cell is 500 So my range called RangeA is A1:A100 Can I do without need to have this list in this 100 rows Now I key in, B1=500, C1=100 How can I create RangeA based on these two cell values ?

Hi all Master of VBA I hope you can help me for the issue below. I tried several ways in my ability but it still doesn't resolve I have two ranges (1 row and unknown number of column) same size. We can call them is range1 & range2. For example: Range1 =...

I have a file that I was assisted on by Fluff in the past. I am looking for a little bit of help. The macro that was created works perfectly and will split one table out into several tabs based on a specific name. What I need to do now is create an additional macro to create a completely...

Some Helpful advice please. Imagine a collection of 10 items (First to Tenth) each item comes in one of 10 possible colours. So to collect them all I need all 100. Now I can create a table with the numbers as column titles and the colours as the row title which would allow me to tick off as I...

How do i create my own formula using excel?

I am trying to figure out to have two cells increment after creating a record with my user form. My form is simple where I have a button that will create a row every time it is clicked. After clicking the close button the data will sort from highest to lowest trace number. Lets say for example...

Hi all, I try to understand why when I create a graph, for the series value and I put the formula ='VBA1.xlsx'!value With VBA1 the name of the workbook and ''value'' that refers to a formula in the name manager of EXCEL Why it works for a workbook I have downloaded from Internet, and why...

I have a workbook with multiple sheets, on one sheet I have a column with sheet names and the second with cell address example A2 = CONTROL ROOM AE5 B2= $C$4 How can I create a hyperlink that goes to the value in A2 (sheet name) and B2 (cell). Thanks in advance..

Hello I'm trying to create a work sheet but im stuck on the formula im trying to get my value from H10 which = 2 my cell my formula goes in is I10 my date is in I7 End date is in F10 can I create a formula thats in I10 that looks at a date in I7 and if its less than the date in F10 places a...

Hi All, Just wondered if it was possible to create a button in access using a jpeg ?

Every year, in June, I create a new workbook from the current workbook. I have a macro the does all that and I put a button on the current workbook to run it, but I want to hide it until Jun, so no one will hit it mistake. Can that be done?

I have a workbook with VBA built in, built in Excel 2016, that is not working on the Mac version of Excel 2016... Public Sub GenerateContact() Dim wsA As Worksheet Dim wbA As Workbook Dim strTime As String Dim strName As String Dim strPath As String Dim strClient As String Dim strFile As...

I have a sheet in a workbook that carries out multiple checks on each of the other sheets in the workbook, looking at the same cells on each. So far the developer has manually written each check, such as IF('Sheet1'!A1=TRUE,1,0). However, there are 100+ sheets with 5 checks for each. I have...