+ Reply to Thread
Results 1 to 7 of 7

Which formulas I should use? Please help.

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    khachmaz
    MS-Off Ver
    Microsoft 2010
    Posts
    4

    Which formulas I should use? Please help.

    Hello,

    I need your help.

    I want to create two separate sheets (lets say SHEET 1 and SHHET 2) which in one sheet (SHEET 1) there is going to be data which I will daily add informtion. In other sheet (SHEET 2) I want data to be added automatically when I add data to SHEET 1. Which formulas I should use. Thanks in advance.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Ismat1993; 05-09-2021 at 08:10 PM.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Which formulas I should use? Please help.

    so you end up with 2 the same sheets ?

  3. #3
    Registered User
    Join Date
    02-13-2020
    Location
    khachmaz
    MS-Off Ver
    Microsoft 2010
    Posts
    4

    Re: Which formulas I should use? Please help.

    As you can see from pic I add information here and I want to see these data to be included automatically to another sheet which is daily statement.You can see both of the sheets from file I attached. I new in Excel that's why I don't know which formulas I can use?
    Last edited by Ismat1993; 05-10-2021 at 05:29 AM.

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Which formulas I should use? Please help.

    Dont know if this is possible with formula
    maybe solution with vba

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-13-2020
    Location
    khachmaz
    MS-Off Ver
    Microsoft 2010
    Posts
    4

    Re: Which formulas I should use? Please help.

    It is working but first I need to add data to Sheet 2 then I want it to be added to Sheet 1 in the file. Soory It is my mistake I metioned the sheets wrongly at first.

  6. #6
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Which formulas I should use? Please help.

    Then code for sheet2

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-13-2020
    Location
    khachmaz
    MS-Off Ver
    Microsoft 2010
    Posts
    4

    Re: Which formulas I should use? Please help.

    Mr. Leo that is what I want. Big Thanks. But how can apply this code to other files as well ? And I want to know how to work with VBA codes. Where I should start from? Any recommendation?

+ 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] How to report the top 20 and bottom 20 of a data table? + report with 2 conditions
    By Luu4466 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2020, 07:18 AM
  2. Automatically Pull in New Report Data Into Excel
    By coltan123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2020, 05:35 AM
  3. Replies: 3
    Last Post: 06-19-2020, 12:01 AM
  4. formatting pivot table report (borders automatically showing)...
    By Perplexed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2014, 02:29 PM
  5. Replies: 0
    Last Post: 01-16-2013, 12:14 AM
  6. [SOLVED] How do I automatically transfer data from one Excel report to another?
    By s3a in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2012, 01:38 AM
  7. Pull data from a matrix table into a report using 2 report conditions
    By bing in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2008, 11:51 AM

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