Over 1 million tech questions and answers.

Excel - Using one Workbook to populate information in another

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

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

RELEVANCY SCORE 200
Preferred Solution: Excel - Using one Workbook to populate information in another

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: Excel - Using one Workbook to populate information in another

Read other 16 answers
RELEVANCY SCORE 89.6

Hi

I was wondering if the above can be achieved?
My scenario is I have an issues log and the file name is saved as the issue title is there a way to get the saved file name into another workbook appearing as a hyper link back to the original?

I am assuming VBA will be needed and added on to the code below which i already have, the code takes the value of C9 (the issue title) and saves it in the right folder.
Code:

If Range("C9") = "" Then
Msgbox "Please ensure you fill out the Issue Title. Thanks"
Else
Saveactiveworkbook.saveas "C:\filename\filename\ & Range("C9")"
Msgbox " Thank you, your issue has now been saved."
Endif
 

A:automatically populate saved excel document as a hyper link in another workbook?

Read other 10 answers
RELEVANCY SCORE 70.8

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 70.4

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?
 

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 68.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 66.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 61.6

Hi there,

I am not sure if this question can be answered here or if it's in the right section but this is my problem.

I am currently using the Word 2007 Content Control Toolkit to add content controls to a Word 2007 document. These controls are then replaced later by XML that is received by a Windows Service. This all works wonderfully.

The problem I encounter is creating new documents can become cumbersome as they have to create a document, add tags, upload to a remote server and then generate a document using a external system. All these steps can be removed from the design process by having a Print Preview option that actually replaces the data as it would on my Windows service.

Does anybody know how I can accomplish this? Do I need to write VB script or is there a way to “place” the xml over the controls?

Any help in this regard would be appreciated.

Thanks,
Johan
 

Read other answers
RELEVANCY SCORE 61.2

Hello,
I had an idea... in my company there are several stand-alone contact lists each one managed with a separated Excel file. These directory of contacts are in several cities for that I had that idea:
create a master directory excel sheet managed by the HQ and populate it with all the other "branch" files uploaded on Google Drive or any other Web space by the users.
What the VBS or macro should do is anytimes I open the master document, it must look inside the path where the files have been uploaded then one by one import in into the master doc by creating the sheets inside each one.
Which one is the way to do that?
 
 
Cheers

A:How to populate an Excel doc with external Excel files.

In the branch worksheet, select the cell you want to link to and click Copy. Switch to the master spreadsheet and click the cell where you want the link. Then, right-click and select the Paste Link from the Paste menu.

Read other 6 answers
RELEVANCY SCORE 60.8

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 59.6

I have a workbook located on \\server\servershare\type2015
file name: TYPE.xlsx

how do i write the path of the table name in my query.

Any suggestions?
Thanks.
 

Read other answers
RELEVANCY SCORE 58.4

I have these two files: template(attached for reference), The Data file.

The Template – is a form I want to populate with data from the (data file) i attached it so you can see(i want macro to open the datafile filter it by distributor and list all the data for each particular distributor then copy the data and open the template file and paste the copy data on cell a6:g6 and down depend on how many data it pull for that particular datafile.

The datafile – that file has all the information/data I want to populate on the template

PS: I want to be able to run a macro where, macro would filter my data file by distributors and copy the data distributors by distributors and paste it in to the template file(after each distributor/filterdown it create a new ws for the new set of data for the next distributor). I attached some example but I didn’t send the data file OR i would like to have a macro to run every time the value change in cell "c2" it opens the data file and if c2 match value a2 in data file, i want it to copy all the data for that value in column a then copy and come paste it to template form. i attached the template and example or reference.

Your help is greatly appreciated!! plz
 

A:Populate excel form

Read other 6 answers
RELEVANCY SCORE 57.6

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 57.2

At work we deal with a lot of repeated data in a very fast paced setting.

I want to be able to enter the data into an excel sheet and then press a button to populate a word document with a pre-existing template or press another button and put all the data into a premade word form so that I don't have to keep copy/pasting over and over.

This is sensitive data, so it cannot be transmitted or leave my workstation to make the transition.

I would like to be able to do it all native, because I cannot use non approved third parties.

I am pretty sure this can be accomplished with VBA, but the coding is over my head.

Thank you in advance.
 

A:take notes in excel, populate two different word docs

Can you upload a blank template of your word document and also your excel this way we can see how to map the content from one to the other
 

Read other 1 answers
RELEVANCY SCORE 57.2

I have an excel file in which I am needing to creating multiple tabs. I want to have it where when I make any changes to the main tab that the data auto populates into the other tabs which I have filtered.
 

A:Auto Populate Data Between Excel Worksheets

Read other 16 answers
RELEVANCY SCORE 57.2

Hello,

I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.
 

A:Solved: Populate Word Document from Excel

Read other 16 answers
RELEVANCY SCORE 57.2

Hello -

I found an expired thread but am having the same issue and hoping for some guidance.

**I have a master spreadsheet with data (Last Name First Name, Address, Phone #, etc.) and I want to be able to auto populate a form that I created on another sheet with this information.

For instance, I want to be able to select a last name (maybe in a drop down box on my form or by putting an "x" in a key column next to the information I am looking for on the master spreadsheet) and I want the form to populate with the rest of the information.

Is this possible???

**

Thank you!
 

A:Populate an Excel form from a master spreadsheet

yes, you should be able to use vlookup or match index
only issue will be if you have more than one entry with the same last name

do you mean form , as in an excel form - or do you mean a standard excel sheet - you happen to use as a form ?

attach an example spreadsheet - but make sure none of the information is real - remember this is a public forum and you dont want peoples details on the web - data protection act etc
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hey All,

I am hoping someone will be able to help me accomplish this task. I have a master spreadsheet with data (Last Name First Name, Address, Phone #, etc.) and I want to be able to auto populate a form that I created on another sheet with this information.

For instance, I want to be able to select a last name (maybe in a drop down box on my form or by putting an "x" in a key column next to the information I am looking for on the master spreadsheet) and I want the form to populate with the rest of the information.

Is this possible???

Thanks,
Stephanie
 

A:Excel - Populate Form from Master Spreadsheet

Welcome to the forum Stephanie.

Can you upload a sample, so we can see where you have gotten to thus far?
 

Read other 1 answers
RELEVANCY SCORE 57.2

So I've tried to teach myself VBA to record macros that will take information from an excel spreadsheet and populate it in a corresponding bookmark in MS Word but no luck.

Basically I want a button in my excel spreadsheet that I can assign a macro to that will open up a word document for each student and populate a MS Word template with data from the excel file in the correct bookmark location.

In other words, I click the button in Excel, a file in MS Word is opened up for each student that is filled out using the corresponding data from Excel.

If anyone knows the code for all this it would be real helpful.
 

A:Populate a form letter in Word Using Excel

Read other 7 answers
RELEVANCY SCORE 57.2

Afternoon all,

I am trying to figure out a rather wierd issue. We have a spreasheet where we keep track of quotes within the company. Currently we have 4 other spread sheets where the data is basically sorted multiple ways. The higher ups within the company are TOO DARN LAZY to just sort it themselves so they want 1 spreadsheet with multiple sheets in it with the same data, just sorted different ways. What I would like to do is be able to enter the data on sheet 1, and have it automatically added to sheet 2, 3, and 4 and then have it sorted the way that they want it. Is this possible and if so how?

Finally, is it possibly to restrist a spread sheet so only certain users can modify it? Basically this file would need to be left on a share and multiple people need to read it, but only about 2-3 need to actually make changes to it.

Thanks for your help in this.l

Joe
 

A:Excel: How do I get data to auto populate to other sheets.

Question 1:
Right click sheet tab | Move or Copy.. | Copy. Sort as desired.

Or are you looking for an automated version? If so, more details are needed, possibly a sample file.

Question 2:
Unlock those cell which a user could modify, Ctrl + 1 | Protection | uncheck Protect | Ok | Tools | Protection | Protect sheet.. If using 2002 (XP) and up, you have many more options to set that the user can or cannot do while the sheet is protected.

To allow only certain eyes to view the spreadsheet, use the workbook protection under SaveAs | Tools.
HTH
 

Read other 1 answers
RELEVANCY SCORE 57.2

Hiyo.

I have an Excel (2010) file with 2 worksheets.
The first is a data table which has records with the following fields

Date__Time__Service__Type__Client__Location

The data is updated once a week on a Monday, and is a plan for the week ahead.

I need to transpose the Service, Type and Client (probably something like =Client & Chr(10) & Type & " - " & Service) values onto the 2nd sheet, which is a day planner split into 7 sections, one for each day.
Say the planner looks like this simplified version, with Date1 (i.e. Monday of the current week) in cell A1:


Date1_____Loc1______Loc2_____Loc3______Loc4_____
09:00 AM
09:30 AM
10:00 AM
10:30 AM
etc

Date2_____Loc1______Loc2_____Loc3______Loc4_____
09:00 AM
09:30 AM
10:00 AM
10:30 AM
etc
Click to expand...

Loc1 - Loc4 are the Locations, and Loc4 is an empty cell (for entries in the table sheet that haven't got a location specified).

I need to perform some manner of lookup / index-match / something in each of the cells on the planner sheet to populate them with the data from the table sheet.
So for cell B3 to populate, there would have to be a record in the table with:
- a Date equal to the Date1 value in cell A1
- a Time equal to the time in A3 (09:30AM)
- a Location equal to the Loc1 value in cell B1

For E2 to populate,
there would have to be a record in the table with:
- a Date equal to the Date1 value in cell A1
- a Time equal to the time in A2 (09:00AM)
- a Location of "" (e... Read more

A:Excel populate 7-day planner from data table

Read other 16 answers
RELEVANCY SCORE 57.2

Hello!
I have an Excel sheet that contains text/data per row. This excel sheet may have as many as 300 rows of data. I would like to export the data in the excel file row to a word template, and save that to a specific file name which corresponds to column 2. I would like to be able to 'click' a button and have all 50 rows export their information using the word template and have these files saved under specific filenames in the line item data (ex: column 2). Do you have any suggestions on how I can do this?
 

Read other answers
RELEVANCY SCORE 56.8

Hello I found an answer to this question but it was specific to his form. I have several Excel Logs (Tables) that contain information that is also entered into a separate form. Some forms are in excel and some are in word. I would like to hit a button that transfers a row of data to the form so i only have t enter data once. The forms will have additional information that will be entered. The forms are saved as a specific file type and are also printed so the answer that i found on this site may work but it puts the data into a different spread sheet in the same workbook and i need to send the data to a new workbook and in one case to a word doc. Can someone help me out. I have attached a couple examples of what i currently do.

Thanks for the help
 

A:Solved: Populate Excel Form and Word Form from Excel Table

Read other 16 answers
RELEVANCY SCORE 56.8

How to get MS security updates information in excel along with the Supersede information.
Earlier we use to get this information from https://www.microsoft.com/en-us/download/details.aspx?id=36982

However the Bulletinsearch list is updated till Apr 17, We need the info for future releases along with supersede as well.

Read other answers
RELEVANCY SCORE 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.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 56.4

Hi,

I am trying to create a button for inputting rows of data into a table.

I need the table to input a set amount of rows on the next available space in the table, and populate 1 of the columns with data given in a list.

I know I need a macro of some sort but am not sure how to go about creating it.

I have attached an example spreadsheet for reference.

Any help would be greatly appreciated!
 

Read other answers
RELEVANCY SCORE 56.4

I have an excel spreadsheet I have to work with a lot. I also have to turn around and type it all in again on a word document. I just need to make sure I get two different papers complete. Anyway, how do I automatically populate in word when I put the info on my excel sheet. If anyone could help me with this you would save me tons of work. I would really appreciate it. Thanks
 

A:How do I atutomatically populate a word document from an excel spreadsheet?

Read other 6 answers
RELEVANCY SCORE 56.4

Hi:
I have a couple of questions regarding the below code and the attached spreadsheet. What do I have to do to make this macro execute at the time indicated in col m of the spreadsheet? The dates are going to be different for each row.
Also how do I get cell data [a4] [h4] [g4] [m4] [n4] to populate from the worksheet into the email?

Sub Mail_small_Text_Outlook()
'Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
strbody = "Andean Funding Closing Document has not been recieved" & vbNewLine & vbNewLine & _
"Andean Tracking Number: [a4]" & vbNewLine & _
"Requested Amount: [h4]" & vbNewLine & _
"Case Number: [g4]" & vbNewLine & _
"Closure Document Due NLT Date: [m4]" & vbNewLine & _
"Staff Coordinator: [n4]" & vbNewLine & _
"Please contact OGL immediately to correct this situation" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & vbNewLine & _
"Judy De Santis" & vbNewLine & _
"Office of Global Enforcement" & vbNewLine & _
"Latin America Caribbean Section" & vbNewLine & _
"Office: 202-307-4609" & vbNewLine & _
"Cell: 202-345-9257" & vbNewLine & _
"Fax: 202-30... Read more

A:Excel 2007 -How do I get cell data to populate email?

Read other 6 answers
RELEVANCY SCORE 56

When I try to delete either in Excel 2016 I get a message that tells me to unhide the sheet. The sheet is there in front of me, the "hide/unhide" says nothing is hidden and I am confused. Can this be resolved?

Also, how do sheets get hidden without my doing anything knowingly?

Thanks
 

Read other answers
RELEVANCY SCORE 56

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 56

I have a workbook that I want to share with many people so they can all edit at same time. When I share it, they cannot run macos, it errors out with

"Error 1004 Application defined or object defined error"

Any ideas on how to overcome this?

Thanks!
ASM
 

A:Excel - Shared Workbook Macro

The macro is supposed to create hyperlinks... is this a no no? this is excel 2007...
 

Read other 1 answers
RELEVANCY SCORE 56

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 56

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 56

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 56

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