Search results for query: *

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

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

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

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

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

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

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

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?

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?

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

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.

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

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

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?

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

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

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

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

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

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