=IF($A3="","",INDEX('Paste Here'!$B$4:$AP$20000,ROW(C2),COLUMN(C2)))
=IF($A3="","",INDEX('Paste Here'!$B$4:$AP$20000,ROW(C2),COLUMN(C2)))
The code above is from a spread sheet that someone else created. I have to try and expand its capabilities but need to understand this code. The part that I am particularity interested in is the 'Paste here'.
is it possible to input data on one sheet and based on value have it paste into a different spread sheet?
TIA
Lauren
Hello reflect,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
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