Re: $$Excel-Macros$$ Fwd: FILTER ISSUE

attach file to email re-send.. + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 9:24 AM, big smile bigsmile...@gmail.com wrote: -- Forwarded message -- From: big smile bigsmile...@gmail.com Date: Mon, Sep 22, 2014 at 9:23 AM

$$Excel-Macros$$ FILTER ISSUE

Respected Excel Guru / Friends I have 6 entries in excel files from Raw 3 to Raw 8 I want the formula that --- When ever i filter any raw by selecting any family name - Ex I filter Dhimant Parmar - EX R7 then i want in B1 What ever is in f - column after filter. When ever i change my filter

Re: $$Excel-Macros$$ FILTER ISSUE

Chandresh bhai, it is not issue but requirement..here you go... Add formula =row() in column P each cell corresponding to data. Add formula =INDIRECT(RSUBTOTAL(6,$P$2:$P$9)C6,FALSE) to cell B2. So as when you filter data you will get your desired result. Note: This will work only for filter

$$Excel-Macros$$ If Condition Problem

Sir, i created an add-in for my excel work but i am trying to write a condition it will only run in Computer Name= PCEARTH otherwise sub programs will be disabled automatically or not working thanks Sub CompName() Dim tSName As String Dim ThisComputerName As String

Re: $$Excel-Macros$$ FILTER ISSUE

Thank you Vaibhav Bhai for your good command over Excel Formulas God Bless you .. You are help is very good to this group. Keep it up. On Mon, Sep 22, 2014 at 2:44 PM, Vaibhav Joshi v...@vabs.in wrote: Chandresh bhai, it is not issue but requirement..here you go... Add formula =row() in

Re: $$Excel-Macros$$ If Condition Problem

Hi Use this code: Sub CompName() Dim ThisComputerName As String Dim myAddIn As AddIn If UCase(Environ(computername)) = PCEARTH Then ActiveSheet.Range(S1).Value = INDIA Else MsgBox (Sorry You are Not a Authorised User) ' below sub programs must be

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

Hi FA, Click blue button to Run Macro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sun, Sep 21, 2014 at 8:55 PM, Eugene Bernard eugene.bern...@gmail.com wrote: -- Forwarded message -- From: Eugene Bernard eugene.bern...@gmail.com

Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

It's VERY confusing trying to follow what you're doing... it seems like you're using chr() functions to convert characters to STRINGS? which doesn't make ANY sense. I'd like to first address your solution, then ask what it is you're trying to do? (lol) For your code: ActiveSheet.Cells(i,

Re: $$Excel-Macros$$ FILTER ISSUE

Cheers Bro.. Keep Smiling :) + *I did not do this for you. God is here working through me for you.* On Mon, Sep 22, 2014 at 3:39 PM, big smile bigsmile...@gmail.com wrote: Thank you Vaibhav Bhai for your good command over Excel Formulas God Bless you .. You are help is very good to

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Dear, Please find the Attached file ... Regards P On Mon, Sep 22, 2014 at 2:53 PM, prkhan56 prkha...@gmail.com wrote: Dear All, I am using Excel 2010 and have attached a file with my problem. I need Two Macros for my problem. There are two Files (both in a shared location - Path

Re: $$Excel-Macros$$ Track the system Lock

If you want this if you fear that screen lock may interrupt your running macro, then you can use application.screenupdating=false in the beginning of your code. Cheers On Sep 19, 2014 5:49 PM, Vaibhav Joshi v...@vabs.in wrote: PFA for locking screen.. Cheers!! + *I did not do this for

Re: $$Excel-Macros$$ Macro to highlight Max Value in a Column and copy/transpose data in another file

Hi Pramod, Thanks for your prompt reply. Works great! The second macro should run when the Cell Pointer is in Column T on a Highlighted Cell (in red). *Can red be given the RGB value mentioned on my sample data?* I want to copy and transpose cells from the Row where the Max value is found in

Re: $$Excel-Macros$$ Moving Completed rows to sheet2

Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag blank. The logic for moving the rows from sheet1 to sheet2 is rows with status tag with C if it has

Fwd: $$Excel-Macros$$ Moving Completed rows to sheet2

Dear Joshi, Thanks for your reply. As already explained in my first post, rows having code with 11 is not to be treated as completed, since 3 rows having codes as 11 is with status tag blank. The logic for moving the rows from sheet1 to sheet2 is rows with status tag with C if it has

Re: $$Excel-Macros$$ How to fix a vba code that returns a cell reference

Thank you for trying to explain a solution. The concept is very straight forward I just wanted the value input in next available row between 6-199 and a formula refrencing that cell in the matching column between 202-231. I have a freelancer working on this project now so all is good. On

Re: $$Excel-Macros$$ If Condition Problem

thanks a lot sir On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi v...@vabs.in wrote: Hi Use this code: Sub CompName() Dim ThisComputerName As String Dim myAddIn As AddIn If UCase(Environ(computername)) = PCEARTH Then ActiveSheet.Range(S1).Value = INDIA Else

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

Thank you very much Mr.Paul. I have tried it. Succesfull. Can I ask again? Divided by small number square 0.2, how can i get the value, because the VBA assume it zero. Actually i don't want to assume it zero value. On Fri, Sep 19, 2014 at 9:31 AM, Paul Schreiner schreiner_p...@att.net wrote: