+ Reply to Thread
Results 1 to 7 of 7

Values not posting from one workbook to another

  1. #1
    Registered User
    Join Date
    04-29-2020
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365, Office 2019
    Posts
    21

    Post Values not posting from one workbook to another

    I have attached 2 sample workbooks.

    The test-data.xls file is an older version of excel and cannot be changed to a newer version.

    The data in range A2:H4 needs to be pasted as values into the range B5:I9 on the reporting workbook file, formula-test-sheet.xlsx. I have not changed anything and now when I paste the values into the report, the formula does not output the values in Column F, the Count column.

    I am using Office 365.

    Any help on this would be appreciated.

    Thanking you in advance.

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Values not posting from one workbook to another

    Quote Originally Posted by ben.cote View Post
    . . . data in range A2:H4 needs to be pasted as values into the range B5:I9 on the reporting workbook file . . .
    Typo? A2:H4 is 3 rows. B5:I9 is 5 rows.

  3. #3
    Registered User
    Join Date
    04-29-2020
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365, Office 2019
    Posts
    21

    Re: Values not posting from one workbook to another

    I have attached 2 sample workbooks.

    The test-data.xls file is an older version of excel and cannot be changed to a newer version.

    In test-data.xls range A2:H6 needs to be pasted as values into range B5:I9 on the reporting workbook file, formula-test-sheet.xlsx.

    In cell F12 on the reporting file, I have added a sum for range F5:F9. When you paste the values in from the data workbook it does not the range either.

    I have not changed anything and now when I paste the values into the report, the formula does not output the values in Column F, the Count column.

    I am using Office 365.

    Any help on this would be appreciated.

    Thanking you in advance.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-29-2020
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365, Office 2019
    Posts
    21

    Re: Values not posting from one workbook to another

    Thank you for your comments. Does it work on your machine? If it does then I have an issue with Exel. Please check the new files I have uploaded.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Values not posting from one workbook to another

    The values are copied across for me, but as they are stored as text in the source file, the SUM formula still returns 0.
    Rory

  6. #6
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Values not posting from one workbook to another

    Indeed.

    Arguably better to copy the VehicleCountingData worksheet from text-data.xls into formula-test-sheet.xlsx, then use formulas to pull data into the DATA worksheet in formula-test-sheet.xlsx, e.g., select DATA!B5:I9 with B5 the active cell, type =VehicleCountingData!A2, then hold down [Ctrl] before pressing [Enter] to fill that formula into all selected cells. Then change the DATA!F5:F9 formula by selecting DATA!F5:F9 with F5 the active cell, type =IF(ISNUMBER(--VehicleCountingData!E2),--VehicleCountingData!E2,VehicleCountingData!E2), then hold down [Ctrl] before pressing [Enter] to fill that formula into all selected cells. That'd transform the data as needed. Otherwise either macros or manual Text to Columns would be needed to convert the numeric text to numbers.

  7. #7
    Registered User
    Join Date
    04-29-2020
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365, Office 2019
    Posts
    21

    Re: Values not posting from one workbook to another

    Thanks again for the information. I have the developer looking into the .xls file exported from the device. It is supposed to be outputting numbers in that column, not text. I had used the Data text to columns before, but then the output was fixed by the developer, so I did not need to convert it. I guess they have screwed it up again on the latest revision of the app.

+ 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. Posting a workbook online for group editing
    By Bobbbo in forum Excel General
    Replies: 2
    Last Post: 02-23-2019, 09:58 AM
  2. [SOLVED] Comparing 2 rows and posting different values to a third row
    By JHanlon110 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2018, 11:52 AM
  3. Posting Unique Values (Other Than Using Advanced Filter)
    By brandnew22 in forum Excel General
    Replies: 2
    Last Post: 08-06-2013, 08:55 AM
  4. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  5. posting values from one sheet to another
    By hanymon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2007, 09:10 PM
  6. [SOLVED] Workbook sharing and web page posting
    By Stephanie in forum Excel General
    Replies: 0
    Last Post: 07-26-2005, 01:05 AM
  7. [SOLVED] posting values
    By lisa in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-18-2005, 01:06 PM

Tags for this Thread

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