Many thanks Daniel, exactly worked as per requirement
Regards,
Prashant
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 11 June, 2011 4:14 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Message
Dear group,
As the part of discussexcel http://www.discussexcel.com/ initiative, we
declare Excel bog of the month each month. This is done to appreciate
indvidual Excel bloggers and encourage excel blogging.
akoul.blogspot.com has been selected as blog of the month for May 2011. This
is a
Hi,
Please see attached spreadsheet in sheet named Practice OFFSET for my question.
Basically, how do you edit the formula to keep summing the column if you skip
a cell in the column and enter numbers at random cells in the same column.
Thanks
~Sunnie
From:
Please, attached is an example of data which I need to transpose and a pivot
table doesn't do it...
Thank you for your help.
John
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
We are looking a macro solution to compare data in Sheet1, column D and
compare that to Sheet2 column A. Where they match, I want to have the value
in Sheet1 column F to be copied to Sheet 2 column E
sample data attached
Thanks…
--
Dear Mr. Smith,
Please try and check this VBA Code, if it helps...
Sub AbnormalizeYourTabel()
' STDEV(i) / milis belajar-excel / 08 apr 2011
' retouched for another table-structure
' jakarta, Jun 12, 2011
'---
Dim Tbl As Range, NewTbl