1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying from one sheet to another shee

Discussion in 'Ask an Excel Question' started by thong, Sep 19, 2018.

  1. thong

    thong Member

    Messages:
    61
    Hello All,

    I have a worksheet that contains 26 columns, I want to copy them into another worksheet but its going down, One Column for Date & Time ;One Column for the Sensors ; One Column for Humidity and One column for Temperature.

    Please find attached file.

    Thank you,

    Thong

    Attached Files:

  2. thong

    thong Member

    Messages:
    61
    Attached is the format that I want after copying from another sheet.

    Thank you

    Attached Files:

  3. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    Which 'Humidity' and 'Temperature' should copy?
  4. thong

    thong Member

    Messages:
    61
    Hello vletm,

    If you open my file Auto Copy, "IP B0b/C0b Hum" this is my Humidity Reading and "IP B0b/C0b Temp" is my Temperature Reading I want them copy to another worksheet like the format of my second attachment.

    Thank you
  5. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    Something like this (with VBA)?
    Press the button ...

    Attached Files:

  6. thong

    thong Member

    Messages:
    61
    Hello vletm,

    Thank you for the file. Yes, That's what I want. Could you please expand your code so that all the sensor readings can be copied too.

    Thank you
  7. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    ... all the sensor readings can be copied.
    What is missing?
    Didn't You ask to copy those two readings?
  8. thong

    thong Member

    Messages:
    61
    Hello vletm,

    Sorry for not making myself clear, I want all the sensor readings to be copied down.

    I want also to copy IP B3f Hum to IP Vault_Level_10.

    Thank you
  9. vletm

    vletm Excel Ninja

    Messages:
    4,299
    hmm?
    ... just as Your #4 Reply ...
    That was very clear .. or how?
  10. thong

    thong Member

    Messages:
    61
    Hi vletm,

    I want that If I click the button that you made will copy all the readings of the sensors like the attached.

    Thank you so much for the patient.

    Attached Files:

  11. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    You skipped my question... or how?
    Double work ... so ... wait...
  12. thong

    thong Member

    Messages:
    61
    Sorry, I didn't get what you mean.
  13. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    You asked/verified that You want to copy ONLY those TWO column + A&B-columns.
    Now, You changed that all those 24 columns need to copy ...
    that makes double work!
  14. vletm

    vletm Excel Ninja

    Messages:
    4,299

    Attached Files:

  15. thong

    thong Member

    Messages:
    61
    Sorry for not making myself clear on this post
    . Sorry my bad.

    I need to copy them all.


    Thank you.
  16. thong

    thong Member

    Messages:
    61
    Hi Vletm,

    Can you please extend your help & patience to me.

    Thank you,
  17. thong

    thong Member

    Messages:
    61
    Hi Vletm,

    Thank you for the code, One more request, Can you please revise your code because the last two columns "IP Vault_Level_10H & IP Vault_Level_10"are not included in the copy sheet and the humidity and temperature reading has the same value.

    Thank you
  18. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    Try to write shorter sentences that even I could figure Your needs.
    Use '.' between sentences.

    Change from code
    4 (red) to 6 (green) as below
    For x = 2 To 24 Step 2 ' old code line
    For x = 2 To 26 Step 2 ' modified code line
  19. thong

    thong Member

    Messages:
    61
    Thanks vletm, I did the changed its copying now up tp the last column.

    Please, I would appreciate if you can do some modifications because the reading of the humidity and temperature that being copied are the same.

    **(the readings of IP B0b/C0b Hum /Temp are being populated for all the sensors)

    Sorry for the trouble.

    Thank you
  20. vletm

    vletm Excel Ninja

    Messages:
    4,299
    thong
    What?
    There are over 24000 rows
    >> send exact list of rows, which has something, which would need some modification!
    Your trouble is like below ...
    ... if You want to go to the moon - don't use bicycle! ...
  21. pecoflyer

    pecoflyer Active Member

    Messages:
    258
    Reported as cross post
  22. thong

    thong Member

    Messages:
    61

Share This Page