+ Reply to Thread
Results 1 to 11 of 11

Transfer YTD to my other months which are in separate sheets

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Transfer YTD to my other months which are in separate sheets

    hello, how are yall

    I need to know the formulas for my D, E, F & G columns and In column E, F & G how to make the formulas transfer YTD to my other months which are in separate sheets.... PLease help
    Attached Files Attached Files
    Last edited by AliGW; 02-06-2020 at 12:49 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Formulas please

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I will do it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: Formulas please

    Ok I am sorry I have never used the forums before and I apologize....

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Transfer YTD to my other months which are in separate sheets

    You just changed my title for your thread with something just as useless as you had before!

    Please note the title I've used: it tells us what you are trying to do. We know you need help and most people need help with a formula ...

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Transfer YTD to my other months which are in separate sheets

    I have edited your title to something acceptable: please leave it alone. Your titles are not good enough. Thanks.

  6. #6
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: I need help with formulas for my actual expense report

    I have attached a piece of my report and want to know the formulas for column D, E, F & G and then the YTD to transfer to the other months that are in separate sheets.

  7. #7
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: Transfer YTD to my other months which are in separate sheets

    ok sorry I will leave it alone

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Transfer YTD to my other months which are in separate sheets

    You already have formulae in D, E, F and G.

    There are no other tabs in the workbook - where are you wanting to transfer the data?

  9. #9
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: Transfer YTD to my other months which are in separate sheets

    are the formulas correct? The 3 YTD's, I need those totals to carry over to February and then at the end of Feb to carry the YTD into March and so on

  10. #10
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: Transfer YTD to my other months which are in separate sheets

    and then the subtotals for line 10 are they correct? should I just be totaling that particular column or should the formula be the same as (for example: F4 formula vs the subtotal in F10) the rest of the column?

  11. #11
    Registered User
    Join Date
    02-05-2020
    Location
    Williston North Dakota
    MS-Off Ver
    nd
    Posts
    7

    Re: Transfer YTD to my other months which are in separate sheets

    ok I have added a second sheet to my report... can you see it or do I have to attach it again?
    Last edited by mistywidel; 02-06-2020 at 01:08 PM.

+ 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. Make model faster: convert formulas to text and then back to formulas
    By lucassdm7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-25-2019, 06:49 AM
  2. Replies: 3
    Last Post: 01-01-2016, 03:44 PM
  3. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  4. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  5. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  6. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 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