+ Reply to Thread
Results 1 to 12 of 12

How to copy the formulas that refs. worksheet "A" to the next row that refs Worksheet "b

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    hawaii
    MS-Off Ver
    Excel 2007
    Posts
    5

    How to copy the formulas that refs. worksheet "A" to the next row that refs Worksheet "b

    Aloha,

    How do i copy row 1 Formulas that reference Worksheet "A" to the next row, row 2 and reference worksheet "b"

    It is pretty much a summary sheet of the totals all of the worksheets created.

    HELP ME AHhhhhhh

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    Highlight row 2 and simply FIND and REPLACE the worksheet names

  3. #3
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    one way would be to copy the formula as is, then highlight row 2, click the find and replace, in find what 'worksheet A name', in replace with 'worsheet B name', then replace all

    hope that helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  4. #4
    Registered User
    Join Date
    11-09-2012
    Location
    hawaii
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    I did that but is their a short cut? i have about 18 formulas in the row and i am planning on doing 20 rows of the same rows referencing 20 worksheets.

  5. #5
    Registered User
    Join Date
    11-09-2012
    Location
    hawaii
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    uu tha is a good idea... i'll try it too

  6. #6
    Registered User
    Join Date
    11-09-2012
    Location
    hawaii
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    Thanks Dreadwolf and djapigo

  7. #7
    Registered User
    Join Date
    11-09-2012
    Location
    hawaii
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    @ Dreadwolf how do i attach a sample? lol sorry i am not familiar with this site

  8. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    the 18 formulas are fairly easy, just select them all when you copy down to the next row, that will save the individual copying of them, not sure what you would do to simplify the find and replace tho

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,990

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  10. #10
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    when you post a reply, click the go advanced button at bottom of edit area, use the manage attachments in the additional options, that should take you to the attachment area, browse to your file, sect upload file, then you should have an attachment added to your post...i may be missing a step or too, but it is fairly self explanatory...

    hope that helps

  11. #11
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    Thanks FDibbins, I almost always forget a step or two when i try to explain this

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,990

    Re: How to copy the formulas that refs. worksheet "A" to the next row that refs Workshee

    I have that as a canned reply, not sure if you have access to them though. If not, I have a workbook that I store "useful junk" in, and I have a sheet in that for instructions/suggestions so I can just copy/paste

+ 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