Auto fill consecutive row after processing from different sheet.

**snb** · 01-03-2011, 04:04 PM

cfr. the attachment

**ganekon** · 01-03-2011, 05:39 PM

Hi snb,
What I'm trying to make will look like the this attachment.
So, total from "Buy" or "Sell" will be put in sequence by the date in "Cash Balance".
Each will be separated in different row.

**snb** · 01-03-2011, 06:16 PM

cfr. the attachment.

In the balance sheet all data form sell and buy will be inserted.(64 rows)
After that you can sort this balance sheet (A1:F65) on date (menu/Data/sort).

**ganekon** · 01-03-2011, 08:57 PM

Originally Posted by snb

cfr. the attachment.

In the balance sheet all data form sell and buy will be inserted.(64 rows)
After that you can sort this balance sheet (A1:F65) on date (menu/Data/sort).

That won't work, snb. After I sort it out, the datas were mixed with each other.
I need to keep every total from each dates (even the same date) to be in different rows.

**snb** · 01-04-2011, 05:32 AM

That will definitely work if you sort correctly:
select A1:D63, menu/Data/sort

or using a macro

Sub sort_snb()
  Sheets("Cash Balance").Range("A1:D63").Sort Range("A2"), , , , , , , xlYes
End Sub

**ganekon** · 01-04-2011, 10:53 PM

Originally Posted by snb

That will definitely work if you sort correctly:
select A1:D63, menu/Data/sort

or using a macro

Sub sort_snb()
  Sheets("Cash Balance").Range("A1:D63").Sort Range("A2"), , , , , , , xlYes
End Sub

Hi snb,
I've change the formula after your ideas, thanks again. I think there is no other choice than to make it separate into double tables like the one you suggest. I have 1 last question, how do we fix the #VALUE! error in E37:E63 ?