Hello friends,
I need to prepare Intercompany reconciliation for my company which
includes around 60-70 a/c’s of our intercompany transactions, if
anyone doing same kind of job or anyone knowing nice way of doing.
Please help me in doing this reconciliation report and understand it
better.
Thank
Dear Members
Please Help me I am waiting for reply
shrinivas
Date: Fri, 12 Nov 2010 13:09:02 +0530
Subject: $$Excel-Macros$$ VBA Code Required
From: shrinivas...@gmail.com
To: excel-macros@googlegroups.com
Dear All
Can Anyone help me for following problem.
I want to compare 2 column
Hi,
In case you are using Excel 2007 or can use Analysis ToolPac you can
use =randbetween (lower_limit, upper_limit) with 1 as lower and 5 as
upper limit. Otherwise you can use =int(rand( )*100) to generate
random integers then divide the numbers by 2, 3, 4, 5, and 6 and
select people based on
Good After Noon Team,
Still, Waiting for your response.
Regards,
Surnedra
On Mon, 15 Nov 2010 15:28:43 +0530 wrote
Hi Team,
I need your help for calculating Last Working Date from attached format.
As per policy below mention attendance legends count as a working day
P Present
HD Half
You can take idea from what I have done in the attached file.
On Tue, Nov 16, 2010 at 3:38 PM, Surendra shindaro...@rediffmail.comwrote:
Good After Noon Team,
Still, Waiting for your response.
Regards,
Surnedra
On Mon, 15 Nov 2010 15:28:43 +0530 wrote
Hi Team,
I need your
You can create a BeforeClose event in which you save the file before exiting.
To do it yourself,
first, record a macro in which you do a SaveAS (specify file)
Then, in the VBA editor, choose the Thisworkbook module.
In the upper left pull-down, select Workbook
in the upper right pull-down, select
I have a macro that copies a large range of cells that contains a
mixture of cells with values and text and other cells with formulae.
I want to copy this range into a new workbook using VBA but I can't
seem to retain the formulae (which are converted to their values). I'm
sure there is a simple
Hello Sir,
I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and use mail merge in MS word. now the problem is, I have to make
separate file for each employee and have to send one by one on their
Hi Mike,
Try this:
RR.Range(A LastRow_RR + 1 :CN LastRow_RR + LastRow_NWR -
5).Formula
= NWR.Range(A6:CN LastRow_NWR).Formula
Thanks Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft
Many thanks. I had actually tried that and it had failed but I've
subsequently worked out what was going wrong. The worksheet I was
copying from was protected. I just needed to unprotect first and it
all works fine now.
On Nov 16, 1:45 pm, Ashish Jain ashishj...@openexcel.com wrote:
Hi Mike,
workbook open password protected.
I need to be able to get a message box to appear with some
information - before the Password message box appears. I can get the
message to
appear after the Password box - but not before.
any ideas.
Johnnyboy
--
send file
On Wed, Nov 17, 2010 at 4:20 AM, Johnnyboy5 intermediatec...@gmail.comwrote:
workbook open password protected.
I need to be able to get a message box to appear with some
information - before the Password message box appears. I can get the
message to
appear after the Password box
12 matches
Mail list logo