Fwd: $$Excel-Macros$$ copy, Paste macro needed

Hello All, Can someone write a macro for the following 1) If I have 10 files open. 2) copy from cell A3 to last but one row and copy till 'column U' 3)copy the whole data from 10 files, 4) paste in the new excel workbook one after the other 5) next for 'Column V' it should take the file name 6) a

$$Excel-Macros$$ pipe (|) delimited text file filtered country wise

Hi to the forum, Please help me it is very urgent for me i have a text file which is (|) delimited in which it contains all countries files, what i want to do is to create country wise files in .TXT same format. so there will be singapore.txt india.txt etc. i tried but i was not able to complet

Re: $$Excel-Macros$$ Show Values in List

Hi Deepak, Check this Sheet. On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote: > Dear all > > I attached a sample file, the problem is > there are two lists one is Sales_head & other is cities comes under that > sales head > my problem is when i select the sales head in one list then all the

Re: $$Excel-Macros$$ Show Values in List

Hi Deepak, Please check this sheet. It can help you . On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote: > Dear all > > I attached a sample file, the problem is > there are two lists one is Sales_head & other is cities comes under that > sales head > my problem is when i select the sales head

$$Excel-Macros$$ Show Values in List

Dear all I attached a sample file, the problem is there are two lists one is Sales_head & other is cities comes under that sales head my problem is when i select the sales head in one list then all the cities should show under that sales head in another list. Please suggest the solutions Regard