On Jan 16, 2012 5:26 AM, <excel-macros@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - Delete text only <#134e3cd67b42c55e_group_thread_0> [3 Updates] > - access query <#134e3cd67b42c55e_group_thread_1> [3 Updates] > - HELP - Can´t sum the same columns of a comparative > column<#134e3cd67b42c55e_group_thread_2>[1 Update] > > Delete text > only<http://groups.google.com/group/excel-macros/t/76f02d58d44c14de> > > NOORAIN ANSARI <noorain.ans...@gmail.com> Jan 15 10:04PM +0530 > > Dear Laxman, > > Sub Copy_and_Delete_Number() > Dim rng, rng1, rng2 As Range > Dim i, j As Long > Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row) > rng.Copy Sheet1.Range("D1") > Set rng1 = Sheet1.Range("D2:D" & Sheet1.Range("D65536").End(xlUp).Row) > For Each rng2 In rng1 > If VBA.IsNumeric(rng2) = True Then > rng2.Delete > End If > Next > End Sub > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*< > http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/* < > http://noorain-ansari.blogspot.com/> > > > > > Ram <lee.sar...@gmail.com> Jan 15 05:33PM -0500 > > Hi Noorain > > Can u give a macro for this urgently > > > > > > "dguillett1" <dguille...@gmail.com> Jan 15 05:30PM -0600 > > Did you try this macro?. > > Sub Copycolatod_DeleteTextSAS() > Columns("A").Copy Range("D1") > Columns("D").SpecialCells(xlCellTypeConstants, 2).Delete Shift:=xlUp > End Sub > > If you do NOT need to keep col A then simply > Sub DeleteTextinColumnA_SAS() > Columns("A").SpecialCells(xlCellTypeConstants, 2).Delete Shift:=xlUp > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Ram > Sent: Sunday, January 15, 2012 4:33 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Delete text only > > Hi Noorain > > Can u give a macro for this urgently > > On Jan 13, 2012, at 9:55 AM, NOORAIN ANSARI <noorain.ans...@gmail.com> > wrote: > > > Dear Lokesh, > > Please try it.. > > Sub Copy_and_Delete_Text() > Dim rng, rng1, rng2 As Range > Dim i, j As Long > Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row) > rng.Copy Sheet1.Range("D1") > Set rng1 = Sheet1.Range("D2:D" & Sheet1.Range("D65536").End(xlUp).Row) > For Each rng2 In rng1 > If Application.WorksheetFunction.IsText(rng2) Then > rng2.Delete > End If > Next > End Sub > > and see attached sheet.. > > -- > > Thanks & regards, > Noorain Ansari > http://excelmacroworld.blogspot.com/ > www.noorainansari.com > > > > On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki <lokeshsmg2...@gmail.com> > wrote: > > Hi All, > > First i need to copy the Cell A and paste it to Cell D and delete the > names (i.e.text) in Cell D through VBA. > > Find the attached excel file. > > Regards > Lokesh.M > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > <delete text.xls> > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > > > access query<http://groups.google.com/group/excel-macros/t/283a35f6babb3ee3> > > "vivek" <vivek.j...@gmail.com> Jan 15 09:32AM +0530 > > I will once again explain my query. > > > > I have a table which contains data relating to about 100 schemes for > 2500 dealers in the following format > > > DEALER CODE > > DEALER NAME > > RDS NAME > > SCH-1 > > SCH-2 > > SCH-100 > > TOTAL EARNING > > > 1 > > A > > AA > > 100 > > 90 > > > > 190 > > > 2 > > B > > BB > > 150 > > 85 > > 17 > > 252 > > > 3 > > C > > AA > > 200 > > > > > > 200 > > > 4 > > D > > CC > > 150 > > 10 > > 0 > > 160 > > > N > > E > > BB > > 700 > > 80 > > 15 > > 795 > > > > Now I want the report in the following format for each dealer in a new > page > > > > DEALER CODE : 1 > > DEALER NAME: A > > RDS : AA > > SCH-1 100 > > SCH-2 90 > > TOTAL 190 > > > > > > DEALER CODE : 2 > > DEALER NAME: B > > RDS : BB > > SCH-1 150 > > SCH-2 85 > > SCH-3 17 > > TOTAL 252 > > > > Etc. for each dealer. If any scheme is blank for a dealer it should be > omitted. > > I hope I am clear this time. > > > > > > Thanks & Regards... > > CA Vivek Jain, FCA, DISA (ICAI) > > Vivek Shantilal Jain & Co. > > Chartered Accountants > > 3010 Ram Kumar Arcade, > > Chatribari Road, A T Road, > > Guwahati-781001 > > 0361-2603895,9435019908 > > save earth > > > > > Sam Mathai Chacko <samde...@gmail.com> Jan 15 02:54PM +0530 > > What do you mean by new page? Forget new page, can you at least explain > what do you mean by page? Is it a word document? Is it an excel sheet? > > If you cannot explain EXACTLY what you want, WHERE you want and HOW you > want, it will be very difficult for volunteers to help. > > Sam > > > -- > Sam Mathai Chacko > > > > > xlstime <xlst...@gmail.com> Jan 15 09:27PM +0530 > > Hi Vivek, > > > new page mean new report or page for each dealer. please find the > access > report. > > > > > -- > ......................... > > > > HELP - Can´t sum the same columns of a comparative > column<http://groups.google.com/group/excel-macros/t/a1daa96e7363fb46> > > Jorge Marques <leote.w...@gmail.com> Jan 15 02:16PM > > I´m sorry, i explained wrong, everyday i have to put the daily sale of > the > current day i am, and in the columns of year 2010 and 2011 it has to > give > me the same value to compare, but the problem is that the value to > compare > is not always the same day, has an example: > > i put the daily sale of 10th Jan of 83that was my current day and it > gives > me the sum of 7 cells(A month to date value), but in 2011 the proper > sum > to compare is until 11th Jan, because it has also 7 cells with > numbers( so > this is the proper month to date, comparing to my 10th jan of 2012), i > can´t compare with 10th Jan 2011, because it has only 6 cells with > values, > so i have to compare with 11 Jan, my goal is when i insert the day in > P34 > or directly(whichever is more easily done), it gives me the right sum > in > C40, F40, I40. is was trying to do with if formulas, but can´t seem to > get > it. I am trying sumifs with count, trying to create a rule with > formula, do > you think this is the right path? thank you > > [image: image.png] > > 2012/1/13 dguillett1 <dguille...@gmail.com> > > > > > You received this message because you are subscribed to the Google Group > excel-macros. > You can post via email <excel-macros@googlegroups.com>. > To unsubscribe from this group, > send<excel-macros+unsubscr...@googlegroups.com>an empty message. > For more options, > visit<http://groups.google.com/group/excel-macros/topics>this group. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com >
-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
