Football
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
sort by:
Show
per page
Replies: 8
|
By:
just explain here
|
|
By:
I am more of an excel guru than an expert
|
|
By:
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 |
|
By:
nerds
|
|
By:
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? |
|
By:
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!
|
|
By:
Giving strangers on a betting forum your e-mail address and asking them to send you macros... #Dr Pepper theme tune#
|
|
By:
I was more worried about the email address.......[:o]
|