writing an If function linking to another workbook
My dilemma:
If cell E4 on workbook2 (which is closed) contains value "123"
Then cell J14 on workbook1 (the active workbook) is = cell D5 on workbook2 (closed)
I've been toiling over this for days, I would greatly appreciate any help I can get!
Thanks in advance!
Do you want to check if the cell E4 in Workbook2 contains "123" when opening Workbook2?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Denvernuggets15,
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Duplicate thread here - http://www.excelforum.com/excel-prog...-workbook.html
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks