I have a 'Customer Quote' template form which requires a new number every time it gets saved, this will need to be a 'read only' file.
Can I also have it auto name itself this consecutive number automatically every time it is 'saved as'.
I have Excel 2000.
If I have columns A B C D E how do I copy A and C only (at the same time) and paste them into a new workbook? I get a popup saying it's not possible.
I don't want to copy one column at a time in case I make a mistake and item 1 in column A no longer lines up with item 1 in column C (I'll be performing this at least daily and the results will go on a website)
I have a form that I use often, but numbering is slow because I go in and number the form, print, go back and put in next number, print, etc. Is there a macro or formula that will automatically update the consecutive numbers when I enter or print?
View 13 Replies View RelatedI have a spreadsheet that imports data, manipulates it then deletes 2 of the sheets then saves the file under a different name to the network. Is there any way to save this new worksheet without it storing the macros - so when the user open it, only the data is there and they get no prompt to enable macros?
View 6 Replies View RelatedI am trying to do a column full of Month,Year dates in consecutive order (i.e. Jan 14, Feb 14, Mar 14, Apr 14, May 14.)
View 1 Replies View RelatedI have numerous spreadsheets that I need to open and unhide a sheet, that has XML data stored in cell A1. What I need to do is copy that data in cell A1 and paste it into a text document and save that as an XML file saved as the XLS workbook name with a date stamp.
I'm running into many issues, the main issue is the saving as current file name, and the formatting of the text/XML file.
Here is my current code, which doesn't reference the current file name and is just very generic. Once I get the saving as file-name correct and the formatting of the xml file correct, I will work on it a bit more.
Code:
Sub Test()
Dim Rng As Range
Dim wb As Workbook
Set Rng = Range("A1:A2")
Set wb = Workbooks.Add
With wb
Rng.Copy
[code]....
I have 3 columns, in column 1 and 2 there will be numbers and I want automatically to get in column 3 the range of numbers between Column 1 and Column 2
Column 1 - 100
Column 2 - 500
Column 3 - 100, 101, 102, ..., 500
I am setting up a "save as" macro that saves a file by replacing another file in a folder. Even though the macro has been recorded by approving the replacement (the prompt appears "the file --- already exists. Do you want to replace the existing file?"), when I run the macro, I am again prompted about replacing the file. Is it possible to avoid the prompt so the file is automatically saved by replacing the named file?
View 9 Replies View RelatedI was wondering if there is a way to write a macro that will take an excel file that I have called Alldata and then have it copy the first two sheets to a new workbook named something else( FullSparameter_0) and then copy the name of the third and fourth sheet into the new FullSparameter_0 workbook and then copy column A-E from sheet dB Alldata.xls and paste it into the FullSparameter_0.xls workbook in the same dB sheet in the same spot. And do the same thing with the Phase Sheet. i know this sounds confusing, but im really new to the VBA stuff.
I just need 15 different files from the original Alldata.xls that will be named FullSparameter_0, FullSparameter_1, .., FullSparameter_14. but each file will have the same two first sheets, Setup Information and Cal Verification, and the same last two sheet names, dB and Phase, but then in the dB and phase sheets, it will copy over the next four columns of data. so in FullSparameter_0 it will have column A-E from sheet dB in Alldata.xls in the dB sheet in FullSparameter_0 (Same with the Phase Sheets). Then in FullSparameter_1 it will have column A and Columns F,G,H and I (for dB and Phase). In fullSparameter_2 it will have column A and then J,K,L and M. Each FullSparameter_X will have the exact same first two sheets and then the other columns for the last two sheets will be pasted into columns A-E in dB and Phase.
found the following code which works for 1 workbook at a time. I am trying to save 7 workbooks at 1 time. Is it possible?
Sub SaveAsCell()
Dim strName As String
On Error Goto InvalidName
strName = Sheet1. Range("V77")
ActiveWorkbook.SaveAs strName
It will work on the first sheet but none after that. I need to have each workbook saved with the value in cell V77. Also if that is possible, is it possible to change where the file is saved as well?
Right now I have a master workbook that will open the 7 other workbooks, paste data onto several pages in each workbook. I would like the macro to save the workbooks. The workbooks are named: 02 Tuesday, 03 Wednesday, 04 Thursday, 05 Friday, 06 Saturday, 07 Sunday, 08 Monday.
I have a daily column of numbers of approx 600 rows and the number is either a 0 or 1 and the 0 or 1 are in a random order in each row like:
1
1
1
0
1
0
0
0
1
0
0
1
I would like to find the min number of rows with 1, the max number of rows with 1, the totals of consecutive rows with 1 ie 3 consecutive rows of 1 appear 4 times, 4 consecutive rows appear 6 times etc and the average of the consecutive rows with 1.
i have a list of numbers in a column, and i have sorted it smallest to largest, now i wish to identify which ones are consecutive in the column.
5184730512
5184730547
5184730763
5184730766
5184730767
5184730836
5184731135
5184731136
5184731149
5184731212
5184731222
5184731389
with this Excel problem? I have a set of data of 300 some odd rows of numbers. I need to find 24 CONSECUTIVE values that add up to the HIGHEST sum? For instance,
2
2
0
0
4
2
0
0
1
8
5
2
I have a daily column of numbers of approx 600 rows and the number is either a 0 or 1 and the 0 or 1 are in a random order in each row like;
1
1
1
0
1
0
0
0
1
0
0
1
I would like to find the min number of rows with 1, the max number of rows with 1, the totals of consecutive rows with 1 ie 3 consecutive rows of 1 appear 4 times, 4 consecutive rows appear 6 times etc and the average of the consecutive rows with 1.
I am preparing a attendance sheet. I am using 1 & 0 for present(=1) & absent(=0). I want to find out if a student has been absent for three consecutive days and if there is three consecutive 0 then the formula should return the value 0 ( the student gets 0 if he is absent for 3 consecutive days ) otherwise it should add all the 1s in the row. i.e
1 1 1 0 0 1 1 0 = 5
10 0 0 1 1 0 0 = 0
if someone would review the code below and tell me why it does not cycle an autosave more than once. It is supposed to autosave automatically every five minutes but for some reason beyond me it does not. I did not author this but picked it up in a different forum.
Option Explicit
Public vartimer As Variant
Const TimeOut = 1 'set in minutes to whatever amount of time is desired
Sub Timer()
vartimer = Format(Now + TimeSerial(0, TimeOut, 0), "hh:mm:ss")
If vartimer = "" Then Exit Sub
Application .OnTime TimeValue(vartimer), "SaveOpenWorkbooks"
End Sub
I need a formula that will count the number of consecutive 3 0's from the following Data series. There are 22 such events.
0
6
15
[Code].....
I have the attached table of numbers and I need a formula at the end of each column to identify whether any cells in that column consecutively have numbers in them greater than zero. Ideally by a count of how many cells in the column have consecutive numbers greater than zero (so if there are three 1's in a row and then a zero and then another 2 1's I want it to count 5).Excel Help.xlsx
View 2 Replies View RelatedI have a spreadsheet that has a column of numbers some of which are consecutive, some of which are not. I would like to have a way to lump all of these chunks of consecutive blocks into ranges. For example:
2759
2760
2761
2762
2764
2765
2766
2768
2769
2773
would return something like:
2759 - 2762
2764 - 2766
2768 - 2769
2773
Any ideas?
I'd like to take data in the range from B2:B500 and in C2 sum from B2:B9 and then in C3 sum from B10:B17 and in C4 sum from C18:C25 and so on.
View 2 Replies View RelatedI have got the following issue. I have got a large list of values in a column. I need to detect the the ones which are in non-consecutive order and display the difference in single numbers. For example:
1 fine
2 fine
3 fine
7 - 4,5,6
10 - 8,9
In other words I need to find the missing values and get them displayed.
The first of two consecutive numbers with exactly two simple denominator are:
14 = 2 × 7
15 = 3 × 5
The first of three consecutive numbers with exactly 3 simple denominator are:
644 = 2 × 7 × 23
645 = 3 × 5 × 43
646 = 2 × 17 × 19
I need to write a program that finds the first four consecutive numbers that contain exactly four simple denominator.
I have 2 Columns. One column represents calendar dates and the other column represents numbers between 0 and 7.
Therea re 10000 rows in this table.
I would like to count how many consecutive days I observe certain numbers numbers ( i.e 3+, 4+, 5+, etc)
I have an interval, for example [1431, 1589] an I need to automatically generate consecutive numbers in this interval - for example 1431.1 , 1431.2 ..... 1588.8, 1588.9, 1589. How can I do that? I know I can do this manually by writing some values and drag down but I need this done automatically.
to create with the default excel functions the following calculator. I need to calculate the maximum number of positive numbers which happen in a row and the maximum number of consecutive negative numbers. For example in the following list of numbers there are a maximum of 7 consecutive positive and a maximum of 6 consecutive negative numbers:
6 000
6 360
6 742
7 146
7 196
7 628
8 086
-4 071
7 898
-4 186
8 121
8 608
-4 562
to make a formula which will calculate the maximum length of positive and negative numbers in a row? I attached this table to the post.
I need to take every 4th data point from an array of several hundred (col A) and place the reduced array in a new column (col B). I initially tried approaching this in VBA and then tried excel, but to keep it simple i won't show the code that didn't work.
Col A Col B
5.001 5.001
5.002 5.802
5.001 5.951
5.003
5.802
5.805
5.801
5.804
6.951
6.950
6.952
6.951
I have a column with many different names and want to put a number at the end of the name. Is there an excel formula that can do this? For example:
ColA
BUY
BUY
BUY
BUY
BUY
BUY
SELL
SELL
SELL
SELL
SELL
SELL
SELL
SELL
SELL
SELL
KEEP
KEEP
KEEP
KEEP
DESIRED RESULT:
BUY 1
BUY 2
BUY 3
BUY 4
BUY 5
BUY 6
SELL 01
SELL 02
SELL 03
SELL 04
SELL 05
SELL 06
SELL 07
SELL 08
SELL 09
SELL 10
KEEP 1
KEEP 2
KEEP 3
KEEP 4
As you can see, if the number of consecutive texts goes over 10, I need it to add a "0" onto the beginning of the number.
I am trying to save my workbook in a specific directory with a specific filename and to incorporate a date field from within the spreadsheet. I have changed the format of the cell so it does not include / as i know this would not work. Saving it is the easy part but adding in the field from the spreadsheet is where im falling over.
View 2 Replies View RelatedI am trying to create a column which lists numbers consecutively from 1 - 10,000, grouped in intervals of 20 (ex: 1 - 20, 21 - 40, 41 - 60, 61 - 80, ...) without having to enter them all manually. Is there anyway to do this in Excel?
View 3 Replies View RelatedColumn C is the tricky one. It comes from the bank and somewhere in there is a 4-digit tenant reference. I did a formula to try and isloate it and it worked on most but if you look at the very first row, there is a spurious 99 in there, so it didn't work. Is there a way of EXTRACTING the first four consecutive numbers and placing them in another cell?