in cell A1 I have a ref no. eg aa/01/bb
in cell A2 I have a ref no. eg aa/02/bb
only the middle number increases in the reference each time eg: /01/
is there a formula that can achieve this or am i doomed to manual input, I have made a few attempts but cannot work it out.
I have to reference to another sheet a fixed increase of moving 6 rows across. What would be the formula for it?
For example.
First formula would be =Sheet1!A1
What would be the formula for the subsequent cells. (eg. =Sheet1!A1+6) obviously doesn't work.
i'm looking for a loop macro to perform the following task:
Sheet 2 is my look up table, and sheet 1 as a number of references such as:
='Sheet 2'!B1
='Sheet 2'!E1
='Sheet 2'!G1 etc
I need a macro that increases the row references "1" to "2", saves the sheet then increases "2" to "3" and so on until the bottom of the reference table is reached
formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.
View 10 Replies View Relatedwhat i need is a macro to run when I print a form. I am making a job card with a unique number on it ie: 100. when I print the form, I then need the 100 to change to 101 and so on. I cant work this one out.
EDIT - Ive attached my work in progress. It is for a computer repair shop. I have a few macros in there as I need to email a copy of the workbook too.
when you open the workbook, you will see the job number in red. I just need a macro tht will increase that number +1 every time it runs. I also need the email macro to rename the workbook to the customer name input in cell B4 - but I think im best to post this request in a new thread?
I have data to find standard deviation from a1:a5
So use a formulae to do the same.
I want to increase range automatically when i put a number in a6 and so on.
writing a formula for the situation below,
In column "A1" i have the formula =C8. I now need to copy this formula across to column "B1" to get =C9 and also copy it across to column "C1" to read =C10.
So the row number should be increasing by 1 and the column remanin constant.
I need to be able to select a certain number (from, say, 1-20) from a drop down menu, which will decide a number of rows (filled with data) on the next sheet. As I prefer not to give anyone the sheet I'm actually working on I made a quick look-a-like which might explain this better.
A and B are different scenarios, with different values in the fake drop-down menu I made. Just to pass on the understanding of what I want the values to do. If putting a drop-down menu there is troublesome, then I can live without them. But entering a certain value in the field and getting that number of rows for a certain product is what I need. I tried searching for a function/macro to use for this, but I dont know what exactly to look for. Name, etc
I created an receipt template in excel. How can I have it increase the receipt invoice number by 1 every time I open this template? For example the first receipt is 100, I want the second receipt to be 101, and so on.
View 4 Replies View RelatedHow can i format my excel spreadsheet cell so that a number
10,000,000
displays as
10
I am trying to write a program that needs to select a different cell everytime it is ran. For example, this month when it runs I need it to select cell BL137. Next time it is ran it will need to select cell BL138. Month after BL139. The cell it selects will always be in the same column (column BL) and the cell number always increases by the same amount (1).
View 6 Replies View RelatedI have set the check boxes for each line. I would like to have the today date to appear after clicking the check box on the next right cell. Do I have to use IF for this one?
ALSO I want the number to count up after click the check box. For example:
Name:
Bob (assigned)- 5
(completed)- 4
Every number of completed line increases every time each box is clicked. How can I do that?
I have a macro that increase a cell number and one that decreases a cell number, heres my code:
Code:
Sub Macro1()
Dim t
t = Split(Worksheets("Sheet1").Range("d5").Text, "/")
t(0) = Format(t(0) + 1, "0")
Worksheets("Sheet1").Range("d5") = Join(t, "/")
[Code] .......
So they do exactly what i want them to do but i want to put a limitation on them, so say the number in the cell is 0 then i dont want it to be able to subtract from it anymore, and say the number is 20 i dont want it to be able to add any more, i tried to put if statments into the code but no luck.
I have many data in a worksheet named "Table" with "Item" in column A and "Reference" in column B. For each change of item, I need to assign a reference number with a prefix. Below is a sample of the data.
Column A Column B
Item Reference
Orange R9
Orange R9
Orange R9
Apple R10
Apple R10
Apple R10
Mango R11
Mango R11
The starting reference number is not fixed. It could start from 8 or 10.
Thought it would be possible to automate this process using vba.
I have multiple worksheets (too many, actually!) and each worksheet is a record. I need to enter a Record Number into B5 of each sheet. The Record Number doesn't start at 1. I'd like to enter a number into the first sheet and the rest of the sheets to increase by 1. However, I only need to do this to some sheets.
View 9 Replies View RelatedI have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.
View 2 Replies View RelatedCan you increase the number of fields shown in the list so that you don't have to scroll through the entire list?
View 2 Replies View RelatedIs there any keyboard shortcut to increase or decrease the number of decimals shown directly (I mean without having to use ctrl + 1... etc )
View 7 Replies View RelatedI am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.
The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.
I need an OFFSET function to start off by moving down 1 row from the starting point and then on the next run through the loop, to move down 2 rows, then 3 rows, etc.
Code:
Workbooks(Thisname).Worksheets("Run Set Up").Range("Duration").Offset(1, 0).Value = Workbooks(Filename2).Worksheets("Front Page").Range("T20").Value
This is what I'm working with. At the moment, I have the value for the number of rows to move set to 1 because I can't figure out how I'd accomplsih what I need.
Our business has a spreadsheet set up for invoicing. A Macro has been created to increase the invoice number, save to the desktop as a PDF with a file name taken from the cells
This is working on my colleagues mac but when we've loaded onto my computer it errors, when I debug I am getting the following error:
Sub Macro3()
'
' Macro3 Macro
'
'
Range("g10").Select
[g10] = [g10] + 1
[Code] .......
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies View RelatedHow increase Sheets number+1 for all Sheets with Vba?
View 10 Replies View RelatedI am working on a data with a range of same customer number but different sales figure. If there any way I can search for a duplicate cusomer number and then summing up the sales? I tried to use vlookup but it only recognise the first reference number. I have attached the excel for your reference.
View 3 Replies View RelatedI'm wanting some sort of formula to generate a reference number that relates to numbers i put in a cell. i want the end result to look something like this:
Reference number
362 3620001
456 4560001
362 3620002
487 4870001
456 4540002
As you can see id like it to generate a reference number to the number that i input, and also when i input that number twice or three times it picks that up on the reference number also.
I am running an ordering sheet that I need to attach reference numbers to, no format for the reference number has been determined.as yet. I need this reference number to change when the 5 digit number changes, see example attached.
Capture.jpg
I am just wondering if there is a way i can search an excel workbook for a particular reference number. eg
name reference money
dave 60056835 £20.00
clare 50065755 £30.00
If i want to search for Ref 60058635 i just want to type it in and excel will the search the workbook and direct me to the correct page and column.
I need to find a formula that will find letters in a referance, for example i have referances like - MNE DJM & ZZPAR i need to find a formula that will find me the ZZPAR looking for "ZZ" i then want this to tell me what tpYe of referance number it is and put this into column Z.
Normal referance number like DJM and MNE i want this to show as "BROMLEY"
aND ZZPAR as "Chester"
I have tried something like the following but this is not working
I have a row of data I want to be blacked out if there isnt a reference number in the first column
So if I type the reference number i can in theory then use the rest of the row but if there is no reference number in the first column i cant see any of the row ...
my excel file have 5 sheets (may be more than 4) ,sheet 1,2,3,4... and the sheet name (all serch data) .
in sheet 1 ,sheet 2, sheet3,sheet4..... incell a3 is the number for reference . in sheet (all sech data ). i create the macro button and the range (n) of this sheet ,when i key the reference number to the sheet1-sheet4 .
if ,it is the same number to the sheet 1-sheet 4. it will copy the data of that sheets paste to the sheet (all sech data ). if it found the same reference number.
i attach with the file to see ,how can i do for macro copy code?