Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Leo
hi I'm new here just trying to help by making some improvement changes [image: ] *Sub Copy_Filtered_Data()* *'know line os last row* *Dim last_row* *last_row = Range("s64000").End(xlUp).Row 'using in excel 97 or 2010* *'last_row = Range("s1048576").End(xlUp).Row 'using only in excel

$$Excel-Macros$$ Select all excel files in computer

2015-10-07 Thread Pankaj Michael
Hi to ALL, Can we search ALL excel extension files through vba in a computer(All Drives) through VBA? Transfer to any other location. Priority is excel I want to shift all excel files from one computer to another because company is replacing systems and only ms office files needs to transfer as

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
Abhishek, snarky...I like it! :) Paul From: Abhishek Jain To: MS EXCEL AND VBA MACROS Sent: Wednesday, October 7, 2015 2:37 AM Subject: Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop Yes,

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
Mr PRADEEP, Mr. Abhishek may be being a bit "snarky", but he has correctly answered your question. Yes, "we" can. But because there's not NEARLY enough information in your question, we'd either have to begin asking for lots more information, or make assumptions. You didn't give us much to go

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

2015-10-07 Thread Paul Schreiner
In your formula: =VLOOKUP(B4,DATASET,7,FALSE) The range DATASET contains column A:G VLOOKUP(Bmeans that it's comparing the value in column B to the value in column A of sheet2.There are no matches. you need to change it to:=VLOOKUP(A4,DATASET,7,FALSE)it was probably copied from column F,

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

2015-10-07 Thread Anil Gawli
pls share the work sheet On Wed, Oct 7, 2015 at 3:27 PM, abhishek bhalla < bhalla_abhis...@rediffmail.com> wrote: > Hi all, > > > > I want to combine data from different cells into a single. For example: > > > > A apple > > A ant > > A antique > > B bat > > B big > > > > I would like to collate

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

2015-10-07 Thread Paul Schreiner
Is this related to "VLOOKUP NOT WORKING"? I suspect you've "hijacked" Izhar's thread. see forum rules #2:> 2) Don't post a question in the thread of another member. I'll be glad to help, but don't wish to confuse another discussion. Paul- “Do all the good

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

2015-10-07 Thread abhishek bhalla
Hi all, I want to combine data from different cells into a single. For example: A apple A ant A antique B bat B big I would like to collate data like: A apple, ant, antique B bat, big The letters and words should be in separate columns. Please help I need it urgent. Regards Abhishek Bhalla

$$Excel-Macros$$ Direct client need C++ Developer-Austin, TX

2015-10-07 Thread MADHU-GenuineItLlc
Hi Partner , Hope you are doing great …. Please send resume to ma...@genuineitllc.com *Title : C++ Developer* *Location :Austin, TX—LOCALS ONLY * JD:- WORKER SKILLS AND QUALIFICATIONS · Strong written, verbal, and interpersonal communication skills · Must be able to

$$Excel-Macros$$ Direct Client need Technical Writer-Austin , TX

2015-10-07 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great…. Please send resume to ma...@genuineitllc.com *Title : Technical Writer* *Location : Austin , TX* WORKER SKILLS AND QUALIFICATIONS *Minimum Requirements:* Years Skills/Experience 8 Ability to develop communication materials for

$$Excel-Macros$$ Urgent need SAP FI in Houston, TX--LOCALS ONLY

2015-10-07 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great…. Please send resume to ma...@genuineitllc.com *Title : SAP FI* *Location : Houston, TX* JD:- Following is the SAP FI skill set we are looking for · SAP FI - AP, AP, GL, Assets generic skills · 8-10 yrs experience --- *With Warm

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Abhishek Jain
Yes, we can. On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > Hello all, > > Can you write code for to filter(Column S)-> select the complete visible > data and paste it in new workbook and save it. > > Example: Column S can have 50 lines data with 10