p; i).Value*
>
> *Form.Cells.Copy*
>
> *Sheets.Add Form*
>
> *ActiveSheet.Paste*
>
> *ActiveSheet.Name = detail.Range("A" & i).Value*
>
> * Application.CutCopyMode = False*
>
> **
>
> *Ne
The macro is functioning as per my expectation.
Please set the calculation to automatic in your workbook if you hv not done so.
R u getting any error. If so what is the error.
Goto into the debug mode and check if the values in empcode is changing.
On Wed, Jul 6, 2011 at 5:16 PM, ankur wrote:
*HI VASANT
THNKS FOR UR EFFORTS
EmpCode = ThisWorkbook.Worksheets("Sheet2").Cells(x, 1)..this code
is not working
U R GETTING IN RIGHT DIRECTION, NOW I NEED... THE STAFF NO OF NEXT EMPLOYEE
GET CHANGED AND THE RESULT GET PASTED IN SHEET2MEANS AUTO CHANGING OF
DATA VALIDATION HAPPEN
Hi Ankur,
Not sure, whether i understood your query completly...
Pls find this code
This code takes the staff no. from Sheet2 and puts in "A2" in the
'gents report" sheet. It then picks up the result from "C2" cell
of the same sheet and puts into the income tax column for the
corresponding staff
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote:
> hi vasant
> thnks for such nice code
> i have similar problem also...but i need some modification
> this code produce many workbook...cant it be possible to create a single
> workb
Hi Ankur,
Glad to help you. Pls send me your file...let me try :)
On Wed, Jul 6, 2011 at 12:34 PM, ankur wrote:
> hi vasant
> thnks for such nice code
> i have similar problem also...but i need some modification
> this code produce many workbook...cant it be possible to create a single
> wor
*hi vasant
thnks for such nice code
i have similar problem also...but i need some modification
this code produce many workbook...cant it be possible to create a single
workbook with different sheets for each employee ?
another query
i have asked one query earlier about data validation requi
*hi jai
do u want print out of sheet 1 after having Name, Designation, & Emp code of
each employee*?
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 6, 2011 at 11:17 AM, ashish koul wrote:
> HI jAI
>
> do you
HI jAI
do you want to send this form as attachment to emp ids mentioned in sheet 2
?
r u using lotus notes or outlook.
On Wed, Jul 6, 2011 at 10:45 AM, Jai wrote:
> Dear Experts
>
> i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name,
> Desination, & Emp code .
>
> --
>
> -
Dear Experts
i wnat to mail merge From Sheet -2 To Sheet -1, in Sheet -2 , Name,
Desination, & Emp code .
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitt
10 matches
Mail list logo
