Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TBL3
  • Order by date
  1. TBL3

    Retrieving new data through drop down list

    Hi, I have lots of amount of raw data for each category. And I was trying to see if there was any coding available for me to sort my data easier. So, for example, for the following categories: building A, building B, & building C, it contains lots of raw data. Hence, within building A, x =...
  2. TBL3

    Linking Postal Code to populate to appropriate address

    Thanks all for the suggestions. Much appreciated. Cheers, Tbl3
  3. TBL3

    Linking Postal Code to populate to appropriate address

    My bad for not being clear enough. Butyea, magic... lol Well, I was wondering if excel had a feature that once the cell has been clicked, google map might populate or something like that. But if there isn't a simple way, then I guess I just have to make the list myself and then looking up...
  4. TBL3

    Linking Postal Code to populate to appropriate address

    Hi, I am not sure why you would recommend AutoFilter. Does Autofilter have functionalities that recognizes postal codes and populate the correct address? Or, maybe I was not clear enough. The list I have is ONLY the postal codes. I do not have the address for each of the postal codes I have...
  5. TBL3

    Trasferring data from current workbook to a new workbook

    I don't think I will use the code you have. I will just go with using GetOpenFilename App. To be honest, don't fully understand your code on how to incorporate to my case specifically. Thanks
  6. TBL3

    Trasferring data from current workbook to a new workbook

    Hi, I believe using MS Query wouldn't work. After reviewing the site you have linked, one of the requirements is to form a table of somesort or using tables. However, the cells I would like to transfer are not in a table format, but is more similar to an application form. Am I understanding...
  7. TBL3

    Trasferring data from current workbook to a new workbook

    Hi, I currently completed building a template that requires many fields to be inputted. However, my concern is that I would like to build a macro that can transfer all the data that I have inputted already in the current template into a new template with the exact same format. One thing to...
  8. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    You have said previously that I could only copy continguous ranges. And I thought this was due to use of OpenFileName. If that is not the case, why can I only copy continguous ranges? And in order to copy non-continguous ranges, is there a specific way to do so?
  9. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    If there are cells that are non-continguous that needs to be copied, I can't use Application.GetOpenFileName method then?? If so, do I have to use the logic I had previously, or is there a better way?
  10. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    NVM. By the way, is there a way to unlock or lock cells? Is this possible in Excel? Or, I should approach this differently?
  11. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    FYI, there are very limited space to do anything on this sheet. This is why I was hoping that the fields can be locked or unlocked depending on the dropdownlist cell.
  12. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    By doing this, I don't understand how a locked cell becomes unlocked or vice versa for user entry.
  13. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    I know this is not an ideal strategy. However, I do not have a choice. The functionalities are already built in, with numerous sheets referencing each other. The formula for the cells are already contingent to the dropdownlist cell. Depending on what the user chooses, the values defer due to...
  14. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    I was wondering if this is even possible, and if it is, would ELSEIF do the job? But I just don't know if a formulated cell can be unlocked with no forumlas and locked with formula depending on what is chosen from the drop down list. Is this possible?
  15. TBL3

    unlocking/clearing cell that is formulated depending on drop down list

    Hi, My situation is that there is a cell that contains dropdown list. And next to that cell, there are cells that is formulated so it calculates the values desired. However, I wish to have few exceptions depending on what they choose from the drop down list. Depending on what the user choose...
  16. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    What if there are more than those cells. For example, I16, K20, O100, etc. ??
  17. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    Skip, I started adding other cells that needs to be copied, and when I ran the macro, the information gets pasted two times. Ex. Active Sheet cell F5 = hello, New Sheet cell F5 = hellohello Why is this so?? Private Sub Renewal2() On Error Resume Next Application.ScreenUpdating =...
  18. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    So basically just use the code you have provided exactly. Thanks for your help. Cheers, tbl3
  19. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    I just want to make couple clarifications. 1. The sheet defined in "??????" should be the name of the active worksheet? am I correct? Workbooks(copyfrom).Sheets("??????").Range("$F$4").Copy 2. I just repeat and replace $F$4 for all the fields that needs to be copied from the active sheet...
  20. TBL3

    Renew button - Application.ScreenUpdating (Transferring Information)

    I'm not sure if I understood fully. Will it look like this? Private Sub Renewal2() On Error Resume Next Application.ScreenUpdating = False Dim copyfrom Dim copyto Dim wsTHIS As Worksheet Set wsTHIS = ActiveSheet copyfrom = ThisWorkbook.Name copyto =...

Part and Inventory Search

Back
Top