Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-28-2011, 04:10 AM
macropod's Avatar
macropod macropod is offline Carry-forward: Tab to Tab? Windows 7 32bit Carry-forward: Tab to Tab? Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

hi Mark,

Assuming the carry-forward figure from the previous worksheet is in the last cell in the column concerned, you could use a formula like:
=INDEX(Sheet1!A:A,MATCH(1E+306,Sheet1!A:A,1))
where 'Sheet1' is the worksheet name and 'A:A' is the column from which you want to bring forward the value.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Forward without forwarding formatting whatever61 Outlook 0 12-14-2010 08:08 AM
Carry-forward: Tab to Tab? forward message to outlook category knoutam Outlook 1 11-07-2010 02:13 PM
Can I carry Outlook 2007 with me on a usb stick? Hansio Outlook 2 09-09-2010 01:29 PM
Auto-Forward Read Reply timcar1 Outlook 0 10-13-2009 09:33 PM
Auto forward return receipt to Requestor sarav@msoutlook Outlook 0 12-09-2008 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft