Solved

need help in Excel

Posted on 2000-03-07
6
136 Views
Last Modified: 2013-12-28
hi there
plz help me in this peoblem
how can i connect two bockes together in the excel example:
i want every thing i am writing in a book happend to another one

send to me as soon as you can

0
Comment
Question by:loay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 

Expert Comment

by:jcummings
ID: 2592654
The easiest and quickest way to do this is to do the work in one book and then copy it to another when you are done.
0
 
LVL 9

Expert Comment

by:joed
ID: 2594249
There ia a way to make a cell in one reference a cell in another book. I'm sorry I can't tell you exactly how.

found it follow these steps
1,copy cells you want
2.go to new sheet
3.edit-paste special
4.paste link at bottom right of panel
0
 

Author Comment

by:loay
ID: 2594778
I want to do this using macros, not by copy and paste, So can you help me,
for that I reject the answer you send..
Your's
Loay jaber
0
Don't Miss ATEN at InfoComm 2017!

Visit booth #2167 to see the  new ATEN VM3200 32 x 32 Modular Matrix Switch. Other highlights include the VE8950 4K HDMI Over IP Extender, VS1912 12-Port DP Video Wall Media Player  and VK2100 ATEN Control System. Register now with Free Pass Code ATEN288!

 
LVL 17

Expert Comment

by:calacuccia
ID: 2595149
Hi Loay,

Supposing your soruce workbook  is called "Book1.xls" and copy workbook is called "Book2.xls" & both are opened as blank workbooks, put this code in the Workbook_SheetChange event of "Book1.xls"

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Workbooks("Book2.xls").Sheets(ActiveSheet.Name).Range(Target.Address) = Target
End Sub

To get there, right-click on the Excel-symbol left next to 'File' in the menu bar, and select view code, then paste the above lines. Close the Visual Basic Editor afterwards, to save your changes.

What will happen now, is that every text you type in "Book1.xls" will be copied automatically in "Book2.xls"

Hope this is what you want,

Calacuccia
0
 
LVL 17

Accepted Solution

by:
calacuccia earned 44 total points
ID: 2631176
Hi Loay,

Since no feedback from you, I'm grading to an answer ...
0
 

Author Comment

by:loay
ID: 2633023
hi calacuccia
but your answer didnt work because when i try it it give me "over flow " and there are nothing happen

0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question