Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?
De Premor - My apologies for not responding sooner but I've been out of commission It works perfectly :-D And I found that when I just copied and pasted the images it works and seems to provide a bit more flexibility :-) Would you mind explaining the macro you created, so that I'll be able to replicate/edit it? -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?
bé trần văn - Unfortunately that didn't work because when I tried sorting the rows the images aren't moving accordingly :-( On Sunday, August 25, 2013 11:28:17 AM UTC-4, bé trần văn wrote: > > *You try this. > * > 2013/8/25 Prince > > >> No Chaya i dont think there is any way to do this with hyperlinks. >> >> >> On Wednesday, August 21, 2013 12:33:39 PM UTC+5:30, Chaya Cooper wrote: >> >>> Eugene, >>> >>> I need to display the images inline. Is there a way to do that with >>> hyperlinks? >>> >>> >>> On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard >>> wrote: >>> >>>> Instead of inserting the images, why can't you use hyperlinks !!!. >>>> >>>> Regards >>>> Eugene >>>> >>>> >>>> On Tue, Aug 20, 2013 at 3:39 AM, Chaya Cooper wrote: >>>> >>>>> I often use Excel to organize rows of text (i.e. terminology, >>>>> examples, subsets, etc.) and often need to include images in a row. >>>>> However >>>>> since images aren't actually in a specific cell they therefore aren't >>>>> linked to the rest of the information in the row, making it impossible to >>>>> sort the data, as well as quite cumbersome to format. >>>>> >>>>> As a result, I have been splitting the information up into tables in >>>>> both Excel and Word, but I would obviously like to find a simpler way to >>>>> do >>>>> this so that all of the information can be kept together. Is there a way >>>>> for me to use images in Excel in much the same way I do in the Word >>>>> tables? >>>>> >>>>> >>>>> As I am using this for several hundred images, I would ideally like to >>>>> drag the images in order to insert or move them the way that I do in >>>>> Word. >>>>> >>>>> -- >>>>> 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<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...@**googlegroups.com. >>>>> >>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>> >>>>> Visit this group at >>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >>>>> . >>>>> For more options, visit >>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>> >>>> -- >>>> 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<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. >&
Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?
Eugene, I need to display the images inline. Is there a way to do that with hyperlinks? On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard wrote: > Instead of inserting the images, why can't you use hyperlinks !!!. > > Regards > Eugene > > > On Tue, Aug 20, 2013 at 3:39 AM, Chaya Cooper wrote: > >> I often use Excel to organize rows of text (i.e. terminology, examples, >> subsets, etc.) and often need to include images in a row. However since >> images aren't actually in a specific cell they therefore aren't linked to >> the rest of the information in the row, making it impossible to sort the >> data, as well as quite cumbersome to format. >> >> As a result, I have been splitting the information up into tables in both >> Excel and Word, but I would obviously like to find a simpler way to do this >> so that all of the information can be kept together. Is there a way for me >> to use images in Excel in much the same way I do in the Word tables? >> >> As I am using this for several hundred images, I would ideally like to >> drag the images in order to insert or move them the way that I do in Word. >> >> -- >> 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 http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > 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 a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/gOY2qpCwtlA/unsubscribe. > To unsubscribe from this group and all its topics, 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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 co
Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab
I guess that's good to know On Tuesday, August 20, 2013 2:23:33 AM UTC-4, ashish wrote: > > Hi > > Excel 2008 mac does not support VBA . > http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac > > http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html > > It might be reason that its not thr in right click > > Regards > Ashish > > > > > > > On Tue, Aug 20, 2013 at 11:47 AM, ashish koul > > wrote: > >> if you are using mac excel then try Alt + Fn +F11 >> >> source: >> http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html >> >> >> On Tue, Aug 20, 2013 at 11:43 AM, ashish koul >> >> > wrote: >> >>> press alt +f11 >>> >>> >>> On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR >>> >>> > wrote: >>> >>>> Respected Chaya Cooper, >>>> >>>> Please check the following link and see whether it helps. >>>> http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ >>>> >>>> To view code you can also open the VBA window by pressing ALT+F11 and >>>> go to project explorer window and go to the module folder to open it and >>>> see the code,or you can go to the developer tab and under the controls tab >>>> press view code. >>>> >>>> Regards, >>>> Vijaykumar >>>> >>>> -- >>>> 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...@googlegroups.com . >>>> To post to this group, send email to >>>> excel-...@googlegroups.com >>>> . >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>> >>> >>> >>> -- >>> *Regards* >>> * * >>> *Ashish Koul* >>> >>> >>> *Visit* >>> *My Excel Blog <http://www.excelvbamacros.com/>* >>> Like Us on >>> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> >>> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >>> >>> >>> P Before printing, think about the environment. >>> >>> >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> >> >> *Visit* >> *My Excel Blog <http://www.excelvbamacros.com/>* >> Like Us on >> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> >> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >> >> >> P Before printing, think about the environment. >> >> >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *My Excel Blog <http://www.excelvbamacros.com/>* > Like Us on > Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab
Alt + Fn +F11 just minimizes the window :-( On Tuesday, August 20, 2013 2:17:28 AM UTC-4, ashish wrote: > > if you are using mac excel then try Alt + Fn +F11 > > source: > http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html > > > On Tue, Aug 20, 2013 at 11:43 AM, ashish koul > > wrote: > >> press alt +f11 >> >> >> On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR >> >> > wrote: >> >>> Respected Chaya Cooper, >>> >>> Please check the following link and see whether it helps. >>> http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ >>> >>> To view code you can also open the VBA window by pressing ALT+F11 and go >>> to project explorer window and go to the module folder to open it and see >>> the code,or you can go to the developer tab and under the controls tab >>> press view code. >>> >>> Regards, >>> Vijaykumar >>> >>> -- >>> 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...@googlegroups.com . >>> To post to this group, send email to excel-...@googlegroups.com >>> . >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> >> >> *Visit* >> *My Excel Blog <http://www.excelvbamacros.com/>* >> Like Us on >> Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> >> Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> >> >> >> P Before printing, think about the environment. >> >> >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *My Excel Blog <http://www.excelvbamacros.com/>* > Like Us on > Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab
I guess that's good to know. Unfortunately I'm only using this this computer temporarily, so I'm not able to upgrade the software :-( On Tue, Aug 20, 2013 at 2:31 AM, P.VIJAYKUMAR wrote: > Respected Chaya, > > Unfortunately macros or VBA interface is not available with Excel 2008 for > MAC.You must upgrade to Excel 2011 of chane to windows operating system to > use Excel 2007,2010 or Excel 2013.The shortcoming or limitations of Excel > 2008 are given in the below link. > http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac > > Regards, > Vijaykumar > > > -- > 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 a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/wr0AZQXE8xw/unsubscribe. > To unsubscribe from this group and all its topics, 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 http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab
Vijaykumar, That's actually a great tutorial, so thank you for showing it to me :-) Unfortunately it doesn't show how to view the code :-( When I select ALT+F11 nothing happens (is there another way that i need to do it in Mac?), and I'm having trouble figuring out another way to open it. Any suggestions? On Tuesday, August 20, 2013 1:55:04 AM UTC-4, vijay wrote: > > Respected Chaya Cooper, > > Please check the following link and see whether it helps. > http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ > > To view code you can also open the VBA window by pressing ALT+F11 and go > to project explorer window and go to the module folder to open it and see > the code,or you can go to the developer tab and under the controls tab > press view code. > > Regards, > Vijaykumar > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?
Ashish, That's exactly what I needed :-D Would you mind showing me how to use it? - Chaya On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote: > > Hi try the attachment . see if it helps > > > > > On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar > > > wrote: > >> Hi Chaya, Prabhu, >> >> Done with a simple macro. >> >> Use Control + Shift + A at particular cell where you want to transpose. >> >> This you have to to for every entry. >> >> In case you want it for mulitiple entries there shall be different macro >> required. >> >> While running this macro, Check your macro security setting. I guess it >> it is "High to Very high" Change it to Medium. >> >> Regards >> Prashant >> >> >> On Tue, Aug 20, 2013 at 6: >> 15 AM, Chaya Cooper > wrote: >> >>> Thanks for clarifying :-) >>> >>> Here's a sample file with 2 sheets, one with the original (unedited) >>> data, and one with the data in the correct format :-) >>> >>> -- >>> 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...@googlegroups.com . >>> To post to this group, send email to excel-...@googlegroups.com >>> . >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *My Excel Blog <http://www.excelvbamacros.com/>* > Like Us on > Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897> > Join Us on Facebook <http://www.facebook.com/groups/163491717053198/> > > > P Before printing, think about the environment. > > > -- 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 t
Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?
Hi Prashant, I've only used macros a few times, and am having trouble a wee bit of trouble figuring things out because I'm temporarily using a Excel 2008 for Mac :-( (I'm normally a PC gal, with Office 2007 ;-)) Can I trouble you to explain when I should use Control + Shift + A, and how to open and use this macro? Also, am I correct in assuming that by 'multiple entries' you meant multiple rows? If so, would you mind clarifying how to do it with different macros? I'm using this for several hundred rows (once it is formatted correctly), so I'm assuming that I'll probably need to do this :-) On Tuesday, August 20, 2013 12:16:50 AM UTC-4, prashant wrote: > > Hi Chaya, Prabhu, > > Done with a simple macro. > > Use Control + Shift + A at particular cell where you want to transpose. > > This you have to to for every entry. > > In case you want it for mulitiple entries there shall be different macro > required. > > While running this macro, Check your macro security setting. I guess it it > is "High to Very high" Change it to Medium. > > Regards > Prashant > > > On Tue, Aug 20, 2013 at 6: > 15 AM, Chaya Cooper > wrote: > >> Thanks for clarifying :-) >> >> Here's a sample file with 2 sheets, one with the original (unedited) >> data, and one with the data in the correct format :-) >> >> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab
A tutorial I'm using (to create a multi-select box) suggests right-clicking on the sheet tab to View Code, but that option isn't being displayed (I'm running Excel 2008 for Mac). Any suggestions how I can view the code? My apologies for what is probably a simple issue, but I've been unable to find an answer online. -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?
I'm sorry, I'm not sure I understand what you're saying :-( On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote: > > hi chaya, > > hope if u share the file.. it will be so fine to work. > > > Thanks & Regards, > Prabhu R > > > On 20 August 2013 04:35, Chaya Cooper >wrote: > >> Unfortunately, the data in each row is different >> >> I've attached an image with an example :-) >> >> >> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky >> >> > wrote: >> >>> you mean same data in each row..?.. or can you share me your file with >>> requirement..? >>> >>> like below.. >>> >>> [image: Inline images 1] >>> >>> >>> Thanks & Regards, >>> Prabhu R >>> >>> >>> On 20 August 2013 04:02, Chaya Cooper >> >wrote: >>> >>>> That's amazing :-D I'm sorry I waited this long to ask ;-) >>>> >>>> One question - is there a way to split it up into several rows (for >>>> example 5 rows, with 3 columns per row)? >>>> >>>> On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote: >>>> >>>>> Hi Chaya, >>>>> >>>>> You no need to cut and paste the each cells. Simply u just copy the >>>>> data which u need to be in row. then right click->paste special->values >>>>> (and select transpose). Now you data will be pasted in single row. >>>>> >>>>> Note the same method u can use to copy the data in single column if it >>>>> is in single row. >>>>> >>>>> >>>>> Thanks & Regards, >>>>> Prabhu R >>>>> >>>>> >>>>> On 20 August 2013 02:55, Chaya Cooper wrote: >>>>> >>>>>> >>>>>> >>>>>> I often have to move cells in order to have them in a row (going >>>>>> across) instead of in a column (going down). Is there a way to simplify >>>>>> this so that I don't have to manually cut & paste or move each cell? >>>>>> >>>>>> -- >>>>>> 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<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...@**googlegroups.com. >>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>> >>>>>> Visit this group at >>>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >>>>>> . >>>>>> For more options, visit >>>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>>>> . >>>>>> >>>>> >>>>> -- >>>> 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 >>>> >>>> FO
Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?
That's amazing :-D I'm sorry I waited this long to ask ;-) One question - is there a way to split it up into several rows (for example 5 rows, with 3 columns per row)? On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote: > > Hi Chaya, > > You no need to cut and paste the each cells. Simply u just copy the data > which u need to be in row. then right click->paste special->values (and > select transpose). Now you data will be pasted in single row. > > Note the same method u can use to copy the data in single column if it is > in single row. > > > Thanks & Regards, > Prabhu R > > > On 20 August 2013 02:55, Chaya Cooper >wrote: > >> >> >> I often have to move cells in order to have them in a row (going across) >> instead of in a column (going down). Is there a way to simplify this so >> that I don't have to manually cut & paste or move each cell? >> >> -- >> 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...@googlegroups.com . >> To post to this group, send email to excel-...@googlegroups.com >> . >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Is there a way to insert images into a specific cell?
I often use Excel to organize rows of text (i.e. terminology, examples, subsets, etc.) and often need to include images in a row. However since images aren't actually in a specific cell they therefore aren't linked to the rest of the information in the row, making it impossible to sort the data, as well as quite cumbersome to format. As a result, I have been splitting the information up into tables in both Excel and Word, but I would obviously like to find a simpler way to do this so that all of the information can be kept together. Is there a way for me to use images in Excel in much the same way I do in the Word tables? As I am using this for several hundred images, I would ideally like to drag the images in order to insert or move them the way that I do in Word. -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ How can I change selected cells from a column into a row?
I often have to move cells in order to have them in a row (going across) instead of in a column (going down). Is there a way to simplify this so that I don't have to manually cut & paste or move each cell? -- 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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
