+ Reply to Thread
Results 1 to 3 of 3

Macro To Insert Conditional Data

  1. #1
    Registered User
    Join Date
    06-17-2008
    Posts
    2

    Macro To Insert Conditional Data

    Hey there,

    I am new to this forum and looking to get some help in solving my issues & building mu excel skills.

    I have a macro code thats pulling conditional data from my main worksheet to new worksheets and than formatting that data.

    I need a new macro that should ;

    1.

    Insert a new row with word "Personal Total" in column A ,2 rows above the word "Private" . ex if Private appears a A8 , PERS. SUM shud be A6 , if Private is A34 PERS. SUM shud be A32..
    Check : - If "PERS. SUM" already exists , no action should be take i.e. code should not over write it.

    2.
    Insert a new row with word "PVT. SUM" should in column A , exactly above word "GRAND TOTAL" which is also in column A. So if "GRAND Total" is in A14 , PVT. SUM shud be in A14 like this.
    Check : - If "PVT. SUM" already exists , no action should be take i.e. code should not over write it.

    3.
    Macro should this for all worksheets in available workbook except a work sheets "Final" & "Mid-Year" .

    Both words "PERS.SUM" or "PVT.SUM " , if coming from this macro should have cell colour as grey and it should also grey corresponding columns in row B,C,D,E. i.e. macro does not finds "PERS. SUM " , and it putting this word in A8 than B8,C8,D8,E8 cells should be of grey colour ..same for "PVT. SUM" .

    Let me know if this makes any sense.


    Thank you for taking your time to read this.
    Byess,
    Tanya

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Have you tries a Pivottable?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-17-2008
    Posts
    2
    Quote Originally Posted by royUK
    Have you tries a Pivottable?
    i dont know much abt excel , got this project in my uni project needs to complete..how do we do pivot table ??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1