Generating Sequential Numbering For Documents
Dec 5, 2012If i had a template in excell would it be possible when it was opened it could generate a new number for the sheet in a cell for Ref ID.
View 3 Replies
ADVERTISEMENT
Sequential Numbering
Oct 25, 2009I have a workbook with two worksheets. Worksheet #1 is a form that will be populated with data and saved as a new worksheet, then cleared and used repeatedly as a master form. Worksheet #2 is a log / register of the unique forms completed and saved from the master each time. I need to assign a unique sequential # to each form when it is saved and record this number in a column on Worksheet #2 (the Log). I am using some macros for the copy work but struggling with the auto-numbering of the forms when completed and saved.
View 3 Replies View RelatedSequential Numbering With Gaps
Nov 10, 2007I have a column in which I enter a date, and an adjacent column which automatically enters a sequential number, using ...
View 10 Replies View RelatedSequential Numbering Macro?
Feb 28, 2014I have a large sheet (currently some 5,000 rows and growing) where each row is allocated a Unique Reference, however that unique reference is based on two criteria, 'Region' and 'Type'.
There are four 'Regions' and three 'Types' across the whole sheet (see attched sample).
Because of the ever increasing number of entries and the fact that the sheet may be sorted so the unique references won't always appear in sequential order, I am looking to try and find a way for the unique refrence for 'new entires' to the sheet to be generated automatically, based on entires in other columns. The sheet structure is relatively simple, with 'Region' shown in one column and 'Type' in another (again, see attached sample).
The unique references adopt this structure - 1st letter of the region (N, S, E or W for North, South, East or West), followed by 1415, followed by the first 4 characters from the 'Type', (REGI, NATI or COUN for Regional, National or County) followed by a sequential 5 digit number 00001, 00002, 00003 etc.
resulting in for example N1415REGI00001 or W1415COUN00012 and so on.
Because there are thousands of entries, I need an automatic way for the unique reference to be generated, ideally once both the 'Region' and 'Type' fields are populated, so the macro (or whatever method works best) will automatically determine the previous highest number for the relevant series and automatically add the next number for the new entry, based on the above criteria.
I don't know if this is possible with a macro or whether there is an easier formulaic way to achieve this?
Sequential Numbering Macro
Sep 3, 2006I need a macro that will number a cell (A1 for example) starting with the number 1, and another cell (A2) with the number 2, then back to the first cell with 3, then back to the latter cell with 4 and so on.
View 9 Replies View RelatedHow To Add Sequential Numbering Down A Column Until The Next Number 1 And Start Over
Feb 13, 2014I have a column that is listing steps in multiple processes. I have each step 1 marked with a number 1 and would like to have a macro run that will read the column and when it sees a 1 move down to the next row and insert a 2, 3, 4, etc. until it hits the next 1 and then repeat the process. I am unsure how to build this as I am just starting to learn some VERY basic VB scripting.
View 5 Replies View RelatedSequential Numbering Based On Column Having Text?
May 28, 2014If a cell in column B has text in, is it possible for column A to auto populate a sequential number? so basically if data is entered in a cell in column B I want column A adjacent cell to auto populate a sequential log number?
View 5 Replies View RelatedSequential Numbering For Duplicate Cells In Column
Feb 28, 2008In my worksheet i have several rows that are duplicates and i need to give each row a unique number. For example the first duplicated row needs to be 1 the second 2 etc.
View 7 Replies View RelatedCopy / Drag From Sequential Column To Non-Sequential Ones While Retaining Sequence
Jan 29, 2014I have a form made that needs to copy a value from another sheet. The Form is 10 rows 5 columns and and in format for easy print. On sheet2 I have a column where each row is filled with a name.
I need to put this name into sheet1, so in the the appropriate cell I put =Sheet2!B2 and it gives me the value (name) from the other sheet.
Then I want to copy the form bellow the 1st one so that I have the same form but with the next name, which means I want =Sheet2!B3 to appear when I copy, but since my form is 10 rows when I copy it the formula copies to =Sheet2!B12 instead of B3.
I need to make close to a thousand of this forms ready for printing and I would like to avoid having to manually set the formula for the next cell.
Hyperlinking To PDF Documents
Apr 28, 2009This code will take the value of the active cell (which is a filename) and open the corresponding PDF document of the same name.
Sub OpenPDF()
Dim fName As String
Dim fExt As String
Dim fPath As String
Dim fFullPath As String
fName = ActiveCell.Value
fPath = "M:Books"
fExt = ".pdf"
fFullPath = fPath & fName & fExt
ActiveWorkbook.FollowHyperlink Address:=fFullPath, NewWindow:=True............
Compare 2 Documents
Jul 13, 2009I receive a Weekly list; let’s call it “Doc1” with a load of order numbers in column A. I then have another excel document, lets call it “Doc2” also with order numbers in column B.
Is there a way to see if an order number in Doc1 already exists in Doc2; perhaps change the font colour to red for example (in Doc1 only)? I don’t want to affect Doc2 in any way I am not allowed to alter it at all.
Linked Documents Cell Changes
Feb 7, 2014I have several excel documents all linked to one unique excel document which I will call document A.
Document A is a performance spreadsheet where I have percentages, sales figures and times, for my sales team.
Each sales person has their own unique dashboard (another excel document) that I am currently trying to finalize.
Their personal dashboards have pie charts with text boxes. The text boxes within the charts link up to their relevant cells in document A.
When Document A is open and I open 1 of the sales person's dashboards. Everything looks good and works, however.
When I close document A the dashboard information changes. For example, the dashboard information could be showing 25% but when I close document A it reverts to 0.25
If I close down the dashboard and open document A back up, change it to 30% then close it. The dashboard recognizes the change BUT reads as 0.30. This is the same with them all.
The only fix I have figured out is creating another tab in Document A then duplicate of all the information required for the dashboards then save the cells as TEXT (as opposed to currency, percentage etc).
This kind of defeats the object because I have formulas set up in Document A and don't want to be doing twice the work.
Save Documents In Hyperlink?
Feb 24, 2014I have a file containing thousands of hyperlinks to respective image files. How I create a macro to save them with respective document names as shown in individual cells ?
View 4 Replies View RelatedExcel Documents Won't Open On First Try?
Nov 17, 2007I am having problems opening Excel documents on first try. If I double click a excel doc icon it will start excel, hang for about a minute and a half then just display a excel blank doc. If I then go back to the original doc icon with excel still open and double click it again the document appears.
View 9 Replies View RelatedClient Search On Two Documents
Apr 17, 2012I have been sent a document of clients names that I need to check against our own, is there a way on excel in which I can see if there are any matchers between our client list and the one I have been sent. It is for security purposes.
I do not fancy Ctrl - F 4000 client names
Navigate To My Documents Folder
Jul 30, 2008Is there any code that can make it possible to navigate to my Documents Folder only that is on a network drive and open the folder but not a document.
View 9 Replies View RelatedFormula That All Reference To Different Documents
Aug 15, 2008I have 330 lines of formula that all reference to different excel documents. These files are donated by a 4 digit number. i.e. 4186.xls.
The main document that looks at these files needs to ability to acknowledge changes in the 4 digit number in its formulas and look at a different file if necessary.
EG. =sum("4186.xls"!E4:E5)
A very simple example of the formula i am using. I just need to actively change the 4186 that is in the formula to whatever is in the contents of another cell.
I might just be stupid. Infact, i admit i am no expert. That was my first =SUM formula actually.
Links To A File In My Documents
Aug 21, 2009I have a template that I wish to distribute to others. It will link to a second file (also distributed by me) that will be in each users' "My documents" folder (or "Documents" in Vista). I currently have the template set to look at "C:" as that is common for everyone. Turns out that creates other problems. However, now each user's file location will be unique due to the path of their documents folder
Question, is there a robust way to automate the finding of the linked file in the template without having each user "relocate" it? Reason is the template will be updated frequently and I want to ease their pain by not making them go through this every time.
Linking Documents That Will Update Each Other
Aug 2, 2006Is it possible to link excel document that will update each other? I am looking for the capabilities similiar to linking worksheets in a workbook.
View 3 Replies View RelatedSecuring Documents By Changings Or Print
Apr 9, 2009I have an Excel document that I need to secure. By that, I mean that it can be viewed by anyone, but it cannot be changed or printed.
View 2 Replies View RelatedRunning Vblookup Between Two .xlsm Documents
May 19, 2009I have two workbooks one names "Quote" other named "product supply". In "Quote" i would like to have somthink like a Vblookup that on a givin line can enter price's, disciptions and other data automaticly on that line, From the "Product Supply".
Example:
"Quote" A:1 Dropdown list. Select product, Then refers to "product supply" of that product, then trasphers data into "Quote" A:2
Lookup Function: Looking Up A Name And Then Returning All The Documents
Sep 2, 2009I have data concerning documents people have to write, which is updated weekly. Is there a way of looking up a name and then returning all the documents that they have to write. I have tried a vlookup, but this only returns the first entry and not the lot. Also i would prefer the document data for each person to be returned in to one cell.
View 3 Replies View RelatedAutomatically Opening Word Documents
Sep 28, 2009I need a little assistance opening a Word file via an Excel macro. The two files are linked and upon opening, the Word file asks if the links should be updated. I need this to automatically be "Yes" everytime the file is opened.
View 4 Replies View RelatedDisplay Documents Properties From Its Hyperlink
May 29, 2013I'm putting together an Excel sheet which contains links to other files. I was wondering if I can display the properties of those files in an adjacent cell? Basically I want to show the date the document being pointed to in a hyperlink was last changed. The documents are contained on a local drive.
View 6 Replies View RelatedExcel 2003 :: Can't Retrieve XL Documents
Jul 18, 2013I have used MS Office Excel 2003 for many years without difficulty in XP. Suddenly I find I can't open many of my old documents. I get a message,"Microsoft Office (InfoPath2003) cannot open (the following file, etc.) A second message says, "The form contains XML that is not parsed: An invalid character was found in the content. Line 0, Position 0" Then I get the message "MS Office is not currently set as default." I complete the instructions that follow and it is now corrected but I continue to get the same error messages.
View 2 Replies View RelatedLinking To Password Protected Documents?
Dec 2, 2013I have a master document which maintains employees vacation an lieu time. I want to create a document for each employee where they can view all of their own person information by linking it to the master. The only problem is is that the master document is password protected. They can't have the password or they could access the master document and other employees confidential information. Is there a way to update there own document without entering the password or codon so the password automatically enters without them seeing it.
View 2 Replies View RelatedGet Macros To Open Embedded Documents
Jun 11, 2014I am trying to create a macro to add to a button that will open an embedded document (word, PPT, and excel).
I recorded the macro and it works fine the first time I try to test it but after it tells me that there is an error...
I'm not exactly sure what to do. Unfortunately, I could not find what I needed on youtube
Error: It talks about the object being out of range and allows me to debug... the code that is in the developer is:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("Sheet2").Select
Windows("Worksheet in Book1").Visible = True
Selection.Verb Verb:=xlPrimary
ActiveWindow.Close
Sheets("Sheet1").Select
End Sub
The Windows line is what it tells me to fix.. from there I am lost... Is it because I am trying to do a double clicking function?
Split TXT File To Word Documents
Mar 31, 2012Below code is for splliting text file into multiple excel worksheet. I want to modify it to splitting text file into different msword documents in folder. Is it possible to change the code
Sub LargeFileImport()
'Dimension Variables
Dim ResultStr As String
Dim FileName As String
Dim FileNum As Integer
Dim Counter As Double
'Ask User for File's Name
FileName = InputBox("Please enter the Text File's name, e.g. test.txt")
[Code] ........
Hyperlink For My Documents Location In Cell?
Jun 11, 2014I was just wondering if its possible to create a Hyperlink to open a location with the link ref in another cell?
For example, If I created a shape (Insert > Shape) then assigned a hyperlink to lets say Sheet 2 cell A1 & in that cell the link to open My Documents?
Sheet 1: Shape (as a button)
Sheet 2: Cell A1 - C:UsersUSERNAMEDocuments
Then when I click the 'button' it doesn't go to Sheet 2 cell A1 it actually opens the documents?
Locating Home My Documents Folder
Mar 10, 2007On the computers in my office they have a My Documents folder that is in the directory C:Data. There is also a My Documents folder in the usual windows location C:Documents and Settings etc. Is there a function that will give me the path of the folder that is on the desktop? The macro will be run on computers with the folder in different locations which is why I need to look it up.
View 5 Replies View Related