$$Excel-Macros$$ Re: Macro overwrite existing data

2015-04-08 Thread modi89
Group, please replace 'house1' with 'Red apples' and 'house2' with 'Green apples' On Wednesday, April 8, 2015 at 8:56:36 PM UTC-4, modi89 wrote: > > > > Hello Group, > I need help. when this code runs , The result goes to Sheet2 as intended. > however it overwrite A, B, C E, G. of Sheet2 column

$$Excel-Macros$$ Macro overwrite existing data

2015-04-08 Thread modi89
Hello Group, I need help. when this code runs , The result goes to Sheet2 as intended. however it overwrite A, B, C E, G. of Sheet2 columns. you help to stop overwriting .I Appreciate your help Sub SheetA() Dim w1 As Worksheet, w2 As Worksheet Dim a As Variant, o As Variant Dim i As Long, j A

$$Excel-Macros$$ Access on SharePoint App by excel VBA

2015-04-08 Thread sam m
*I want to update fields of SharePoint application by excel macro form but not succeed because there is no access path developing in VBA. So please clear my query regarding macro that how will I get access on SharePoint App from excel vba to e* *xport data into field ?* -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Print duplicate in same page-Excel

2015-04-08 Thread Naveen Kumar M N
Hi, Thanks for your response. Yes same data printed twice on the same physical page. In our data, it will be 6-7 rows in a page. What you have mentioned in Output, that is right. How could i do that, could you please explain? Regards Naveenkumar M N On Tue, Apr 7, 2015 at 7:52 PM, Paul Schrei