Football
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Any 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.
Cheers
Can u e-mail me at SlippyShearn@hotmail.com and i will explain what i want to do and e-mail the spreadsheet over.
Cheers
Show More
well 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 Margin
row
1 A 10
4 B 5
EG: Customer 1 Income Costs Profit Margin
row
1 A 10
4 B 5
errr, can't you just delete the empty rows using something like
Sub DeleteBlankARows()
Dim r As Long
For r = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Cells(r, 1) = "" Then Rows(r).Delete
Next r
End Sub
and just total the columns up for each customer?
Sub DeleteBlankARows()
Dim r As Long
For r = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Cells(r, 1) = "" Then Rows(r).Delete
Next r
End Sub
and just total the columns up for each customer?
any 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!
Giving strangers on a betting forum your e-mail address and asking them to send you macros... #Dr Pepper theme tune#
I was more worried about the email address.......[:o]
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539