Over 1 million tech questions and answers.

Populating data from one Excel workbook to a master workbook

Q: Populating data from one Excel workbook to a master workbook

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?

RELEVANCY SCORE 200
Preferred Solution: Populating data from one Excel workbook to a master workbook

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?

Read other 2 answers
RELEVANCY SCORE 124.4

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 123.6

Hi,
Apologies if this has been asked before.I have two different workbooks which I need to link I need to set up an arrangement whereby the data from a particular cell in one workbook is displayed in preferably pop up box in another workbook.
I have attached dummy versions of both the workbooks below.
1.The spreadsheet titled "Issues Log" has a list of issues,each with a unique identifier(column A) which is linked to a unique cab no (Column B).A brief description of the issue is given in Column C.
2.The spreadsheet titled "Link to Display Spreadhseet" has a list of CAB numbers (Column A) which corresponds to the "Issues Log" but the order is jumbled up.
In column B ,I need to place a link which will display the "Unique Identifier" code from the "Issues Log" corresponding to the cab number.When a person clicks on this Unique ID code ,one of the two things should happen: i.either the breif description of the issue (Column C in the "Issues Log") should pop up in a box.or
ii.Clicknig on the link will open up the issues log.

I hope I am clear in what I want.i am ok with using long winded formulas,tried some combinations of Match,IF etc but always hit a brick wall.I am not good with Macros,VBA.Any help/pointers would be greatly appreciated.

I am using Excel 2007
regards
 

A:Help needed to display data from one workbook in another workbook in a pop up cell

Hi,

Just a question, since you need to know what is the issue with its description. why do need the unique identifer for that and linked it do description. It might be a silly question, but please forigve me for that.

In case you don't need the unique identifier column, you can use vlookup for the populating the details.

Regards,
Tushar
 

Read other 3 answers
RELEVANCY SCORE 120.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 116.4

Hello, advicer
I do not understand why sometime I cannot copy a range from a workbook to another workbook in EXCEL (but I can if i paste the range in the same workbook). My PC is in the network of the company using WinNT 4.1. Please help me
Many thanks
Qan
 

A:Excel: Cannot Copy from Workbook to Workbook

Read other 7 answers
RELEVANCY SCORE 113.6

Hi all,
I have searched for a solution to this but as yet I haven't found the right thing.
I have a work book that was made with the help of Hans on here (A sheet to track training) that automatically sends emails out and updates the sheet which is working great.
What I am now trying to do is to have the sheet auto update depending on data in another excel file.

I get sent the data each week and I would like my tracker to automatically read the other file and insert any new data, is this possible without ending up with lots of duplicated rows or incorrect data?

I will upload a sample of the tracker that was made on here with Hans later this afternoon and also a sample of the file I receive each week to see if its possible, I have been playing around with it but I cannot seem to understand how to have it read the other file and update the relevant fields.
An important part to this is the cells on the tracker would need to keep their conditional formatting and any formulas relating to the cell as if I had typed the new data in myself.

I hope it makes at least a little sense, please do let me know if clarification is needed.

Thanks for your time once again.
 

A:populating from one workbook in to another automatically

Read other 9 answers
RELEVANCY SCORE 111.6

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

A:Excel: Automatically import data from another workbook

bparker said:

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you canClick to expand...

Hi bparker - Not sure I'm reading your intent right, but if you can save the "19991118damlbmp_zone" etc sheets into a book on the desktop you name "Book11" and then open a new book called "Book10" and run the code from Book10 - you can use something like this:

Code:
[SIZE=2]Sub COPYIT()
'this is run from the book named Book10
Dim N%
Application.ScreenUpdating = False
On Error Resume Next '<< error is - "books already open"
Workbooks.Open Filename:="C:\WINDOWS\Desktop\Book11.xls"
For N = 1 To Sheets.Count
Workbooks("Book11.xls").Activate
Sheets("Sheet" & N).Select
Range("A1", Range("A65536").End(xlUp).Rows.EntireRow).Select
Selection.Copy
Windows("Book10.xls").Activate
Sheet... Read more

Read other 3 answers
RELEVANCY SCORE 111.6

I need some code or formula to automatically add data from one sheet to my main sheet where I would like to put all of my data together. I am able to download sheets off of the net and they are in numerical sequence by date. "19991118damlbmp_zone", "19991119damlbmp_zone" and so on. I need to create a button or something to gather the info from the first sheet and paste it in my main sheet and then gather the info from the second sheet and paste that into the main sheet in the next available row.

Please help if you can
 

Read other answers
RELEVANCY SCORE 110.4

I have been given a last minute assignment to create a survey to send to a few end users and I want to compile the data of all the forms I receive into one excel workbook. I tried a few macros, but they aren't 2010 macros and so I am running into issues; I just don't have to time to re-write and could use a little assistance. I think the main difference is that I am using radio buttons instead of text fields.

ALSO I want to automate the entire thing. Meaning I want to open the workbook and run the macro to pull unprocessed forms from one folder, scan for data, import data, and then move them to another folder for archiving.

Also, in my form I don't think I made the comments section into a text field; I am sure I am going to have to correct that in order to capture the data... Right now I am too tired to think on it. At the end of each section I there is a comments field and I want to collect that data onto different sheets in the workbook. I already labeled the sheets.

I have attached the drafts for reference; I only shortened it for upload; the original draft has about 30 questions total. I need to get this done by 1/15/15 so that I have time to receive and compile data by 1/20/15.

Please help!
 

A:Export Word Form Data into Excel Workbook

Read other 7 answers
RELEVANCY SCORE 108

I have a workbook with data for all employees in it. Once a month I need to pull out a copy (certain columns) of the employee data that meet a certain criteria and paste it into another workbook for manipulation.

pull out all rows that have 513, 535, 540, or 560 in the "dept" column and paste it into another workbook. I am attaching a sample of each workbook.

1-testing macro contains all emaployee data
2-Copy into workbook (self explainatory)

I don't write vb code, but I can definately copy, paste and do some editing. Any help would be greatly appreciated. I have been searching online post all day, but have been unable to find anything I think is similar, at least that I could understand.
 

A:Solved: copying select data meeting criteria from one excel workbook to another

Read other 11 answers
RELEVANCY SCORE 103.6

Hi There
I have searched the internet to see if I could find a macro that opens a workbook and runs a macro. In other words, I have workbook 1 (master workbook) and workbooks 2,3,4 ...1000. So far I found a macro that opens workbooks 2, 3, ...1000 by running a macro from workbook 1. Now I have a macro in workbooks 2,3,....1000. What I want is to run the workbooks 2,3,...1000 macro from workbook 1. I can do it if I call the workbook name. But I don't want to do that, since I have over 1000 workbooks. Below is the code.

Sub WWNumbers()

Dim fso As Object 'FileSystemObject
Dim fldStart As Object 'Folder
Dim fld As Object 'Folder
Dim fl As Object 'File
Dim Mask As String
Dim thisFolder As String
Dim fullFilename As String

Set fso = CreateObject("scripting.FileSystemObject") ' late binding
Set fldStart = fso.GetFolder("C:\Users\Mario\Documents\Folder1 Name\Folder2 Name")
Mask = ActiveCell.Value
thisFolder = fldStart & IIf(Right(fldStart, 1) = "\", "", "\")
Debug.Print thisFolder, Mask
If Not IsError(Dir(thisFolder, vbReadOnly)) Then
If Dir(thisFolder & Mask, vbReadOnly) <> "" Then
Workbooks.Open Filename:=thisFolder & Mask
Else
fullFilename = ListFolders(fldStart, Mask)
If Len(Trim(fullFilename)) > 0 Then
Workbooks.Open Filename:=fullFilename ' workbook2 opens here just fine
Application.Run "UnhideSheets" ' I get an error here
End If

End If

End If
... Read more

Read other answers
RELEVANCY SCORE 93.6

Can you have wildcards in a filename? i.e

='U:\CurrentReports\[Richmond-Report-022307.xls]Stats'!$C$2+'U:\CurrentReports\[Tampa-Report-022307.xls]Stats'!$C$2

The part that needs to be different is the part after -. This is the date of the report. That way it always gets the most current data. Can this be done in the cell itself or are we talking VBA codeing?
 

A:Retrive Data from one Workbook into another

Read other 9 answers
RELEVANCY SCORE 92.8

Hi there

Sometimes I click on the X to close the workbook and I accidentally press NO when the computer prompts me to save the workbook since it usually comes up in a yellow box that does not really capture my attention. This usually happens when I'm in a hurry or late at night when I'm half asleep. Is there some code that makes a message box pop up with a message that says in big bold letters "YOU FORGOT TO SAVE YOUR FILE" when I click on the X to close the workbook? If so, this will save me a lot of headackes.

Mario
 

A:Save Excel workbook.

I am no guru, however I did find this in the hep wizard of MS Excel. Hope it is of some help to you.

Save workbooks automatically as you work
On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
How?
Select the Automatic save every check box.
In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
Select any other options you want.
 

Read other 3 answers
RELEVANCY SCORE 92.8

I have two workbooks I'm trying to combine in a VBA macro. The first excel spreadsheet is just simply a sheet of 30 columns of data and 5k rows. It adds a new row every day.

The second sheet will be the model with the macro. I would like to write a script that will use a sort of vlookup to the data sheet to pull in specific parts of the datatable instead of searching through the whole big sheet.

For example, see attached. The Model tab lets you input a date or dates in the C column and then it would have to somehow search another WORKBOOK, not within this one as the example shows (for simplicity). Any ideas would be much appreciated.
 

A:Call Excel Workbook in VBA

Read other 9 answers
RELEVANCY SCORE 92.8

When I attempted to save an Excel workbook, I couldn't because the file name had changed to a number. What should I do?
 

A:Can't Save Excel Workbook

Read other 7 answers
RELEVANCY SCORE 92.8

Tech Support Guy,

I have a question regarding linking two Excel (I am using Office 2003) workbooks and varying worksheets.
Here's what I want to do, using a macro, create a link to a cell in workbook A/worksheet X to workbook B/worksheet X (where X is variable).
Now creating a link is easy, except I want the "link" itself to appear in workbook A.
I tried the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= Workbooks("Workbook B.xls").Worksheets(Worksheet A).Cells(57, 3).Value
However, Excel places the value instead of the link in the cell. I want both, meaning, you see the value in the cell, but when you highlight the cell, you see the link to the 2nd workbook.

I have also tried the the following:
Workbooks("Workbook A.xls").Worksheets(Worksheet A).Cells(6, 4).Value _
= "='[Workbook B.xls] Worksheet A '!R57C3"
This gets me what I need except as I mentioned, the worksheets vary and I have not been able to figure out how to do use a variable worksheet name in this example.
I appreciate your help in solving this problem
Take care,
RJ
 

A:Excel Workbook Question

See if using the indirect function is the solution?
 

Read other 1 answers
RELEVANCY SCORE 92.8

I write a few macros for other users, and right now I just request that they rename the workbooks each month (or however often they run it) to the same names and then offer a reminder at kick-off. Something like:
Code:
If MsgBox("Are the workbooks saved as 'Workbook_1.xlsx' and 'Workbook_2.xlsx', and are they both open?", vbYesNo) = vbNo Then
End
End If
Windows("Workbook_1.xlsx").Activate
Range("a3").Select
Etc, Etc
Otherwise, I don't know how to make changes or run actions based on workbooks whose names might change. But is there a better way? I've had some people - those least familiar with automation - forget to rename, ignore the message, and then call with problems. Perhaps there's a way, instead, that asks them to name as variables whatever the sheets are called, though this might require some hand-holding, such as a list of what workbooks are open? I don't know. I'm open to suggestions - just putting it out there.

Thanks!

Windows XP
Excel 2007
 

A:Excel VBA: Prompt for workbook?

Read other 10 answers
RELEVANCY SCORE 92.8

Hi,

I am using Office 2013. I have a workbook which has to be shared. I want to protect it in a way that none of the options can be changes (like I have enabled 'track changes'. 'highlisght changes from users' etc). I do not want that someone turn off the 'track changes' option or as a matter of fact any other option.

They, however, should be able to edit the workbook. Is it possible?

I tried searching but could only see an option to protect workbook structure but noes not protect options.

-regards
 

Read other answers
RELEVANCY SCORE 92.8

Howdy, kinda new here. Anyway, I've got a doozy I can't seem to figure out. We just installed dual-monitors and now Excel is coming up saying "Not enough resources to display completely." It does this even when Excel is just started, with the blank, new workbook. There doesn't seem to be any screen real-estate issues since there's now double the screenspace. Any thoughts or ideas to try would be greatly appreciated.

-Ted
 

A:Not enough resources for Excel, even with a new workbook.

Read other 13 answers
RELEVANCY SCORE 92.8

I have a shared workbook that when some people open it the formatting does not show the same. Example I have hidden columns, but they don't see them hidden
 

Read other answers
RELEVANCY SCORE 92.8

My O/S is Windows Vista and I am running M/S Office 2000 Professional. In the past when using Windows XP I have been able to change which workbook opens when I open Excel. Now with Vista, I have designated 2 different workbooks to open when Excel begins however I cannot delete them form the Excel XLS folder. When I delete them, the screen shows that they are gone however when I strat Excel afterwards, they are back! How can I dlete them and install a new workbook. The standard process shown in the Excel help files is not working. Thank You.
 

A:Excel Startup Workbook

Closing duplicate...........replies here: http://forums.techguy.org/business-applications/672809-revise-excel-startup.html
 

Read other 1 answers
RELEVANCY SCORE 92.8

Hi,

I am working on an Excel 2002 report. I need to be able to create a copy of the workbook, strip it down a bit (for uploading purposes), and let the user save it as he/she pleases.

Is it possible to make an active copy of a workbook without saving it?
Excel VBA help is not being very "helpful" on this matter.

Thank you,
ABentsionov
 

A:Copy Excel Workbook

Hello, welcome to the board!

It is always best if you work from a saved file. This is just generally a good idea. Is there a reason you do not want to save the workbook? You need to save to do what you want. There is a way, but it is more convuluted than just saving your file.
 

Read other 3 answers
RELEVANCY SCORE 92.8

I have an Excel (2010) template from which I need to create separate workbooks for our range of ocean-going vessels.

Requirement 1
Upon loading the template, I need to prompt the user to enter the name of the vessel.

Requirement 2
The name must be transferred to a particular cell, probably A1, in proper case.

Requirement 3
I then wish to save the workbook using the vessel’s name, in capitals, followed by a space, a hyphen, another space and then the rest of the filename – based on the name of the template.

Example 1: name of template Record of voyage.

Example 2: name of workbook OCEAN TRAVELLER - Record of voyage.

Any thoughts?

 

Read other answers
RELEVANCY SCORE 92.8

I created an Excel workbook to monitor my investments. One of the work sheets contains a long column of currency values from an annuity investment with each row showing daily values.

Presently, I manually copy the daily value of that investment and paste it into worksheet # 2 that contains all of my investments. Worksheet # 2 daily refreshes, updates and totals all investments.

My question is this: is there a formula that would automatically copy and paste the daily annuity values from worksheet # 1 into worksheet # 2 without having to manually copy and paste? If so, could you please guide me through the steps to accomplish this?

Many thanks for your prompt attention and cooperation.
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 4028 Mb
Graphics Card: NVIDIA GeForce 9800 GT, 1024 Mb
Hard Drives: C: Total - 476837 MB, Free - 414208 MB; D: Total - 114439 MB, Free - 21161 MB;
Motherboard: Intel Corporation, DG43GT
Antivirus: avast! Antivirus, Updated and Enabled

<edited by moderator (etaf) to reduce font size - not required default forum font size is adequate >
 

A:Excel investment workbook

Read other 9 answers
RELEVANCY SCORE 92.8

Hello guys.
Please guide me through building my own tool in Excel.
I need to have workbook WK 1 with macro to modify another workbook WK2 which already have macros in it.
That is my plan : WK1 should have several command buttons first is to find person by ID from WK 2 , copy entire row with persons details to WK1 list 1, another button same but copy entire row to WK1 list 2, than when both lists created, I must have third command button which will : for each person in List1 WK1 will change value in cell 1 in WK2 from none to 1 and cell 10 enters =today date, for each person in List2 WK1 will delete value in first cell of the row in WK2.

I am keep loosing the track of what would be most simple way to do those steps, WK 2 file name is changing every day with date in beginning of the name of file,
 

A:Need help Excel 2 modify other workbook

Read other 13 answers
RELEVANCY SCORE 92.8

I have different database in several worksheets. I want to use vlookup to fill in the data from different worksheets rather than combined all into one worksheet. Can it be done? Thanks.
 

A:How to use vlookup for data from several worksheets within the workbook?

Welcome to the board.

http://www.ozgrid.com/VBA/VlookupAllSheets.htm (not tested).
 

Read other 1 answers
RELEVANCY SCORE 92.4

I need to update one workbook (Master Metrics) with data entered into another workbook (Daily Metrics).
Data is entered in the daily metrics workbook on a daily basis. This data populates the master metrics workbook automatically. The master keeps a running total of the data so that a monthly total can be generated for monthly reporting.
What is the best way to do this?
Thanks in advance for any suggestions
 

A:Linking one workbook to another workbook

Read other 11 answers
RELEVANCY SCORE 92

Hello,

I've been working on a certain workbook and everytime a try to save it an error occurs:

Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the inconvenience.

AppName: excel.exe AppVer: 9.0.0.2719 ModName: excel.exe
ModVer: 9.0.0.2719 Offset: 002aa2b3

HELP !!!

Thanks

Mark R

A:Excel 2000 .. When saving a certain workbook excel crashes

Hi, try running a repair from control panel>click on MS office and run change or repair if I remmber correctly.

Read other 1 answers
RELEVANCY SCORE 92

Using Excel 2010. I regularly download data from a database which have to be sorted by

column 1 - cell color blue on top, then
column 1 - cell color orange on top, then
column 4 - value, from newest to oldest

the data is always downloaded automatically to a workbook named "ABC", and the worksheet is always automatically named ABC#, with the # changing automatically.

the macro is saved in the personal folder. I tried to record using absolute and then as relative reference. the macro NEVER works when I tried to run in any new downloaded workbook or even I recreated the same data in a new untitled workbook.

the number of columns is always the same but the number of rows varies. there are about (7) cell colors, but only the blue and the orange need to be on top

the recorded macro always indicate the name of the worksheet and workbook on which it was created. is this why it does not work on any other workbook or worksheet?

any help will be appreciated
 

A:Excel Macro Won't Open in Different Workbook

Read other 14 answers
RELEVANCY SCORE 92

Good morning,

My head office has implemented a new way of recording operatives working hours.

It used to be based on a persons name and then the number of hours worked on a job. You could get about 20 men on one sheet.

Now thy want it based on the Job so each job has its own sheet, so we are swimming in paper!

What I need is a page where I can have a drop down box with the following criteria:

Name
Trade
Week Ending

and then

The jobs that that person did, so:

The Job
The day
The Number of hours

I dont want to manually enter all of this in a load of different spreadsheets so i there a way of just using one and when i hit 'Enter Data' or something it populates pre-made spreadsheets that I can print?!

Ive attached what ive got so far.

Regards
James
 

A:Excel - Using one Workbook to populate information in another

Read other 16 answers
RELEVANCY SCORE 92

Greetings everyone,

I have a question I am hoping you can help me with.

I create Excel reports, where the first sheet is a Menu and a second sheet contains data. The Menu refers to the second page, and based on which options the user selects on the Menu, a graph on the menu page updates with the relevant information from the second data sheet.

I am wanting to publish this Menu sheet such that it can be accessed and used on a webpage -- therefore, it needs to refer to the second sheet. However, I would like to keep that second data sheet 'locked' so that it cannot be accessed on the webpage at all.

Is this possible?

(PS - I know I have to use Excel 2003 to publish an interactive workbook ... unless anyone has discovered a way to do this with 2007, which dropped this great feature).

Many thanks in advance.
 

A:Publishing interactive Excel workbook - help please

You could make the sheet Hidden or via code XLSheetVeryHidden but the data will always be available.
 

Read other 1 answers
RELEVANCY SCORE 92

This may be too simple for some but I have a difficult task ahead of me. For some dumb reason our company refuses to let certain individuals use the database information of our time sheet software. Well this makes scheduling time off a nightmare. Hopefully there is someone who uses or can recommend a spreadsheet format (excel??) that can keep track of scheduled days off. And those days already used. We have several different types of payed time off kept in different types of banks and employees have to schedule way in advance and sometimes use one bank up and schedule another day off from that bank but end up redoing the request because they don't have time in that bank and have to reschedule. Creates a lot of paperwork and time adjusting. Example... most get 80 hours of vacations, 32 hours of what we call eat days (no lunch paid so we get 4 days off - eat days), 80 hours of Holidays. Those are fixed banks for the calendar year and then we have a COMP bank used where they can acquire hours from overtime or extra hours worked training which are based on using during an employee's anniversary year. Then we have a Holiday Bank which is never ending (no end date to be used by - no anniversary/year date) can be added to by 4 hour increments if you work a holiday. All of these hours are paid at the same wage. It really doesn't matter how you use the hours but they have to be approved prior to taking off depending on scheduling needs. What I would like is some sort of... Read more

A:Tracking days off with an Excel workbook?

Read other 8 answers
RELEVANCY SCORE 92

hi,

i have a Excel workbook that consist of 3 worksheets and there are some formulas in each of those sheets.

the problem is that each time I open the workbook there will be a "update link" message that appear (pls see the attachment). that's strange 'cause I have never inserted any links before.

is there a way to display all the links that are present in the worksheet and prevent this message from re-appearing?

thank you
 

A:Cannot Find the Links in Excel Workbook

Try Bill Manville's add-in -- http://www.oaltd.co.uk/MVP/MVPPage.asp
 

Read other 2 answers
RELEVANCY SCORE 92

Please forgive me if I am using incorrect terms here. I use Adobe Acrobat/Distiller (Version 5) to convert documents to pdf format. The problem comes when I have a large Excel workbook with 20 or so worksheets (tabs at the bottom of the page). When I try to convert them into pdf (File-Print-Distiller) I get 20 or so files.

First question-Is there a way to convert a multiple worksheet excel file into 1 pdf file? (Without the tedious "insert pages" function I am using right now)

Second question- Is there a way to convert multiple Word documents into 1 pdf file? (Once again without tedious "insert pages" function) Before you ask, no I cannot make all the Word documents into one file.

Third question-If there is no way to do the other two...is there a way to convert multiple adobe pdf into one without "insert pages".

Now since last time I got a bunch of "if it's not broke don't fix it comments" I am posting this statement. "Insert pages" is great and works great to get a couple of pdf files together. Try doing it for over 250 files and see how fun it is.
 

A:How do I print an entire excel workbook to pdf

If the worksheets are all < 1 page "long", then File -- Print -- Entire Workbook worked for me using CutePDF (can be found on Google).

OpenOffice has "Export to PDF" ; it did handle > page-long sheets for me, but baulked at some print settings, so it could depend on how fancy your sheets are (http://www.openoffice.org/).

>> I cannot make all the Word documents into one file.

Are you saying Insert Subdocument doesn't work in your version of Word?

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 92

Hi

Can anyone please assit me on how to make an Excel workbook give me a reminder via Outlook.
I want a reminder that will tell me when a specific task has not yet been completed.
we send requests to a custodian when we a looking for a document. on the excel sheet we enter the date we sent the request, but I want a reminder when the received date column has not been updated if I have not received the documents within 3 days time in order to follow up with the person.

can you pease assist me

regards
 

Read other answers
RELEVANCY SCORE 92

Hi,
I have on a workbook many sheets.
Every sheet contains tables with SUM A formula.
I want to create a cell on a different sheet where it gives me the SUM of all the cells on my workbook where the SUM A formula has been implemented.
Is that feasible?

Thx
 

A:excel 2007 (SUM FORMULA on all workbook)

Read other 6 answers
RELEVANCY SCORE 92

Hi There

I have recorded a macro that opens up a workbook from my C drive as follows:

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

I also recorded a macro that opens a workbook from windows as follows:

Windows("Salem's Point 1L 40M-2423.xls").Activate

I want to combine these two macros to do the following:

If Salem's Point 1L 40M-2423.xls is aready open then do the code Windows("Salem's Point 1L 40M-2423.xls").Activate

If Salem's Point 1L 40M-2423.xls is not open then do the code Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

Please help

Mario
 

A:Excel Macro to open a workbook

Hi Mario,

When you say you open a workbook from your C-drive.
Are you executing your macro from within an Excel workbook or how?
What do you trigeer it with or where do you trigger it from?
 

Read other 1 answers
RELEVANCY SCORE 92

Microsoft Excel 2003 - I need help creating a macro that will link a workbook file with hundreds of other workbooks to create a customer list. All my workbooks are in C:\Documents 2007\Bids\BID____.xls. All files begin with "BID". All workbooks are identical and I only need information from certain cells. (i.e. G8, A6, G6, etc.). I want all the information from each file to go onto one row of the customer list - a new file's information on each row. Does anyone know how to do this? I have spent all day working on it and am about to go out of my mind. I would really appreciate any help. Thanks.
 

A:Excel - Need Workbook Linked to Many Workbooks

Read other 16 answers
RELEVANCY SCORE 92

Hi guys. I am not quite familiar with Excel, so would appreciate some help with this, even if this might seem like a simple question enough to many of you.

I received an Excel file from a colleague for updating of data. There was a dotted border surrounding the whole workbook which prevents any editing of sorts beyond the dotted border.

Is the dotted border a result of my colleague protecting the workbook?

Thanks for the help.

Regards,
Terry
 

A:Dotted border around Excel workbook

The dotted border is probably due to page breaks. Protection is a separate issue -- you can check if the worksheet is protected by hovering over "Protection" under the "Tools" menu.
 

Read other 2 answers
RELEVANCY SCORE 92

This is a followup to my "Data transfer between 2 different open Apps" thread, which is now functioning...sort of. I have not found a way to access the data from the workbook which is opened in the second application. I can only reopen it from it's last saved location, which is OK, if I know that the workbook has not been changed since it was last saved. Part of what I'm doing uses a IsFileAlreadyOpen function (kernal32) as recomended to me in that thread.

QUESTION: I would like to know if an open workbook has been changed since it was last saved. This workbook is in a different app. Is there a function (perhaps kernal32) that can be called to give me the changed state of a workbook?
Thanks,
Tom
 

A:VBA Excel: Check if a workbook has been changed

Read other 7 answers
RELEVANCY SCORE 92

I have a audit template that takes two files and compairs them and opens a new workbook to display the differences. This new workbook is then saved to a specific location for audit reasons.

In the new workbook created, I'm wanting to "remove" all the toolbars and menus so a user can't safe the file to another location by mistake.

Is there a way for the creating template to "insert" macros into the newly created workbook to do this? While I could just create new worksheets in the "creating" template workbook and remove the ones I don't need, I'm trying to keep the size of the file down by not having all the macros that created the new template in the final product.
 

A:Have Excel VBA Create A Macro In A New Workbook

Just for some thoughts on this concept, I would suggest you read this:
http://www.vbaexpress.com/forum/showthread.php?t=26263&highlight=hide+toolbars
 

Read other 1 answers
RELEVANCY SCORE 92

hi all,
I have an excel workbook with several worksheets, each a page a long (i dont want them all merge in one sheet). I need to number them sequentially as they appear on the workbook.
The only way i can number them now is by going into each worksheet and inserting a page footer and enter a number manually !

Is there a way whereby all worksheets/pages are numbered automatically and more importantly page numbers changes if a new sheet is inserted ?
Thank u kindly.
Edd.
 

A:Excel - Workbook page numbering

Read other 12 answers
RELEVANCY SCORE 92

I would like to know if it is possible to take my primary workbook (workbookA) and make a secondary copy of it with a different name (workbookB), that will automatically update when workbookA is changed. I need to do this because I will have multiple users running macros that will reference WorkbookA and at the same time the quality department needs to be able to check the workbookB for changes (which will be just be a copy of workbookA). If they open the file that is being referenced by others it will throw errors for the other users.

Is there a simple way to do this without using a reference in every cell?

I am using Excel 2007 on an XP Machine.

Thanks,
Allen Jones
 

A:Create a Reference Workbook In Excel

Is there a simple way to do this without using a reference in every cell?

Click to expand...

That's kind of what I was gonna suggest
 

Read other 1 answers
RELEVANCY SCORE 92

Does anyone know if it is possible to have a VBA code run after a workbook's name has been changed?
 

A:Solved: Excel VBA run after workbook name change

I was able to get what I wanted done by using the BeforeClose event.
 

Read other 1 answers
RELEVANCY SCORE 92

Hey -

How do I set different (scaling) print percentages for each worksheet within an excel workbook?

For example: My workbook has 5 worksheets and I would like for 4 of the 5 pages to print at 75% scaling and the 5th page to print at 68% scaling.

Thanks in advance
GDJ
 

A:Excel: Print % different for worksheets within workbook

From each worksheet, go to File-Page setup, and set the percentage. You can group worksheets, tho I'm not sure you can set the page setup when they are grouped, but I would try it. Click on worksheet 1 tab, hold shift, then click on worksheet 4 tab. Do the page setup, click on worksheet 5, do page setup. Then they should all be set as you desire them.
 

Read other 3 answers
RELEVANCY SCORE 92

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

Read other answers