Hi Experts
I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets.
Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet within the same workbook.
The following link gives you an example of what the data looks like
https://spreadsheets.google.com/spr...EfMDsdFJmSkZ6Z3JudXhGMkJaVWZIbkdGU3c&hl=en_US
the problem in the tables arent the same or ordered in a way that can be easily automated. So i was wondering if anyone would have a solution to cut and paste tables that is cascading in one worksheet to other worksheets in the same workbook. If someone can solve this i would greatly appreciate it.
thanks
sudak
I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets.
Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet within the same workbook.
The following link gives you an example of what the data looks like
https://spreadsheets.google.com/spr...EfMDsdFJmSkZ6Z3JudXhGMkJaVWZIbkdGU3c&hl=en_US
the problem in the tables arent the same or ordered in a way that can be easily automated. So i was wondering if anyone would have a solution to cut and paste tables that is cascading in one worksheet to other worksheets in the same workbook. If someone can solve this i would greatly appreciate it.
thanks
sudak

