Fwd: $$Excel-Macros$$ Need Help on attached sheet
Use this : Sub Data_Formatting() Dim rw As Long For rw = 17 To ActiveSheet.UsedRange.Rows.Count Step 6 With Worksheets("Required").Range("B" & Rows.Count).End(xlUp) .Offset(1, 0).Value = Range("D" & rw).Value .Offset(1, 1).Value = Range("D" & rw).Offset(3).Value .Offset(1, 2).Value = Range("F" & rw).Value .Offset(1, 3).Value = Range("M" & rw).Value .Offset(1, 4).Value = Range("O" & rw).Offset(3).Value .Offset(1, 5).Value = Range("R" & rw).Value .Offset(1, 6).Value = Range("T" & rw).Offset(3).Value .Offset(1, 7).Value = Range("V" & rw).Value .Offset(1, 8).Value = Range("Z" & rw).Offset(3).Value .Offset(1, 9).Value = Range("AB" & rw).Value .Offset(1, 10).Value = Range("AD" & rw).Offset(3).Value .Offset(1, 11).Value = Range("AF" & rw).Value .Offset(1, 12).Value = Range("AK" & rw).Offset(2).Value .Offset(1, 13).Value = Range("AK" & rw).Value End With Next rw End Sub *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *pankaj123...@gmail.com * *Skype** pankaj.sharma_pj* -- Forwarded message -- From: vikas khen Date: Thu, Dec 24, 2015 at 7:37 AM Subject: $$Excel-Macros$$ Need Help on attached sheet To: excel-macros@googlegroups.com Dear Team, Please find the attached excel sheet in which the raw data is sheet 1 and the required output is in Sheet 2. It would be very helpful if you help me on this. Regards -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. WeeklyBooking (Solved).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Fwd: $$Excel-Macros$$ NEED HELP
*FORUM RULES 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.* -- Forwarded message -- From: Dhaval Shah todhavals...@gmail.com Date: Mon, Dec 10, 2012 at 9:12 AM Subject: $$Excel-Macros$$ NEED HELP To: excel-macros@googlegroups.com FORUM RULES 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. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. PASS FAIL.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding
Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. If match(Worksheets(Account Statement).Range(E6).Value, Worksheets(Account Status).Range(K:K), 0) 0 Then MsgBox Bill is made of this Chassis End If Kindly solve my query that I use macro in .xlsx format, so what is the difference to use macro in macro-enable workbook format and simple .xlsx format? Thanks Regards Ashish Bhalara 9624111822 -- 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 Demo.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ need help
-- Forwarded message -- From: syed aliya raza hashim hashim...@gmail.com Date: Mon, Jul 11, 2011 at 6:06 AM Subject: Fwd: $$Excel-Macros$$ need help To: koul.ashish koul.ash...@gmail.com -- Forwarded message -- From: syed aliya raza hashim hashim...@gmail.com Date: Mon, Jul 11, 2011 at 6:03 AM Subject: Re: $$Excel-Macros$$ need help To: excel-macros@googlegroups.com Hi,Thanks for taking initiative , See there are two Clients:- 1 Genentech 2 Lifetech Both have three tabs Open,closed,Rejection that means total 6 tabs but i want only three tabs named Open,close,Rejection,in Open tab i want to put all GenentechLifetech Open data same in closed tab i want to put all Genentech Lifetech Data ,same as rejection but there should be some check box in all three tab so that i can select Client wise data for example if i check Genentech then it should display only Genentech client data same as for Lifetech On Fri, Jul 8, 2011 at 3:40 PM, syed aliya raza hashim hashim...@gmail.comwrote: Hi, Hi , I have the two client sheet one for Genentech and Other one is lifetech but in different tab I want in single tab what I want a check box should be there when to select *Genentech* the data of that particular client should appear same as with* Lifetech* -- syed aliya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- syed aliya -- syed aliya -- syed aliya -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel