Hi Deepak rawat !
I saw the solution you have provided is working perfectly and also
implementing immediately that's a very good job doing by a VBA
function "OFFSET" I will highly appreciate.
On May 22, 1:20 pm, kishan@gmail.com wrote:
> Hi,
> I did this with vba, but I am unable to attach
Hi,
I did this with vba, but I am unable to attache excle file. so I
paste this code to here...
--
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err1:
Static l As Integer
Static i As Integer
If Target.Value = "" Then
Hi,
See the attached file. I will help i think.
Regards
On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote:
> Hi all! i have attached a file, there is 5 fields in the file
> my requirement is, as i put city name in city field, then all the field
> should fill accordingly
> like as i put Mumb
Hi
thanks for revert but i dont want to use vlookup. I want macro code for
entering name n nos.
for example:
if i put Delhi in City field then name and phone nos of ADM and GM of Delhi
should automatically come in theri fields. Same as i put Mumbai .
Regards
Deepak Rawat
On Wed, May 20,
Hi Deepak,
You can use the VLOOKUP formula.
Check the sheet2 in the attached file.
Revert for clarifications.
Regards
hpreddy
On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote:
> Hi all! i have attached a file, there is 5 fields in the file
> my requirement is, as i put city name in city