revision

I watched a youtube video by Amjad Pervaiz on making rev clouds in Excell. He had a add-in called "cloud.xlam" that would convert a rectangle to a cloud. He could adjust the arc radius, color, and line thickness. Does anyone know where I can get a copy of this add-in?

I need a copy of the revision cloud add-in named "cloud.xlam".

Hello, I am looking at many examples online on how to auto increment Invoice / Form number but they aren't specific to what I need to do. The format to number my forms is (Change Order #) - (Revision #). Example, If I were on the fourth revision of change order three, it would be 3-4. I need to...

Hello, I am looking at many examples online on how to auto increment Invoice / Form number but they aren't specific to what I need to do. The format to number my forms is (Change Order #) - (Revision #). Example, If I were on the fourth revision of change order three, it would be 3-4. I need to...

Hello all :) My boss stores the quote template in a folder. Each file in the folder is named the same except for a R and revision number at the end of the filename, ie...R1, R2...etc. The current revision if R19. I have a macro button that opens the latest template but I have to manually...

Hi Gurus, I have a requirement where I need to add a macros button to execute a VBA code that will read the string value from a "cell" that contains a "data validation list" with three options ( No Revision, Revision 1, Revision 2) and based on the option selected for that cell from the...

Hi, I have a material log and each material is assigned a status ( either A,B,C, or D). I need to count the no. of materials with each type of status ( No of items with status A,B etc) The catch is that the materials are duplicated and are arranged according to their revisions ( The item "...

Hi, Just to let you guys know my knowledge on excel vba is average. I have always used this forum for help when required and it has been great help! Now I am stuck with this. Please help! My excel has many more than 25 columns. I am trying to demonstrate using 4 columns here. 1st column = File...

Company policy dictates we don’t save excel files on our desktop as a revision could occur and we work off old forms which is against our ISO procedure. We must open them from our employee portal every time, I do this daily with about 10 individual documents. I was thinking of making a master...

Below is an extract from a drawing register spreadsheet & in column B, I require a formula that displays the latest revision of the document. Column E onwards display the received/issued revisions of the documents listed in column A at different times during the life of the project. As new...

Hello, I have several version of a workbook I am trying to implement, as I've added and changed code I've saved in different revisions. Right now I am trying to track down why Conditional Formatting is being cleared from one range of cells on a newer revision of the WB compared to an older...

Hello, I am building a spreadsheet to keep track of construction drawings. For those that do not know, these drawings will get revised from time to time, so it is important to know which revision is the most up to date. So far what I have is a column (Column A) which has a list of drawing...

Hello all, First time posting here. I'm trying to create a part number generator in Excel. The part numbers are in the following format: "XXXXX-XX", where the first five digits are serialized numbers, and the trailing two digits are the revision level. When a new part number is pulled, the...

If the Revision on column A is -B0-1 -A0-3 -B0-2 Then i need to get new revision on column B as -B0-2 -A0-4 -B0-3 Adding +1 In the last digit.

I am doing a document register where each document starts at Revision A. Once that document is revised, it becomes Revision B, then C, and so on. Once the document is formally approved, the revision number system changes to 0, and when Revision 0 is modified it becomes Revision 1, and so on. Is...

Greetings, I need the forum's help again. I've tried everything I can think of but can't get Excel to do what I want (I don't know how to write VBA yet). We have revision controlled documents and I need to sort large lists to determine, for example, the latest Revision in the list. To do...

Hi, anyone know how to change the revision cloud from <v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> to here is the original code: Sub Arc(StartX, StartY, EndX, EndY, angle) Dim ArcHeight As Single Dim...

I have file paths in Column E, for example: <TABLE style="WIDTH: 572pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=763><COLGROUP><COL style="WIDTH: 572pt; mso-width-source: userset; mso-width-alt: 27904" width=763><TBODY><TR style="HEIGHT: 11.25pt" height=15><TD...