Help with VBA

trevork86.

Hello guys
Need some help with Macro writing in excel
The spreadsheet looks like something as follow.
I want the Macro to be able to copy whatever is before the "Grand total" but after the last "Grand Total" into a seperate tab within the same spreadsheet.
Any help will be great!!!! thanks
xxxx
xxxx
xxxx
Grand Total
xxxx
xxxx
Grand Total
xxxx
xxxx
xxxx
xxxx
Grand Total

lm8628.

能写中文不

Aries2012.

上个附件呗~

jackkkkk

我抢、我抢、我抢沙发~

jackkkkk

找到好贴不容易，我顶你了，谢了

wanwanzhu

这是什么东东啊

whosarsen

来看看

lin560

帮你顶顶！！！

weiya

楼主留个联系方式~