Hello,
I use VBA in Excel 2003 and my problem is:
I have a sheet protected with some cells unprotected. If I protect sheet
manually, the operator can copy and paste unprotected cells.
If I protect sheet in a subroutine, the operator can copy but can't paste
unprotected cells.
Please find an at
Retreived by sumproduct and vlookup check this out.
Regards,
Mandeep Baluja
Learningzmypassion
On Sunday, April 5, 2015 at 5:47:05 PM UTC+5:30, Ashish_Bhalara wrote:
>
> Dear experts,
>
> Kindly see attached file in which I make formula in yellow cell that is if
> match particular t
Dear experts,
Kindly see attached file in which I make formula in yellow cell that is if
match particular task with Sheet2 table, the calculated data should be from
matched task. I tried with array but not get exact output. Please suggest
me how to calculate data only those which matched of Sheet1
what is the name of your application from which you're retrieving your data.
On Saturday, March 28, 2015 at 9:14:11 PM UTC+5:30, Avinash wrote:
>
> Hi Experts,
>
> i want a macro which can copy data from another application to excel.
>
> below is the code which i am trying to use. i dont have any
