Solved

need help in Excel

Posted on 2000-03-07
6
131 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
6 Comments
 

Expert Comment

by:jcummings
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 17

Expert Comment

by:calacuccia
Comment Utility
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
Comment Utility
Hi Loay,

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

Author Comment

by:loay
Comment Utility
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

Wish Marketing would stop bothering you?

Is your marketing department constantly asking for new email signature updates? Are they requesting a different design for every department? Do they need yet another banner added? Don’t let it get you down! There is an easy way to manage all of these requests...

Join & Write a Comment

A few months ago I had an issue with LaserJet 1020 printer which was installed to XP and Windows 7.  It was installed to XP and working, but when I tried to connect from a Windows 7 PC, it would attempt connection and then fail.  Sometimes the Spool…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now