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

2013-09-21 Thread Bala
Bala Iyer From Mumbai On Sat, Sep 21, 2013 at 11:10 AM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Hi My name is Rupesh from Pune Maharashtra, India. I am working as technical support engineer and customer support engineer. I am looking for VBA help. actually I have task assigned to build

$$Excel-Macros$$ Help for Copy paste

2013-09-21 Thread Shrinivas Shevde
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

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

2013-09-21 Thread Kenil Gala
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 @

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

2013-09-21 Thread Shrinivas Shevde
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 ravinderexcelgr...@gmail.comwrote:

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

2013-09-21 Thread ashish koul
hv u tried vlookup =VLOOKUP(C6,Sheet1!C:E,3,0) On Sat, Sep 21, 2013 at 6:22 PM, TIWARI tiwariin...@gmail.com 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

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

2013-09-21 Thread TIWARI
thanks On Sat, Sep 21, 2013 at 6:24 PM, ashish koul koul.ash...@gmail.com wrote: hv u tried vlookup =VLOOKUP(C6,Sheet1!C:E,3,0) On Sat, Sep 21, 2013 at 6:22 PM, TIWARI tiwariin...@gmail.com wrote: dear expert, I am attaching a file data of invoice value of abc ltd to copy of another

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

2013-09-21 Thread DawnS
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! --

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

2013-09-21 Thread Menaka Balakrishnamoorthy
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

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

2013-09-21 Thread ashish koul
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 help me

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

2013-09-21 Thread Menaka Balakrishnamoorthy
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 javascript: wrote: Hi, I

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

2013-09-21 Thread Derick Jones
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

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

2013-09-21 Thread koul . ashish
Is it working if u pass a single cell value only Sent on my BlackBerry® from Vodafone -Original Message- From: Menaka Balakrishnamoorthy menaka.balakris...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 21 Sep 2013 08:12:52 To: excel-macros@googlegroups.com Reply-To:

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

2013-09-21 Thread Menaka Balakrishnamoorthy
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

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

2013-09-21 Thread Ms Excel user
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

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

2013-09-21 Thread Prafull Jadhav
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

$$Excel-Macros$$ Pivot Table

2013-09-21 Thread Bv Dileep
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