+ Reply to Thread
Results 1 to 2 of 2

Auto Calculation

Hybrid View

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    London,England
    MS-Off Ver
    Excel 2013
    Posts
    3

    Auto Calculation

    I have a excel workbook consisting of 3 sheets. One sheet name is 'importeddata' in which 10 columns exist starting from b5 to k1000(b5:k5 is the heading of the columns). Another sheet name is 'Main Form' in which 10 columns exist starting from b5:K1000.
    Now i want to put 'column (c6:c1000) and column (g6:g1000)of the importedata sheet data (except b265:b435 and g265:g435)' into 'column b6:b1000 and D6:d1000 respectively in the main form sheet'. Please don't import 'except range' (i.e b265:b435 and g265:g435) data in the main form.

    Column E,F,G,H of the Main Form contain some information which needs to be processed automatically through vba code.

    Column G6:G1000 of Main Form has the following formula '(E6/F6)*4' Column H has this formula 'D6/G6'
    Column J has the following Formula = I6*5
    All the formulas should work automatically for the rest of the data.

    Now write some VBA code under command button/rectangle that will produce my desire results with just a click.

    I will be grateful to you. Because i do it manually everyday.

    I am looking forward to hearing response from you soon. Thank you very much in advance."

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Auto Calculation

    Hi swapon_uiu,
    Welcome to the forum,
    You can record a macro with the steps to see the basic VBA code.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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