Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 10, 04:41 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 2
Default Merging info from Wkbk 1 to Wkbk2 automatically

Hello,

Before I set up a new system, here's my dilemma. I have 7 separate workbooks
with program-specific information in them. What I want is, when I enter
information into any one of these workbooks, and enter the program code, I
want all of the info in that row to automatically copy to the separate
program-specific workbook, limiting the human-error factor as much as
possible. Is this even possible? (Or way more programming than I'm capable
of?)

Thanks in advance!

  #2   Report Post  
Old January 22nd 10, 11:34 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 2
Default Merging info from Wkbk 1 to Wkbk2 automatically

The easiest way to transfer data from one place to another is simply to
highlight the cell which is to receive the data. Then hit "=" and with the
mouse go to the cell where the data is to transfer from. Click on "enter".
The cell with the = sign now reads the data from another cell.
This works even if the data is in another workbook. But both spreadsheets
must be open at the same time for the data to transfer.
Len

url:http://www.ureader.com/msg/10402624.aspx


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging info Shannan Excel Discussion (Misc queries) 1 September 24th 09 07:28 PM
Copying cell info from one sheet to another in the same wkbk shellyjohnson Excel Discussion (Misc queries) 1 June 16th 09 07:09 PM
info mtg criteria from one wkbk to another bkinman Excel Discussion (Misc queries) 2 March 7th 09 06:38 AM
Merging info from 5 cells to 1 Clare Excel Discussion (Misc queries) 7 March 22nd 06 11:05 PM
Merging Info in Two Cells [email protected] Excel Discussion (Misc queries) 1 December 28th 05 11:43 PM


All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017