If Then Else Not Continuing.
Sep 23, 2009If Then Else not continuing. What is wrong with
View 5 RepliesIf Then Else not continuing. What is wrong with
View 5 RepliesFrom cell A1 to A10 I have the figure 5412587
In cell B1 I want the figure in Cell A1 to concatenate with the figure one but in cell B2 instead of figure one with figure two etc. etc.
So B1 will be 54125871, B2 54125872, B3 54125873 etc. etc.
the formula would be Concatenate(A1&1). I want the "one" in this formula to be increasing so in B2 will be Concatenate(B1&2) et.c etc.
The problem is that I dont want to add an extra column to replace the 1, 2, 3 etc. in the formula.
I have an Excel 2007 Workbook that is used to do a variety of different reports. Each spreadsheet within this Workbook is a different report. All reports need the same Header format that is linked with new data that is entered with each new report. The reason I need a header is because each report may vary in size from 1 page to 6 pages, it all depends on how much is reported on and a single completed report will use a combination of other reports.
Here below is a format that I am trying to achieve
(Linked Data) ‘Employee names located top center
Date: (Linked Data) ‘With Date: texted before link, located left index
Address: (Linked Data) ‘With Address: texted before link, located left index
Or should I just use
=Sheet1!A1:C1
On Sheet1 as source to other sheets, but if I do this how do I use this like a header for continuing pages
so on sheet 1 i have a list in column b (as below) and in column G I want to put a note "not included" if the cell matches what is in sheet 2:
AAA
BBB
CCC
DDD
EEE
On sheet 2, column A I have a list of items that I want to not include which I want to be able to add/remove/adjust over time. For example:
DDD
EEE
FFF
LLL
I can get it to put in the correct text into sheet 1 with the following but I don't know how to get it to look through all values on sheet 2 and then only enter the "not included" on sheet 1 if it is listed on sheet 2.
So far I have
Sub checksheet()
For Row = 1 To 428
For col = 2 To 256
[Code]....
This only does it for what is written in cell A3 on sheet 2 and does not keep going down the list in sheet 2.
I think I need to define the range better on sheet 2 and ask it to look through that, but im not too sure.
IF(A1=1400,(AVERAGE(A1:A2)),"")
Placed in column B.
This formula will do what I want, but 1400 may show up 5 times in 20,000 rows. You can change them to values and delete the blanks to move them up where you can see them.
1. That is more time.
2. This is living data changing all the time, so I need the formulas to remain.
Is there a formula that will place each event under the previous in the column B? The first event in B1, second B2, third B3, and etc.
I have a layout for printing as attached. This is a front carton label. Depends on the carton qty, I need to print many times of those pages whether changing the carton times before every print out. For instance I print from 1 to 550. Each time I modify the carton numbers and printing it, that means 250 print job! I want Excel prints all(between) pages with given first and last carton numbers , is there a way to do it?
View 4 Replies View RelatedIm looking to ensure the sheet contents are clear before continuing with the macro routine. At the moment however, the macro runs I see the data flash up and then off. So it appears the data is being cleared as soon as it loads. Current code is:
View 2 Replies View RelatedI'm trying to write some code that will check if specific files in a folder are present before continuing code.
I've looked on-line and found various code that checks if a single file is present whereas my requirement is slightly more demanding.
Some files might be present and others not. The code must check ALL necessary files are there then run main code. If even any single file from say 5 files is missing, code must exit.
I was thinking of using an array to store all files names and then use a "For Each XX In XX" to loop through the array and check each file is present?
This is what I have so far:
Sub XX()
Dim strPath As String, LinesDelete As String, Applepnfile As String, MpnStock As String
Dim myArray() As Variant, myElement As Variant
Dim myArray() As Variant, myElement As Variant
strPath = "Z:AppleApple Deliverys"
[Code] .........
I want to make continuing serial numbers in excel in order to print labels to be able to track my deliveries. i know i can drag the fill cursor to automatically make it go the next number. however i also want my serial number should represent the month and the day the invoice was printed.
for example i want the serial number should be
column a (Jan 01) column b (Jan 02 ) column c (Jan 03)
a1-01-01 a1-02-01 a1-03-01
a1-01-02 a1-02-02 a1-03-02
a1-01-03 a1-02-03 a1-03-02
The first number represents the month (example -a1 for Jan)
The second number represents the day and
The third number represents the invoice
How can i make that when i pul the cursor down it should continue with the invoice number
However when i continue right it should move the day number?
Basically, in the "Thisworkbook" code , i have some code in the Workbook_BeforeClose section. Currently , it autosaves the workbook in a folder i have specified.
However, i need to add some code.I want to check that a certain cell has a value in it before the user closes the workbook, and if the cell is empty, show a messagebox asking him to enter a value.
I know how to get a messagebox to pop up, the only thing is once the user clicks the OK button,
i need the rest of the code execution to pause, allowing him to make the change then if he clicks the "X" (top right of the screen) to close the file or application, the filesave dialog appears and he can then save the document.
how to go about this because at the moment when user clicks ok, the messagebox just disappears and filesave dialog appears and he doesn't have a chance to edit the cell.