+ Reply to Thread
Results 1 to 5 of 5

Macro for creating a column in last available Column

  1. 04-02-2014, 09:35 AM #1
    Haidar123
    Haidar123 is offline
    Registered User
    Join Date
    03-21-2014
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    80

    Talking Macro for creating a column in last available Column

    Hi guys,
    I want a macro which can find last available cell in first row and named it "Averages" and in Average column it can fill formula of average "=average(B2:last cell left to average cell)" and it can auto-fill the whole column until last row of adjacent column.

    Actually I want to create a "averages" column in last available column which can find averages starting from Column B value to the last column value. for example "=average(B2:G2)" here G is last column and averages are in F.


    Help is Appreciated !!!!
    Reply With QuoteRegister To Reply
  2. 04-02-2014, 10:10 AM #2
    Leon V (AW)
    Leon V (AW) is offline
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: Macro for creating a column in last available Column 

    Please Login or Register  to view this content.
    Sub Reputation()
Dim Problem as Variant
Dim Reputation as Integer
For Each Problem in Forum.Threads
    If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
Next Problem
End Sub
    Reply With QuoteRegister To Reply
  3. 04-02-2014, 10:15 AM #3
    Haidar123
    Haidar123 is offline
    Registered User
    Join Date
    03-21-2014
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Macro for creating a column in last available Column

    I have excel file with more than 10 sheets. Can u modify it so that it can run on all sheets except first sheet.
    Reply With QuoteRegister To Reply
  4. 04-02-2014, 10:22 AM #4
    Leon V (AW)
    Leon V (AW) is offline
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: Macro for creating a column in last available Column 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-02-2014, 10:26 AM #5
    Haidar123
    Haidar123 is offline
    Registered User
    Join Date
    03-21-2014
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Macro for creating a column in last available Column

    Perfect Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating Single Column List from multi-row/column table and removing blanks
    By ChemistB in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-10-2014, 02:23 PM
  2. Creating Macro to transpose from Column to Row
    By Deaneric in forum Excel General
    Replies: 3
    Last Post: 08-02-2012, 08:10 AM
  3. Need a macro for creating folders with their names given in a column
    By Dileep6661 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2012, 09:35 AM
  4. Help creating macro to find value of Column A within Column J, then align?
    By nickf829 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2011, 12:40 AM
  5. creating a column list from a row of data macro
    By cedkins in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2011, 06:58 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1