View original (French)

Report the value of 2 merged cells

Solved
wobson Posted messages 6 Status Member -  
wobson Posted messages 6 Status Member -
Hello, I would like to know how to reference the value of two merged cells into another cell.
I would also like to know if there is a formula to report the end-of-month balances from different sheets of a workbook1, to another workbook2 containing the same number of sheets as workbook1.
Configuration: Windows XP Firefox 2.0.0.6

3 answers

  1.
    sardine-à l'huile Posted messages 731 Status Member 1 178
     
    Hello
    in the second cell, type "=" and then click on the starting cell, then "enter"
    for copying data from one workbook to another, open both, copy in the first workbook from the starting cell, then in the second workbook, right-click, special paste, click on the small box at the bottom "paste with link"
    Joel
    --
    Ad augusta per angusta
    0
    1. wobson Posted messages 6 Status Member
       
      Hello and thank you for the response. As for reporting the value of two merged cells into another cell, your second method works perfectly, that is, copy-paste special-link. Now, regarding the reporting of balances between two workbooks, I find your method to be cumbersome compared to mine. Currently, to do it, I proceed as follows: I do a side-by-side comparison between the two workbooks, then I use the method you mentioned in your first response, that is, typing = in the second workbook and then clicking on the value to report from the first workbook.
      But with more than eighty (80) tabs to report, it's tedious, so I thought there might be a formula or a simpler process, hence my question on the forum.
      0
  2. sardine-à l'huile Posted messages 731 Status Member 1 178
     
    Hello
    Yes, if I understood correctly, it's about transferring the results sheet by sheet from one workbook to another...
    Sorry, I can't see a simpler way, maybe in VBA... a word to the pros
    Joel
    Ad augusta per angusta
    0
  3. wobson Posted messages 6 Status Member
     
    That's exactly it, transferring the results sheet by sheet from one workbook to another identical workbook.
    0