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

Recent content by GN0001

  1. G

    Are Macros enough for automating reports in Microsoft Excel?

    Hello Hui, What is the output of these Controls going to be used for? This technology can be used for so many subjects, for example, end user can select the entries and pull members for a state or for a specific city. Slicers can work; but I really like learning how to build synched combo...
  2. G

    Are Macros enough for automating reports in Microsoft Excel?

    Hello Hui, I have two List boxes; I want the end user select a state from a list box and only the cities for that state to show in the second list box. To map correct cities for correct states, I had to repeat name of states. ---------------------------------------------------- Hui: I have...
  3. G

    Are Macros enough for automating reports in Microsoft Excel?

    I will do it soon. Regards, GN0001
  4. G

    Are Macros enough for automating reports in Microsoft Excel?

    ==================== If I want to create two synchronized combo boxes in Excel, can this be done by macros? GN0001
  5. G

    Are Macros enough for automating reports in Microsoft Excel?

    Hello team, Are macros enough for automating reports? Please advise me. GN0001
  6. G

    Start.xlsb file

    Team, I have recorded a macro (whenever I create a macro, my Excel workbook doesn't behave as normal and I am in trouble). -When I want to open my Excel workbook, my Excel workbook starts as a read only, how can I fix it? -I hid Personal.xls file, when I want to record a new macro, it says...
  7. G

    Cell changes from text to number

    Hello team, I am working on a spreadsheet. The cells values are text, as soon as I copy the cell, it changes to number and drops the leading zeros. I have to change the cell again to text by going to format dialog box and I have to do it several times, until I get the values saved as a text in...
  8. G

    How can we fill out the values:

    You can see the output in sheet2. I don't know how to use VBA code. Please send functions. Regards, GN
  9. G

    How can we fill out the values:

    Hello all, I need the values of Category1 and Category2 and Category3 be placed in once column Test1, Test2, Test3 in second column I mean I need any entry in column c has category and test mapped to it. Any idea? Please open the attachment. Regards, GN
  10. G

    Combine 3000 Excel Spreadsheets

    Yes, I saw that is addressed before. Thanks for it. GN
  11. G

    Combine 3000 Excel Spreadsheets

    Hello team, Is it possible to combine the data inside of lots of Excel Spreadsheets? Please advise me. How about VBA code? Thanks, GGGGGNNNNN ------------------------------------------------------------------------------- Mod Edit: Question moved to VBA section
See more
Back
Top