• 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...

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

Search results

  1. T

    Copying

    Sorry for that...how can I delete and update my old thread? Thank you.
  2. T

    Copying

    Hello, They are almost they same but this one is more complete data. Thank you.
  3. T

    Copying

    Hello Gurus, Hope all is well. In my attached file the content of the upper table I want to copy them on my below table. I want to copy only the Avg and SD of the 3 products. Attached is the sample sile that Im working on. Thank you so much.
  4. T

    Copying Alternate Column in excel

    Hello All, I need help. I have a 280 Tables that I would like to copy in a different format. I have attached the sample of my file. I want to copy Table 1 to table 2 Format. Crossposted https://www.excelforum.com/excel-general/1277966-copying-alternate-column-in-excel.html#post5130423 Thank...
  5. T

    Extract Readings from One sheet to another sheet

    If I copy the time ending in .12 I will change it to + TimeSerial(0,12,0) -? Thanks
  6. T

    Extract Readings from One sheet to another sheet

    Hi Vletm, Question, What part of the code Im going to change if I want to copy different time ending like .12 ; or .27. Thank you so much.
  7. T

    Extract Readings from One sheet to another sheet

    Hi vletm, There's no missing date. What I mean is for example when I change the month for February, it will automatically copy the dates too.. Thank you
  8. T

    Extract Readings from One sheet to another sheet

    Hi vletm, Thank you so much! Im crying for another help, can you please do also extraction of the dates. Thanks,
  9. T

    Extract Readings from One sheet to another sheet

    Hello All, I have a reading of temperatures and Humidity for one month every five minutes. My problem is I want to copy only selected time to another worksheet. the Time that I want to copy are, 1/1/2019 0:02 1/1/2019 1:02 1/1/2019 2:02 1/1/2019 3:02 1/1/2019 4:02 1/1/2019 5:02 1/1/2019...
  10. T

    Copying from one sheet to another shee

    Sorry for not letting you know immediately that I also posted this question to the following link https://www.excelguru.ca/forums/showthread.php?9433-Copying-from-one-sheet-to-another-sheet https://www.excelforum.com/excel-general/1245955-copying-from-one-sheet-to-another-sheet.html Thank you
  11. T

    Copying from one sheet to another shee

    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...
  12. T

    Copying from one sheet to another shee

    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
  13. T

    Copying from one sheet to another shee

    Hi Vletm, Can you please extend your help & patience to me. Thank you,
  14. T

    Copying from one sheet to another shee

    Sorry for not making myself clear on this post . Sorry my bad. I need to copy them all. Thank you.
  15. T

    Copying from one sheet to another shee

    Sorry, I didn't get what you mean.
  16. T

    Copying from one sheet to another shee

    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.
  17. T

    Copying from one sheet to another shee

    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
  18. T

    Copying from one sheet to another shee

    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
  19. T

    Copying from one sheet to another shee

    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
  20. T

    Copying from one sheet to another shee

    Attached is the format that I want after copying from another sheet. Thank you
  21. T

    Copying from one sheet to another shee

    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
  22. T

    Dynamically change excel sheet names

    This question is also posted to https://www.excelforum.com/excel-general/1226297-dynamically-rename-a-worksheet-name.html
  23. T

    Dynamically change excel sheet names

    Hi vletm, Thanks for the reply. I would appreciate if you can make a work around on your code to suite my case. Thank you so much.
  24. T

    Dynamically change excel sheet names

    Hello, This is a follow up regarding my above post. I tried to play with the code but it will not work with my attached file. I would appreciate if someone could direct me so that I can change dynamically my sheet names. Please find attached file that Im working. Thank you.
Back
Top