LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
rodante
 
Posts: n/a
Default Consecutive data in different sheet


All help you can give me, I will appreciate.

I have dated cosecutive information in a jounal, Dates, Concept, Doc
No. Account Numbers, Figures,etc. Then in another sheets, I have to
transfer that data to individual sheet for each account, as a Ledger.

How can I using a formula can I transfer automaticly the data from the
general sheet to each individual account sheet in a row consecutive
matter?

Example:

Journal
Row Date Concept Doc No Acc No Debit
Credit
6 10/20/05 Telephone 567 500-01 56.00

Transfering to:
Individual Account Sheet Acc No 500-01
Telephone
Row Date Concept Doc No Acc No Debit
Credit
13 10/20/05 Telephone 567 500-01 56.00

Because this Row is the continuing Row with data filed in previous
Rows.

Thanks for all help you can give.
Rodante


--
rodante
------------------------------------------------------------------------
rodante's Profile: http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=478286

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Merger Two Data Sheet Charles Excel Discussion (Misc queries) 2 March 18th 05 03:35 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"