Generating Sequential Numbering For Documents

Dec 5, 2012

If 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, 2009

I 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 Related

Sequential Numbering With Gaps

Nov 10, 2007

I have a column in which I enter a date, and an adjacent column which automatically enters a sequential number, using ...

View 10 Replies View Related

Sequential Numbering Macro?

Feb 28, 2014

I 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?

View 14 Replies View Related

Sequential Numbering Macro

Sep 3, 2006

I 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 Related

How To Add Sequential Numbering Down A Column Until The Next Number 1 And Start Over

Feb 13, 2014

I 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 Related

Sequential Numbering Based On Column Having Text?

May 28, 2014

If 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 Related

Sequential Numbering For Duplicate Cells In Column

Feb 28, 2008

In 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 Related

Copy / Drag From Sequential Column To Non-Sequential Ones While Retaining Sequence

Jan 29, 2014

I 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.

View 3 Replies View Related

Hyperlinking To PDF Documents

Apr 28, 2009

This 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............

View 9 Replies View Related

Compare 2 Documents

Jul 13, 2009

I 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.

View 9 Replies View Related

Linked Documents Cell Changes

Feb 7, 2014

I 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.

View 4 Replies View Related

Save Documents In Hyperlink?

Feb 24, 2014

I 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 Related

Excel Documents Won't Open On First Try?

Nov 17, 2007

I 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 Related

Client Search On Two Documents

Apr 17, 2012

I 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

View 2 Replies View Related

Navigate To My Documents Folder

Jul 30, 2008

Is 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 Related

Formula That All Reference To Different Documents

Aug 15, 2008

I 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.

View 9 Replies View Related

Links To A File In My Documents

Aug 21, 2009

I 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.

View 9 Replies View Related

Linking Documents That Will Update Each Other

Aug 2, 2006

Is 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 Related

Securing Documents By Changings Or Print

Apr 9, 2009

I 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 Related

Running Vblookup Between Two .xlsm Documents

May 19, 2009

I 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

View 8 Replies View Related

Lookup Function: Looking Up A Name And Then Returning All The Documents

Sep 2, 2009

I 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 Related

Automatically Opening Word Documents

Sep 28, 2009

I 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 Related

Display Documents Properties From Its Hyperlink

May 29, 2013

I'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 Related

Excel 2003 :: Can't Retrieve XL Documents

Jul 18, 2013

I 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 Related

Linking To Password Protected Documents?

Dec 2, 2013

I 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 Related

Get Macros To Open Embedded Documents

Jun 11, 2014

I 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?

View 5 Replies View Related

Split TXT File To Word Documents

Mar 31, 2012

Below 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] ........

View 3 Replies View Related

Hyperlink For My Documents Location In Cell?

Jun 11, 2014

I 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?

View 2 Replies View Related

Locating Home My Documents Folder

Mar 10, 2007

On 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







Copyrights 2005-15 www.BigResource.com, All rights reserved