$$Excel-Macros$$ Re: help required on conditional formatting
Dear Prakash Thanks for your solution. but 1 thing is pending if u can solve (i want hide row number 15 if I select bank of baroda) Dear Rohan Thanks to you also, but your solution is giving me the box for only to the digit 7,8,and 9 but I want box on every number, the same is solved by prakash and secondly u solved my second query that is row hide, (*but if u can hide the row number 15 if I select bank of baroda than it is very great full.)* ** *Thanks to the group also.* ** *Regards* *Dharmesh Shah* * * On Sat, Jan 22, 2011 at 4:11 AM, Prakash Gusain gusainprak...@gmail.comwrote: Dear Dharmesh, Here is the solution, hope this is what you were looking for! Let me know it helps -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here http://prakashgusain.blogspot.com/** )* -- -- 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 Bank Format.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Excel Help
Hi David, let me know the fields and how would you want it to be created. Umesh On Mon, Jan 24, 2011 at 12:32 AM, DavidG goldstone.da...@googlemail.comwrote: how do i add a file? On Jan 21, 8:57 pm, DavidG goldstone.da...@googlemail.com wrote: Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any ideas or help will be greatly appreciated. Thanks -- -- 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 -- -- 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
$$Excel-Macros$$ Extract date from one cell
Dear All, Please can any one help me to extract date in given securities by way of VBA code and formula. SecurityDate REC 07.60% 22JAN13 22-Jan-2013 08.80% STATE BKOF BKJAIPUR 05SEP11 FD GAIL INDIA LIMITED HDFC 0.00% 24AUG12 LIC HOUSING FINANCE 07.50% 10JUN13 Regards, Shrinivas -- -- 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
$$Excel-Macros$$ name
How do i name a column in Excel 2003. For eg in excel 2007, i have a table named table1 having column Item...now i could name use table1[Item] as name...but unfortunately this convention is not applicable in Excel 2003...So is there any solution?? -- -- 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
Re: $$Excel-Macros$$ help required on conditional formatting
Dear Dharmesh Shah, find the attachment. it will fulfill your requirement Regards Thamu On Sat, Jan 22, 2011 at 3:06 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, i think it will more helpful to you, thanks regards ROHAN On Sat, Jan 22, 2011 at 2:57 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, see the attachment Hope it will help regards ROHAN 9818247278, 8860567680 On Fri, Jan 21, 2011 at 5:48 PM, Dharmesh Shah dharmeshsha...@gmail.comwrote: dear all please solve my query in the attached file Thanks in advance Dharmesh Shah -- -- 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 -- -- 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 -- -- 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 ac number.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Extract date from one cell
Hope this may help you... Regards, Manoj Kumar On Mon, Jan 24, 2011 at 1:04 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear All, Please can any one help me to extract date in given securities by way of VBA code and formula. *Security* *Date* REC 07.60% *22JAN13* 22-Jan-2013 08.80% STATE BKOF BKJAIPUR *05SEP11* FD GAIL INDIA LIMITED HDFC 0.00% *24AUG12*LIC HOUSING FINANCE 07.50% *10JUN13* Regards, Shrinivas -- -- 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 -- -- 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 GG-Extract Dates_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ name
Select the Column and From Formula tab there is the name manager. [ ] kind of things are not allowed in naming On Mon, Jan 24, 2011 at 1:46 PM, airen airen1...@gmail.com wrote: How do i name a column in Excel 2003. For eg in excel 2007, i have a table named table1 having column Item...now i could name use table1[Item] as name...but unfortunately this convention is not applicable in Excel 2003...So is there any solution?? -- -- 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 -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- 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
Re: $$Excel-Macros$$ Extract date from one cell
check the attachement Function extractdate(x As String) Dim i, j, k, s, t As Integer x = x i = Len(x) j = InStr(x, %) For k = j To i If IsNumeric(Mid(x, k, 1)) Then s = k Exit For End If Next k For k = s + 1 To i If Mid(x, k, 1) = Then t = k Exit For End If Next k extractdate = Mid(x, s, t - s) End Function On Mon, Jan 24, 2011 at 5:20 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hope this may help you... Regards, Manoj Kumar On Mon, Jan 24, 2011 at 1:04 PM, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear All, Please can any one help me to extract date in given securities by way of VBA code and formula. *Security* *Date* REC 07.60% *22JAN13* 22-Jan-2013 08.80% STATE BKOF BKJAIPUR *05SEP11* FD GAIL INDIA LIMITED HDFC 0.00% *24AUG12*LIC HOUSING FINANCE 07.50% *10JUN13* Regards, Shrinivas -- -- 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 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 test.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Forum Facts.
Dear Group, Thanks for all your wonderful contribution. Here are some group facts consolidated for you : - Launch date : 19th March 2007 - Group Owner : Ayush Jain - jainayus...@gmail.com - Total members : 7615+ (as on 24th January) - Banned members : 695+ - Active MVPs : Dilip Pandey, Ayush Jain - Subject Topics : Microsoft Excel , VBA, Microsoft Access - Topics Discussed : 4907 - Total Posts since Launch : 16547 (Till 31st Dec'2010) - Group email address :- excel-macros@googlegroups.com Please share more facts if you have any. Thanks. Best Regards, Ayush Jain -- -- 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
Re: $$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)
Hi you can use the date function with offsset function in your reference formula for this. For exact formula tell me what's your current cell address having reference and whats the reference. On 23-Jan-2011 2:01 PM, kush sharma kushleshsha...@gmail.com wrote: Dear All, I have a query in which i need your help. Lets Say, I am using an Excel sheet which has got multiple sheets inside it and a master sheet. Each Sheet is made for a different item that i sell. It has got colums such as Closing Balance(Yesterday), Inward and Outward and daily closing balance. using cross-linking the master sheet gets updated with the closing balance for that partiular itme. but the next day i have to change the cell reference for each item closing balance (cell reference) in the master sheet. I just have to delete thatparticular cell number and replace it with next row number but is there any formula which can automatically take next cell as reference if the date changes? or any thing else that can help me in this. I would apprecaite the help *Regards* * * *Kushlesh Sharma* *Mo.No: 9907517169* ** All Things are subject to interpretation, and whichever interpretation prevails at a given time is a function of power not truth. -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Help Required
Hi Umesh, Thanks for your help. On 1/23/11, Umesh Dev umesh.d...@gmail.com wrote: Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram vikramahuj...@gmail.com wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: *Code* *Category* 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- -- 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 -- -- 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 -- Regards, Vikram Ahuja -- -- 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
RE: $$Excel-Macros$$ Help Required
Hi Umesh, I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Sunday, January 23, 2011 7:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram vikramahuj...@gmail.com wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: Code Category 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- -- 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 -- -- 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 -- -- 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
$$Excel-Macros$$ Macros for paste special-transpose
Hello All, Please can somebody advise me macros for paste special-transpose wherein i can just copy the data in horizontal format and paste them in vertical with a shortcut key. My data looks something like below in different sheets of same workbook 2009 2008 2007 1.2 0.84 0.94 and i want it in below format. *2007* 0.94 *2008* 0.84 *2009* 1.20 Any help would be much appreciated. I am in an urgent need of this. Many Thanks Manoj -- -- 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
$$Excel-Macros$$ Copy data validation to create lists
Hi, I’m trying to copy a list from column A2 to A30 (which was created using Data Validation), on sheet 2 to column C2 to C30 on sheet 1. I’ve tried everything, but error keeps coming back that I ‘can only copy filtered data to the active sheet’. Thanks. Susan -- -- 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
Re: $$Excel-Macros$$ Macros for paste special-transpose
try this... Sub Transpose() ' ' Macro Transpose ' ' Range(A1).Select Selection.CurrentRegion.Select Selection.Copy Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlDown).Select Range(G1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=True End Sub Regards, Manoj Kumar On Tue, Jan 25, 2011 at 8:42 AM, Manoj b manoj.bi...@gmail.com wrote: Hello All, Please can somebody advise me macros for paste special-transpose wherein i can just copy the data in horizontal format and paste them in vertical with a shortcut key. My data looks something like below in different sheets of same workbook 2009 2008 2007 1.2 0.84 0.94 and i want it in below format. *2007* 0.94 *2008* 0.84 *2009* 1.20 Any help would be much appreciated. I am in an urgent need of this. Many Thanks Manoj -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Copy data validation to create lists
can u pls attach a sample file... Regards, Manoj Kumar On Tue, Jan 25, 2011 at 9:05 AM, Susan sunni...@gmail.com wrote: Hi, I’m trying to copy a list from column A2 to A30 (which was created using Data Validation), on sheet 2 to column C2 to C30 on sheet 1. I’ve tried everything, but error keeps coming back that I ‘can only copy filtered data to the active sheet’. Thanks. Susan -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Macros for paste special-transpose
Sub Bang() Dim Rng As Range Set Rng = Cells(1).CurrentRegion Rng.Copy Rng(1).Offset(Rng.Rows.Count + 2, 0).PasteSpecial _ Paste:=xlPasteAll, Transpose:=True End Sub On Tue, Jan 25, 2011 at 10:12 AM, Manoj b manoj.bi...@gmail.com wrote: Hello All, Please can somebody advise me macros for paste special-transpose wherein i can just copy the data in horizontal format and paste them in vertical with a shortcut key. My data looks something like below in different sheets of same workbook 2009 2008 2007 1.2 0.84 0.94 and i want it in below format. 2007 0.94 2008 0.84 2009 1.20 Any help would be much appreciated. I am in an urgent need of this. Many Thanks Manoj -- -- 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
Re: $$Excel-Macros$$ How to get the address of a cell in VBA
I think this is much simple. after you find the cell write below stement. a = ActiveCell.Address if you wanna use that cell u can use like below example. Range(a).Offset(1, 3).Select From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, 24 January, 2011 8:40:37 PM Subject: Re: $$Excel-Macros$$ How to get the address of a cell in VBA check the attachement Sub ABC() Dim I, J, K As Long Dim foundcell As Range Set foundcell = Sheets(1).Range(a1) Set foundcell = Sheets(1).Columns(1).Find(What:=10, After:=foundcell, _ LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) If foundcell Is Nothing Then Else ' one way foundcell.Interior.Color = vbRed ' 2nd way Range(b1).Value = Range(foundcell.Address).Value + 20 ' 3 rd way Cells(1, 3).Value = Cells(foundcell.Row, foundcell.Column).Value + 30 foundcell.Offset(0, 4) = foundcell End If End Sub On Sat, Jan 22, 2011 at 3:26 AM, Mao yanjiemao...@gmail.com wrote: Hi there, I have a question about how to locate the address of the cell in VBA For example, I am looking for ABC in my sheet. By using FIND function, I got the location as A1. How could I write this location into one variable? So when later I am using ABC again, I could refer Range(A1) directly. Thanks Mao -- -- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- -- 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 -- -- 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
Re: $$Excel-Macros$$ How to get the address of a cell in VBA
Sub ABCFoundCell() Dim x As Range Set x = Cells.Find(What:=ABC, _ After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False, _ SearchFormat:=False) MsgBox the cell address is : x.Address End Sub On Sat, Jan 22, 2011 at 4:56 AM, Mao yanjiemao...@gmail.com wrote: Hi there, I have a question about how to locate the address of the cell in VBA For example, I am looking for ABC in my sheet. By using FIND function, I got the location as A1. How could I write this location into one variable? So when later I am using ABC again, I could refer Range(A1) directly. Thanks Mao -- -- 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