BA code to copy multiple data in one worksheet leaving blank cells in to other worksheet

Hi Ripan,

_ OK, Here we go:

_ This was Not to difficult technically this one, just a bit of careful work to select the correct data to select and copy etc..

_ A few notes / assumptions I have made:

_ For no particular reason i determine the number of Tables to be considered from the Number of tables in the Output sheet. So AT LEAST as many tables as that must be in the Data Sheet, ( and in the same order. )

_ I have assumed the different Data Tables are all the same row size, ( but this can easily be changed to select the actual row size if it is different )

_ Assume Date column J ( Column 10 ) gives indication of last used row when formula returns “”

_ I assume you have the tables you want already there, all formatted, bit just with no data in Output sheet and only data is required .

_ Blank rows are determined by when Cash Flow Date has no date in ( Can also easily be modified to AND / OR check other columns )

_ You may need to do some adjusting of your sheet Formatting to get Date Formats etc Finally correct. It is difficult for me to predict what you may get as my Excel ( German ) has different default settings.

_ So I have a Code for you . It appears to work correctly.

_ To Summarise: For a small part of Table 2

_ Input given from you

Using Excel 2007

Row\Col	AC	AD	AE	AF	AG
12	Financial Year	Month	Cash Flow Date	Cash Flow Amt.	Cumulative Principal
13	FY 2013-14	Aug -13	26.Aug.13	-262,300,000	285,000,000
14	FY 2013-14	Aug -13			285,000,000
15	FY 2013-14	Aug -13			285,000,000
16	FY 2013-14	Aug -13			285,000,000
17	FY 2013-14	Aug -13			285,000,000
18	FY 2013-14	Aug -13	31.Aug.13	890,137	285,000,000
19	FY 2013-14	Sep -13			285,000,000
20	FY 2013-14	Sep -13			285,000,000

Data Sheet

_ ........
_ Working on the above, my code , given here:
http://www.excelforum.com/developmen...ml#post4201063

_ .... will return this ( Again just showing a small part of table 2 )

Using Excel 2007

Row\Col	K	L	M	N
12	Financial Year	Month	Cash Flow Date	Cash Flow Amt.
13	FY 2013-14	13.Aug.15	26.08.2013	-262,300,000
14	FY 2013-14	13.Aug.15	31.08.2013	890,137
15	FY 2013-14	13.Sep.15	10.09.2013	-200,000,000
16	FY 2013-14	13.Sep.15	13.09.2013	-215,000,000
17	FY 2013-14	13.Sep.15	18.09.2013	-300,000,000

Output Sheet

_ I recommend you try to apply the code to reduced test data first. Once successful, I would increase the Number of tables and row size in steps , just in case any unforeseen problems occur when dealing with lots of Data.

_ Please let me know how you get on.

Alan