$$Excel-Macros$$ Advanced Meta Data - Cut and Paste Issue

2010-07-24 Thread Dinsdale
paste, which should work, but I wanted to know if there are any other options. Thanks for the help! Dinsdale -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ Count Rows Where One Cell Has Value And One Cell Is Blank

2009-10-29 Thread Dinsdale
k rows) I'm not really comfortable with this. I thought that it should be something more like this: =COUNTIFS(A$2:A$65552,NOT(""), H$2:H$65552,"") This second formula only re

$$Excel-Macros$$ Re: Counting Cells in a Parent/Child relationship

2009-07-27 Thread Dinsdale
f Excel, and these type of practical problems will help > our group to learn. > > Thanks, > DILipandey > > -- > DILIP KUMAR PANDEY >    MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On 7

$$Excel-Macros$$ Re: Counting Cells in a Parent/Child relationship

2009-07-24 Thread Dinsdale
he macro could unprotect the sheet, insert the formula, then > re-protect the sheet. > > sound feasible? > > Paul > > > From: Dinsdale > To: MS EXCEL AND VBA MACROS > Sent: Friday, July 24, 2009 12:30:59 PM > Subject: $$Excel

$$Excel-Macros$$ Counting Cells in a Parent/Child relationship

2009-07-24 Thread Dinsdale
new row is added and, quite frankly, I don't trust them to do it correctly. Does anyone know of a more "eligant" or "user proof" method to do this? I am not against writing VBA macros, but I'm not sure where to start. Any help on this subject w