$$Excel-Macros$$ Re: Introduce Yourself !!

2016-01-29 Thread cavs . mathur
Hello, everybody, This is Vikram S. Mathur, a Chartered Accountant and an avid Excel (VBA) enthusiast to boot. I can answer practically any question relating to Excel Formula or VBA Macros, so please do ask away !! CA Vikram S. Mathur cavs.mat...@gmail.com On Saturday, June 9, 2012 at 12:51:59

$$Excel-Macros$$ Urgent Need: SAP COPA consultant - GA- 6M

2016-01-29 Thread MADHU-GenuineItLlc
Hi, Hope you are doing good, We have below requirement for one of our client, please me know if you have any consultant. *Title: SAP COPA* *Location: Atlanta, GA* *Duration: 6 M* Job description: · More than 10 years of experience need. · Good working knowledge on produc

$$Excel-Macros$$ Urgent need UX Resource in Houston, TX---Need 10+ years only

2016-01-29 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :UI/UX Designer* *Need 10+ years only* *Location : Houston, TX* *Job Description & Key Deliverables: (Web/Mobile Design):* 1. Work with Product Owner to develop mockups for related PBIs

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-29 Thread Mustapha LMIDMANI
Many thanks guys :) 2016-01-29 14:18 GMT+00:00 Paul Schreiner : > Evidently, you don't understand the function (just kidding). > > In the Change Event, > I checked to see if the cell changed is where the filenames are defined: > > Targ.Column = 2 > > I defined the folder as: > > ImageFolder =

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-29 Thread Paul Schreiner
Evidently, you don't understand the function (just kidding). In the Change Event, I checked to see if the cell changed is where the filenames are defined: Targ.Column = 2 I defined the folder as: ImageFolder = "C:\temp\Images\" I read the image name as targ.valueThe location for the image is one c

Re: $$Excel-Macros$$ Range Sorting using a variable

2016-01-29 Thread Paul Schreiner
Look closely at your original macro."normally", the sort technique is to establish the sort "keys"(multiples allowed)Then, set the overall range to be sorted and apply the "keys". So, if your data is in Columns DA:DBYou'd first define how to sort column DA  (SortFields.Add Key:=Range("DA1:DA7986

Re: $$Excel-Macros$$ Sampling - Please check

2016-01-29 Thread Paul Schreiner
See below:Paul- On Friday, January 29, 2016 3:19 AM, SG wrote: Hi Paul, I got the sheet. Thankyou so much for all your effort in this sampling. I'm really thankful. Only one thing i observed is that, in raw data , there are 4 entries of Rohit i

$$Excel-Macros$$ Modification of macro

2016-01-29 Thread Shrinivas Shevde
Dear All Please find attached file which contain macro. Macro will filter the data date basis (date mentioned in F1 and G1) and copy paste filtered data in another sheet. Can anyone help me to modify. Now I want to creat a new workbook in same folder and copy paste the filter data. For eg first I

Re: $$Excel-Macros$$ Sampling - Please check

2016-01-29 Thread SG
Hi Paul, I got the sheet. Thankyou so much for all your effort in this sampling. I'm really thankful. Only one thing i observed is that, in raw data , there are 4 entries of Rohit in Jan but in Random Sampling section, only two are coming as sample for Rohit whereas it should be 4calls,per pers

Re: $$Excel-Macros$$ lookup image from a folder

2016-01-29 Thread Mustapha LMIDMANI
If I understand well the function, I need to have the image in a excel file... but in my case, I have images in a folder. 2016-01-28 18:48 GMT+00:00 Paul Schreiner : > Oops, forgot the attachment. > > *Paul* > - > > > > > > > > *“Do all the good you can,By