New Posts For Thread: Excel Experts!https://community.betfair.com/football/go/thread/view/94070/25543181/excel-expertsAny excel experts on here?, I need urgent help with a spreadsheet, it's do to do with macros.Can u e-mail me at SlippyShearn@hotmail.com and i will explain what i want to do and e-mail the spreadsheet over.CheersI was more worried about the email address.......https://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460393541#460393541I was more worried about the email address.......Wed, 04 Aug 2010 15:57:17 -0500Giving strangers on a betting forum your e-mail address and asking them to send you macros... #Dr Pepper theme tune#https://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460393169#460393169Giving strangers on a betting forum your e-mail address and asking them to send you macros... #Dr Pepper theme tune#Wed, 04 Aug 2010 15:55:05 -0500any chance you could email me 'This is for BIG Players only' and i can send it over as my excel knowledge is not the best, much appreaciated!https://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460392685#460392685any chance you could email me 'This is for BIG Players only' and i can send it over as my excel knowledge is not the best, much appreaciated!Wed, 04 Aug 2010 15:52:21 -0500errr, can't you just delete the empty rows using something likeSub DeleteBlankARows()Dim r As LongFor r = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1 If Cells(r, 1) = "" Then Rows(r).DeleteNext rEnd Suband just total the columns up for eahttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460391929#460391929errr, can't you just delete the empty rows using something likeSub DeleteBlankARows()Dim r As LongFor r = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1 If Cells(r, 1) = "" Then Rows(r).DeleteNext rEnd Suband just total the columns up for eaWed, 04 Aug 2010 15:48:13 -0500nerdshttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460390689#460390689nerdsWed, 04 Aug 2010 15:41:03 -0500well i have rows and rows of data for customers on different lines which i want to combine into 1 row per customer so i can work out my profit margin using a macro.EG: Customer 1 Income Costs Profit Marginrow1 Ahttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460390541#460390541well i have rows and rows of data for customers on different lines which i want to combine into 1 row per customer so i can work out my profit margin using a macro.EG: Customer 1 Income Costs Profit Marginrow1 AWed, 04 Aug 2010 15:40:08 -0500I am more of an excel guru than an experthttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460389997#460389997I am more of an excel guru than an expertWed, 04 Aug 2010 15:36:36 -0500just explain herehttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460389637#460389637just explain hereWed, 04 Aug 2010 15:34:19 -0500Any excel experts on here?, I need urgent help with a spreadsheet, it's do to do with macros.Can u e-mail me at SlippyShearn@hotmail.com and i will explain what i want to do and e-mail the spreadsheet over.Cheershttps://community.betfair.com/football/go/thread/view/94070/25543181/excel-experts?post_id=460389377#460389377Any excel experts on here?, I need urgent help with a spreadsheet, it's do to do with macros.Can u e-mail me at SlippyShearn@hotmail.com and i will explain what i want to do and e-mail the spreadsheet over.CheersWed, 04 Aug 2010 15:32:54 -0500