Re: $$Excel-Macros$$

On 17 August 2013 12:15, Raj Kumar wrote: > HI Expert, > > i need a formula to calculate based on unique id on other sheet of a > particular product > > Example > > Sheet 1 Unique id > > Id > Product Qty-NIS Only 252939 > > Id Product Qty 25 NIS 5 25 > NAV 25 25 > N 360

$$Excel-Macros$$

HI Expert, i need a formula to calculate based on unique id on other sheet of a particular product Example Sheet 1 Unique id Id Product Qty-NIS Only 252939 Id Product Qty 25 NIS 5 25 NAV 25 25 N 360 30 29 NIS 25 29 NAV 20 29 N 360 20 39 NIS 25 39 NAV 2

Re: $$Excel-Macros$$ need basic macro commands - Reg

thanks On Sat, Aug 17, 2013 at 10:22 AM, xlstime wrote: > try below link > > http://www.excel-pratique.com/en/vba.php > > . > > Enjoy > Team XLS > > > > On Thu, Aug 15, 2013 at 1:13 PM, jmothilal wrote: > >> Dear All >> >> Request to send basic macro commands like for

Re: $$Excel-Macros$$ Copy Data From One Sheet to Multiple Sheets

can u share a sample file On Sat, Aug 17, 2013 at 1:46 AM, Rahul Jain wrote: > I have one excel file wherein i have alphanumeric data in cells A1:A85 & > B1:B85. (In Sheet 1) > > I have another 85 sheets in the file. I want to pull data of A1 into D20 & > data of B1 into E20 (In Sheet 2) > > I

Re: $$Excel-Macros$$ need basic macro commands - Reg

try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Thu, Aug 15, 2013 at 1:13 PM, jmothilal wrote: > Dear All > > Request to send basic macro commands like for loop, assigning value , > detecting row and column value .. etc > > i know the c

Re: $$Excel-Macros$$ identifying no of people people in a particular age

Hi, Try below code for consolidate worksheet.. then use pivot table for 2nd requirement or send the example sheet Sub Combine() Dim NumSheets As Integer NumSheets = Worksheets.Count Worksheets(1).Select Sheets.Add ActiveSheet.Name = "Consolidated" For X = 1 To NumSheets Worksheets(X + 1).Select

Re: $$Excel-Macros$$ Macro for COPY Paste

Hi can u share some sample files and output workbook On Fri, Aug 16, 2013 at 12:38 PM, Shrinivas Shevde wrote: > Dear Ashish > I try this macro but there is a samll pr > oblem when I open folder folder shows empty .actually there are 3 to 4 > excel worksheets in the folder > > Regards > Shriniva

$$Excel-Macros$$ Copy Data From One Sheet to Multiple Sheets

I have one excel file wherein i have alphanumeric data in cells A1:A85 & B1:B85. (In Sheet 1) I have another 85 sheets in the file. I want to pull data of A1 into D20 & data of B1 into E20 (In Sheet 2) I want to do these in all the 85 sheets in sequential order. i.e. Sheet 2 should pull data o

$$Excel-Macros$$ identifying no of people people in a particular age

Hi Friends , I have 226 seperate excel files ..i would like to do some analysis 1) As the first thing I would like to bring all 226 excel files into one excel file but with different sheets ( i would like to have 226 sheets in one excel file) 2) After the first thing i would like to do

$$Excel-Macros$$ how to add multiple excels

Hi, I have 225 excel files ,i would like to bring them into one excel file but i would like to have 225 sheets in One excel file ...is there any way i can do this ... I appreciate your help -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Jo

Re: $$Excel-Macros$$ Macro for COPY Paste

Dear Ashish I try this macro but there is a samll pr oblem when I open folder folder shows empty .actually there are 3 to 4 excel worksheets in the folder Regards Shrinivas On Fri, Aug 16, 2013 at 8:48 AM, Shrinivas Shevde wrote: > Dear ashsish > Thanks for reply I will run the same and will le