$$Excel-Macros$$ Address of a value with in the workbook.

Hi Group, I need to create a formula that will give the cell address of a value from the whole workbook. Attached is the sample sheet for easy reference. -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:

$$Excel-Macros$$ Pivot Table

Hello All, Can any one provide the macro code to make a pivot table -- 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) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Formatting the Table (Pivot Table data)

Dear All , Very Good Morning and Have a Nice Day . I have made Macro but formatting data. but few formatting i am not able to create. i have enclose the same data with example . Below are the details which i want to : Heading bold with Grey color- each Table Grand Total with Bold -each Table

Re: $$Excel-Macros$$ VBA Macro to take list of multiple inputs, apply to another spreadsheet, and return value

Hi Derick , Try the below code. Sub Multiple_Inputs() For i = 1 To 20 Sheet2.Cells(i + 1, 1) = i + Sheet1.Cells(2, 1) - 1 Next i For j = 1 To 20 Sheet2.Cells(j + 1, 2) = j + Sheet1.Cells(2, 2) - 1 Next j For k = 1 To 20 Sheet2.Cells(k + 1, 3) = k + Sheet1.Cells(2, 3) - 1 Next k Fo

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

yes its working if I give a static value or if I take a value from single cell On Saturday, September 21, 2013 10:08:09 PM UTC+5:30, ashish wrote: > > Is it working if u pass a single cell value only > Sent on my BlackBerry® from Vodafone > -- > *From: * Menaka Balakr

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

Is it working if u pass a single cell value only Sent on my BlackBerry® from Vodafone -Original Message- From: Menaka Balakrishnamoorthy Sender: excel-macros@googlegroups.com Date: Sat, 21 Sep 2013 08:12:52 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How t

$$Excel-Macros$$ VBA Macro to take list of multiple inputs, apply to another spreadsheet, and return value

I want to create a macro to take multiple inputs from sheet 2, apply them simultaneously to the inputs on sheet 1, take sheet 1's output and list next to the inputs on sheet 2. I want to apply this to a spreadsheet with complicated calculations. Example spreadsheet attached. Related Macros I ha

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

Please don't rely on the web address,it on my VM.please provide me the solution On Saturday, September 21, 2013 8:21:06 PM UTC+5:30, ashish wrote: > > can't access the web adress > > > On Sat, Sep 21, 2013 at 8:04 PM, Menaka Balakrishnamoorthy < > menaka.ba...@gmail.com > wrote: > >> Hi, >> >> I

Re: $$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

can't access the web adress On Sat, Sep 21, 2013 at 8:04 PM, Menaka Balakrishnamoorthy < menaka.balakris...@gmail.com> wrote: > Hi, > > I want to copy a range of cells from excel sheet to a text field of a web > page. Below is my macro, while executing it 'm getting run time error 70. > Please h

$$Excel-Macros$$ How to paste a range of cells from excel to text field of a web page

Hi, I want to copy a range of cells from excel sheet to a text field of a web page. Below is my macro, while executing it 'm getting run time error 70. Please help me in resolving it asap Sub GetTable() Dim ieApp As InternetExplorer Dim ieDoc As Object Dim ieTable As Object

$$Excel-Macros$$ Re Help with Date probs

This is not actually a question but just a big THANKYOU to the three responses to by prob. Thanks heaps guys! The key just below Esc combined with Control brought back my original formatting. Cant tell you how thrilled I was to see it! Thanks so much for your help. cheers from Australia! --

Re: $$Excel-Macros$$ need help urgent

thanks On Sat, Sep 21, 2013 at 6:24 PM, ashish koul wrote: > hv u tried vlookup > > =VLOOKUP(C6,Sheet1!C:E,3,0) > > > > On Sat, Sep 21, 2013 at 6:22 PM, TIWARI wrote: > >> dear expert, >> I am attaching a file data of invoice value of abc ltd to copy of another >> sheet in blank invoice coloum

Re: $$Excel-Macros$$ need help urgent

hv u tried vlookup =VLOOKUP(C6,Sheet1!C:E,3,0) On Sat, Sep 21, 2013 at 6:22 PM, TIWARI wrote: > dear expert, > I am attaching a file data of invoice value of abc ltd to copy of another > sheet in blank invoice coloum . Pls help me urgently. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

Re: $$Excel-Macros$$ Help for Copy paste

Dear Ravindra Great job thanks. my problem is resolved Now just for the knowledge is there any way to delete all blank rows where there is formula but no value as in my case Thanks once again Regards Shrinivas On Sat, Sep 21, 2013 at 1:23 PM, Ravinder wrote: > pfa > > ** ** > > *From:* exce

$$Excel-Macros$$ small doubt of conditional format and vlookup

hi friends, i have a small doubt for conditional formatting to highlight a date... and a small vlookup formula doubt. pls help. Thanks in adv. -- 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) ! Join official Facebook page of this forum @ https:

$$Excel-Macros$$ Help for Copy paste

Dear All I am facing problem in find out blank cell at one go ,because that cell content formula. Please find attached sheet Thaks in avance -- Shrini -- 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) ! Join official Facebook page of this forum @