Thanks Pascal.
WOW!!! the code runs like a Magician Wand.
I am not aware why the last row shows as #NA (as I am not knowledgeable
to that level)
I am eagerly waiting for your 'Magic Touch' for the output of Category,
Name, Hours and EOM
Thanks once again.
Rashid
On Saturday, July 28, 2012 2:08
The code as a file text is easier to copy paste from
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or ma
Hi Rasheed,
>
You can find below the complete code. I can't send a workbook now as there
are modules and few sheets non relevant. With the new code, I have the
following modifications:
- it will create 2 new worksheets (a temporary original copy of your data
and another sheet output2) provided
Hi Pascal,
Thanks for the code.
I changed the code according to my limited knowledge..
I think I missed something probably..pardon me for my ignorance
When I run the code it gives an error...
Block If without and EndIf and highlights End Function
Can you please paste the whole code
This is the
quick fix in the function... base 0 - base 1 arrays confusion fixed.
however, the last row comes with garbage data #NA why so?
Function CopyFirstCol(rg As Range, wsB As Worksheet, NEMP As Long)
'
'This function both copies pastes columns 1 and return an array with merged
cells row numbers
'
Dim
Hi Rashid,
I worked from the first workbook of your query and made the code easier to
change to whatever you need. There is a main sub and a function. Actually
the function does most of the copy paste but I use it to return the row
number of merged cells. As for now, the code works fine with th
Hi,
I could see that. David is helping on this. I can't look at it now. I see
this code or this task to be split into different modules. Each module
should take one or two loops. It'll be easier to work from that then.I'll
start again from this.The main loop for each column loops as many time as
Hello Pascal,
Your code does not pick up the General Category Activity from Row 911 in
Original Sheet.
Please look into this.
Thanks for your effort
On Wednesday, July 25, 2012 11:42:41 PM UTC+4, bpascal123 wrote:
> Hi Anil,
>
> I have started looking at your query. I'm getting somewhere with th
Hi Pascal
I think in the first loop Actions are merged cells and firms are not
merged. In the second one it is the other way round so you are probably
counting firms between actions rather than actions between firms.
Regards
David Grugeon
On 26 July 2012 05:42, bpascal123 wrote:
> Hi Anil,
>
Hi Anil,
I have started looking at your query. I'm getting somewhere with the code
below but if someone in this forum can me figure out why these lines are
not getting all values:
'This loop stores the number of times an activity occurs between 2 merged
cells --> need assistance,,, not accurat
dear prkhan,
Share ur data with groups...
Regards,
Gawli Anil
On Wed, Jul 25, 2012 at 12:50 PM, prkhan56 <> wrote:
> Hello,
> With the present data, I cannot.
> That is what I will do when I get all the Emp details in a summary sheet.
> Now the Emp names are in columns.
> I wish to have their d
11 matches
Mail list logo
