column address

Hello Team, Hope anyone can help with below query.... I have input data however data columns may change everytime (Header name will not change) for example if I have Customer Name in A1-column next time Customer Name column may get in C1-column. I have one macro where will refer these data...

Hello Everybody, In another post I received help from @Rihabr & @Scott on how to find text in a specific range. (http://www.mrexcel.com/forum/excel-questions/798738-how-find-text-specific-range.html) Currently, I am working on an excel sheet where I have to search for a specific 'Date' in row...

Hi All, I'm looking for macro code to copy paste the data into different sheet. I would receive different files every time with same format but heading will not be in same column (but all columns will be there but not in order every time). My concern is how to copy the data which has unique...

Hi again So as part of this seemingly never-ending project, there is a section of code which needs to find the last column before a blank column. So currently I am using some slightly modified code I found on google, but rather than give just the column address it gives the address of the 1st...

Hi, I want to use a macro (with Excel VBA 2003) that 1- finds the cell containing a specific value 2- goes to the cell on line 7 of the same column as the found cell I have tried to find that answer online but could not figure it out. The start of my macro looks like that: Dim ValT as...

Hello, I am looking for help on this: I want to get the column number, if some text (say "Clicks") are found in heading (Row 2). I want to use this variable as reference to column number with rest of my code. Thanks,