Create A Document To Be Available To Sevaral People

Oct 10, 2008

I am trying to do is create a document that will be available to sevaral people. The document will be edited by each person as needed. The completed document will then be used to order materials and supplies. What I want to hapen is each time the document is edited an alert is sent to the person responsible for the purchasing. I'm sure this is possible I just don't know how to do it.

View 14 Replies


ADVERTISEMENT

Create Monthly Rota For Up To 8 People?

Aug 3, 2014

I want to create a monthly rota for 8 people to cover monday to friday. Only one person per day and I need to put this in a calendar .

View 2 Replies View Related

Create A Shared Database That Tracks Training For About 100 People?

Dec 18, 2012

I am trying to create a shared database that tracks training for about 100 people. I've built a workable sheet, but the only way I have to share it over e-mail (there is no office NAS set up, and we're on a military base so we can't establish wifi).

Is there a way to set up a workbook that can be updated on one computer and instantly reflect that information in the cloud?

My goal is to have each team responsible for updating their own form and then have that information update my master tracker.

View 5 Replies View Related

Create New Document From Word Template

Apr 28, 2014

I have a template document, created in MS Word. I want to generate, from Excel, a new document as would happen when you open the template from windows explorer or whatever ie. Template1.doc as opposed to Template.xlt.

The best I've managed to achieve is the opening of the template.

View 6 Replies View Related

Create New Document On Button Click Containing Worksheets?

Aug 7, 2013

I have five worksheets among eight total in my workbook that I use as a report. I would like to have a button that copies those five particular worksheets into a new workbook and pastes all numbers as un-linked values. This would save me a TREMENDOUS amount of time generating my reports every month.

View 3 Replies View Related

Create Word Document With Bookmarks In Excel?

Aug 27, 2010

I'm trying to create Word documents (letters.doc) from Excel fields.

I already created bookmarks in Word and have the same Titles in A Row in Excel 2003 and I have tried the following threads:

Add bookmarks to Word from Excel Inserting data values from Excel into a Word doc using bookmarks

But I cannot manage it properly. I know that I need the code that goes on the lines of

Set WdApp = CreateObject("Word.Application")

rather than Set WdApp = New.Object

I cannot get Word to open a document! =(

It's basic letter creation, First_Name, 2_Name, Address_1, Address_2.. These have been bookmarked in Word and have exact same Titles in Columns A-D

View 9 Replies View Related

Create New Word Document From Template And Save As

Jan 21, 2014

I have been working on the following VBA code, which should copy specific charts from excel into specific places in a word-template.

I Am quite new with VBA, so I googled the code, changed a few things, and it works exactly as it should - except from one thing. When the Word-document is loaded from the template, I would like the document to be "saved as..."
Instead of just opening the template. I have tried

Code:
.ActiveDocument.SaveAs Filename:=fname & ".doc"

The code is as follows:

Option Explicit
Sub EksporterTilWord()

Dim appWrd As Object
Dim objDoc As Object
Dim FilePath As String
Dim FileName As String

[Code] ...........

View 1 Replies View Related

Create Document With 3 And 4 Columns That Occupy Same Sized Area?

Apr 30, 2014

One of my coworkers is trying to create a document that has 3 columns in one part of the spreadsheet, but further down on the page, he needs to have 4 columns but wants them to use the same amount of space as the three columns. I have looked around and don't see how that is possible.

View 2 Replies View Related

Using VBA In Excel To Create Formatted Document From Dropdown Lists

May 18, 2014

We have a proposal generation tool that we use that is based in Excel, and it works very well indeed. However, we're wanting to add a 'Custom Contract Generator' tab to the spreadsheet, and I'm at a loss with how to build it.

What it needs to do is :

- Allow the end user to select which contract clauses are required for the proposal they are working on, ideally via a range of dropdown boxes.

- Use that selection of clauses via dropdown box to create a compiled, formatted text list made up of those clauses.

- Enter that information into a landscape orientation Excel tab in such a manner as allows for tidy, business-suitable printing.

In short, I want the ability to pick what clauses we want to use, and have Excel generate a custom contract Terms and Conditions page based on my selection. And I've no idea where to start.

View 1 Replies View Related

Splitting Document To Mine Data And Create CSV File

Jun 5, 2008

I've got an Excel document that is generated from a third party programme (See ExcelDoc attached) ....

View 9 Replies View Related

Create Documents Based On Cell Values And Input Tabs In New Document

Sep 12, 2013

I want to create a macro that creates a new .xlsx document based on cell values. And input 4 tabs into each document with specified tab names. I have a document that pulls from external sources and fluctuates with amount of data per day. I envision something that will make a new document named for the contents in cell A1, then function as a control+down to create a new document for A2, then A3 until there is no content left (should mention these are lookup formulas, and if there is no data it pulls a value of "0")

Is there a way to put in the code, the tab names it would create in each new document, or would that have to look to a cell value for the naming? The tab names would be "GS", "MYSS", "COLL SHEET", and "WIRE".

View 1 Replies View Related

Searching For Mistakes In Document While Using Another Document As Reference

Feb 2, 2014

I am processing a fair few Invoices, which are being sent to me via e-mail as excel documents, very often they contain mistakes, a decent amount of mistakes. Usually the prices are wrong.

I keep track of every single entry on the invoice on my own document - Tracker, which I consider to be the superior/more correct document to the Invoice presented to me by my contractor.

Both of the documents have a reference number, which is a specific docket number, and horizontally, in the invoice, there is going to be a price for this docket. In my document, there is going to be a separate column for the total price.

Is it possible (I guess with VBA) to check for mistakes in the Invoice, but use the Tracker as a reference for this check.

Tracker has
columns
A - Name
B - Department
C - Date
D - Docket No.
C - Total price for the docket (calculation of E to Z)
E to Z - all smaller entries

Invoice has
columns
A - Date
B - Docket No.
C to E price for that docket, but it is spread, because departments are separated out, so each VAT account can be charged accordingly. I guess it is possible to do a separate column for the price, if it is easier to do a script that way.

Basically, I need to check if in the Invoice document, the price (C to E) for Docket No. (B) is the same as the price (C) for the Docket No. (D) in the Tracker.

I would like the wrong entries to be highlighted on the Invoice Document, so I can see straight away, that this needs attention.

Not always the price is wrong, sometimes the Docket No. is spelled incorrectly (Dyslexic contractor), hence the highlighting.

View 3 Replies View Related

Script That Will Turn Excel Document Into A Txt Document

Feb 17, 2009

I need a script that will turn a excel doc into a txt doc. Thats the easy part. The hard part (at least I think it is), is I need it to be in a certain format and I'll do my best to explain that fomat below.

View 9 Replies View Related

Deleting People's Second Name

Sep 16, 2009

In column G of my excel 2003 worksheet named: Data, I have a list of people's first names. These names were extracted from an external database.

Some of the first names actually contain peoples second names or partner's names.

Example:

John & Jill
James and Sue
Kerrie-Anne

Joanna Lyn

I need a macro to please delete people's second name.

So in the example above I need to keep all names that are joined by: & or and or - (such as John & Jill, James and Sue, Kerrie-Anne).

Also, in the example above I need to delete all names that are joined by a <space> (such as Joanna Lyn).

View 11 Replies View Related

My Macro Won't Run For Other People

Feb 10, 2010

It runs fine for me, but when others (who are using Excel 2003) try to run it, it won't fire. The second macro entitled "Delete Foothill" runs fine though. "Run Foothill won't fire.

Sub Run_Foothill()
Sheets("Foothill Plaza (Weekly Call)").Unprotect Password:="Foothill"
'
' Run_Foothill Macro
'
'
Sheets("OC").Select
Range("B37:C44").Select
Selection.Copy
Sheets("Foothill Plaza (Weekly Call)").Select
Range("B4").Select
ActiveSheet.Paste
Range("A12").Select
Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With

View 9 Replies View Related

Getting Count Of People In Department With Score

Jun 13, 2014

See attached.PMS 2.xlsx. I have a table with data on PMS sheet and would like to have something like the example on the Example sheet using data from the PMS sheet.

View 2 Replies View Related

List Of People In Column A And In B To E There Are 4 Numbers From 1 To 13

Mar 14, 2008

I have a list of people in column A and in B to E there are 4 numbers from 1 to 13. (Each person has 4 different numbers). In the next 24 columns are concatenations of these numbers in every order possible. On a separate sheet I have a list of concatenations of all possible combinations of numers 1 to 13 in groups of 4. e.g. 1234, 1235 etc. I have then counted how many times each of the concatnations from the first sheet appear. What I want to do is put the names of the people whoes concatentaions match the ones on the third sheet.

View 14 Replies View Related

Filter Out How Many People Have Voted 2 Times Or 3

Sep 20, 2009

I have 3 spreadsheets I combined into one,

They are voters for 3 separate occasions. I would like to filter out how many people have voted 2 times or 3. I have sorted the information with 2 columns "LASTNAME" and "FIRSTNAME"

Example:
LASTNAME FIRSTNAME
ABBOTTJANET
ABBOTTSTUART
ABBOTTJANET
ABBOTTSTUART
ABBOTTJANET
ABBOTTSTUART

These first 3 show up 3 times, so I would like to take all the info from row one and two to get all the info for Janet and Stu,

View 2 Replies View Related

Email To Multiple People In A Sheet?

Dec 25, 2012

I have a sheet in which it is separated by zone area, name (about 200 names), and email. I am trying to add people to an email based on zone. For instance:

Nevada Billy Billy@gmail.com
California Sal Theemail@gmail.com
New York Jim Jim@gmail.com
Nevada JOe Joe@gmail.com
Arizona Alex Alex@gmail.com

So how can add all the people in X zone to a single outlook email (in this case Billy and Joe)?

View 3 Replies View Related

Find The First And Last Names Of People In A Cell

May 18, 2009

I am trying to find the first and last names of people in a cell. I have a userform to get their first and last names separately. I am trying to run a VBA macro to determine if each cell in a column contains both first and last names, and then put a "Y" in an adjacent column. The Code I have is as follows:

View 5 Replies View Related

Send Mail To Filtered People?

Feb 5, 2012

I have an excel workbook which is a result of a sports survey I conducted. It basically shows who likes which sport, what level they're at, preferred time of play, etc, and their email address.

A colleague has created a type of form (using formulas, not VBA) wherein you select your criteria (Sport, Gender, Level etc) and it displays the matching names.

What I'd like is to be able to select, via a check box or similar, 1 or more names from the list of results for that sport, click a button, and their addresses automatically open in a new Outlook mail window for the person to send a mail to those people.

View 4 Replies View Related

Password Protection - Different Access For Different People

Dec 19, 2006

how can you set up a workbook to display different sheets for different users depending upon what password they input to open the workbook? The manager should see all sheets but employees only data entry sheets.

View 9 Replies View Related

Count The Number Of People Under Each Class

Jul 4, 2008

I want to do is to count the number of people under each class, eg. 2300 - primary, 3 ppl, but i gt many many classes in my spreadsheet, do u all have solution for me using VBA

SAMPLE DATA:

2300 - primary
amy
ben
alex

1234 - secondary
Linda
tom
Jerry
Tricia
Mabel

5603 - advanced
Linda
tom
Jerry
Kevin
Calvin

View 9 Replies View Related

350 People Tracking 24 Dates For Classes Each

Feb 20, 2009

I have a spreadsheet with ~350 people tracking 24 dates for classes each. On a seperate tab I have a macro that copies and pastes a pre-defined macro to display the due dates. My question is, can I have a macro run the calculation and put the result in the cell rather than have around 8,400 calculations on a sheet?

View 9 Replies View Related

Track The Number Of People From Each Zip Code

Jun 28, 2009

I have a workbook with a sheet for each day of the month where guest information is entered. There is a column for each item. There is a summary sheet that summarizes the number of members, guests etc. One thing I would like to track is the number of people from ech zip code.

View 9 Replies View Related

Rotational Roster For Groups Of People

Jun 10, 2009

I manage an emergency response team which consists of around 50 people, made of 5 different teams and these folks need to take part in emergency exercise to keep their skills up. I'm currently building a training/exercise/ roster database in Excel and would like to add a function that tells me who in each team is due to take part in the next exercise. For info: In the actual workbook, I have names defined on the team members and using vlookup to populate the roster via a drop down list.

To explain the attached example; once the person who is at the top of the list (Name1) has done their exercise, they move to the bottom of the list. Then over time, as the others also take part in execises, Name1 is eventually is back at the top of the list the and it is their turn again (this is quite often known as a Squash Ladder, here in the UK). Is there a way I can vba this process via a button or even better (!) by a drop down list?

View 3 Replies View Related

Calculate The Percent Of People Within Age Range

Aug 14, 2006

In the demographics sheet, I have ages listed from row F2 to F31 with different ages. I would like to get assistance with a formula that calculates the percentage of people within these age ranges:

21-25
26-30
31-35
36-40
41-50
51-59
60+

It should be separate formulas. I'm sure if I'm given the first and last ones that I could do the others myself. Also, if I needed to know the percent of males and females, would i use the same formula?

View 9 Replies View Related

Count The Number Of People Per Classification Between Two Dates

Apr 21, 2014

Count people per their classification between two dates. Spreadsheet attached.

The answer I need to show in column (S) is:
Cell (S4) = 1 (supervisor)
Cell (S24) = 1 (fitter)
Cell (S36) = 3 (rigger)
j906 count.xlsx

View 1 Replies View Related

Working Out How Many People Reach Specific Condition

Dec 11, 2013

I've put together a spreadsheet look at the time taken for a vehicle to get from one building to another when called. I've set up conditional formats where the timings turn orange after 5 minutes and red after 10 minutes taken. What I also have to show though is who is taking the vehicle and break it down to show any delays to patients. Is there a formula that will automatically tell me when there has been a delay to patients?? Be amazing if there is as it would save me uber amounts of time as i have to collate a whole years worth of data!

I've attached a small sample of what I've done to show you how the spreadsheet looks.

sample.xlsx

View 5 Replies View Related

IF Query; Find Out How Many People Passed In Green

Dec 22, 2008

I have a query where I am trying to find out how many people passed in green, amber and red from a series of data. I know (from the attached file) how to find out how many greens, ambers and reds there were, but how can I find out how many of the 7 in cell B12 passed in Green?

View 2 Replies View Related







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