+ Reply to Thread
Results 1 to 3 of 3

Need to amke over the sheet change for two placeses for every colum every record ...

  1. #1
    Registered User
    Join Date
    05-04-2014
    Location
    Metro DC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy Need to amke over the sheet change for two placeses for every colum every record ...

    Hi, everyone,
    Hope to fund an easy way to make the change to the sheet:

    I need to change the calculation with one extra value (From one cell) for every column (24) for every record (30).

    I am using Excel 2007.

    Example:
    Change from: F18*0.50
    Change to: (F18+ F19)*0.50

    Record holds: F28 to F45 with 24 (F, G , H, I, J, ... to Z, AA, AB) Rows.

    The Record is a 18X24 in size and is 30 Records for the sheet.
    Each Record have two places need to change, F39 & F40 and extend from F to AB.

    Any help would be very much appreciated.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Need to amke over the sheet change for two placeses for every colum every record ...

    Is it possible to upload a copy of your workbook?

  3. #3
    Registered User
    Join Date
    05-04-2014
    Location
    Metro DC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need to make over the sheet change for two placeses for every colum every record ...

    Thank you for reply and asking.
    I prefer not to upload the sheet it is a lot more info contained.
    If I have to make change it will take me hours to do about 30 sheets.
    Just asking if there is a easier way even just change one row (24 cells) at a time will save me a lot of time.
    Any suggestion would be very much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] macro for change colum value with link other sheet
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-03-2013, 01:41 PM
  2. copy a range of cells N times and paste in separate sheet and also change a specific colum
    By maramkarthik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2013, 04:27 AM
  3. Replies: 5
    Last Post: 03-29-2013, 02:15 AM
  4. Copy record to new sheet on cell value change
    By rjpace in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-27-2012, 09:50 AM
  5. Replies: 3
    Last Post: 12-08-2005, 06:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1