Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 86
Default Automatic separate row is added when value is more than $0

I have a separte that is 2000 lines.

When there is a charge of more than $0 I need a separate row to be added
automatically with the other information AND not the $0

Is there way I can do this automacially instead of me having to put in a
row manually when I create this spreadsheet in the future?

Currently the spreadsheet is created. Is there a formula i can put in and
another row is added to the row above with the other information instread of
the charge like basic information like name and date.

EX
Charge Dog
50
Reply
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
Data is added together instead of separate data points Mike W. Charts and Charting in Excel 1 December 2nd 06 10:47 AM
Open Separate Excel Files in Separate Windows JTWood Excel Discussion (Misc queries) 3 May 7th 06 10:18 PM
automatic series readjustment when Inew row added [email protected] Charts and Charting in Excel 1 April 11th 06 11:52 AM
Save 2 separate data imports in separate worksheets on the same ex Jay Excel Worksheet Functions 1 March 8th 06 01:31 PM
Open Excel files in separate sessions, not just separate windows? Bob at Dexia Design Excel Discussion (Misc queries) 1 October 18th 05 05:46 PM


All times are GMT +1. The time now is 05:14 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"