$$Excel-Macros$$ Copy Data from Sheet to Sheet based on both columns in Excel
Hi all, I'm very much confused how to post and where to post my questions?...I need a small help but its very urgent... I need a macro for the below mentioned problem. Say for example: I have a column A and B in a sheet. In column A say I have 1,2,3,4,5, and in column B say I have A.b.c.d.e against each I need a Macro it should read 1 and search for the sheet name 1 if it is available then search for sheet Name "A" if both are available copy data from sheet "1" to sheet "A". Do this for all the rows while checking both columns for all the sheets. I need this very urgent... please help me. Thank you, Srini -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Want to get your question answered quickly?
Hi all,
I'm very much confused how to post and where to post my questions?...I need
a small help but its very urgent...
I need a macro for the below mentioned problem.
Say for example:
I have a column A and B in a sheet.
In column A say I have 1,2,3,4,5, and
in column B say I have A.b.c.d.e against each
I need a Macro it should read 1 and search for the sheet name 1 if it is
available then search for sheet Name "A" if both are available copy data
from sheet "1" to sheet "A". Do this for all the rows while checking both
columns for all the sheets.
I need this very urgent... please help me.
Thank you,
Srini
On Saturday, November 3, 2012 1:04:25 PM UTC+5:30, Ayush Jain wrote:
>
>
> Dear members,
>
> If you keep below points in mind while asking your query, The chances to
> get answered is just high :
>
>1. *Ensure your question is not too vague.* Don't assume anyone is
>familiar with your problem. While you can upload small attachments,
>describe your problem in the body of the post. We are fortunate to have
>several Excel gurus, but few mind-readers.
>2. *On the other hand, skip irrelevant details.* Be descriptive and
>concise. Short, direct, and to-the-point questions with apt thread titles
>are almost always answered promptly.
>3. *Keep the scope reasonably narrow.* Questions like, "How do I set
>up an accounting system in Excel?" might be a long time waiting.
>4. *Explain what you've already tried.* ("Calculation is set to
>automatic, but formulas still don't compute") so helpers don't waste your
>time or theirs.
>5. *Post a WORKBOOK.* Nobody wants to type data from a picture or
>paste text from your post into a spreadsheet as a prelude to helping. To
>attache a file, You can email them as attachments to your group's email
>address excel-...@googlegroups.com OR Simply "Attach a
>file" during posting in New Google Groups.
>6. If your question has not been answered within a day, consider
>adding another post with any additional information you believe is
>relevant.
>7. Use {} from the post menu to *high**light the syntax*
>
> Many Thanks
>
> Keep Posting,
>
> -Ayush Jain(Group Manager)
>
>
>
>
>
>
>
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Copy Data from Sheet to Sheet based on both columns in Excel
Hi all, I'm very much confused how to post and where to post my questions?...I need a small help but its very urgent... I need a macro for the below mentioned problem. Say for example: I have a column A and B in a sheet. In column A say I have 1,2,3,4,5, and in column B say I have A.b.c.d.e against each I need a Macro it should read 1 and search for the sheet name 1 if it is available then search for sheet Name "A" if both are available copy data from sheet "1" to sheet "A". Do this for all the rows while checking both columns for all the sheets. I need this very urgent... please help me. Thank you, Srini -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command
I agree with David, that could be the one reason. try out that. On Fri, May 25, 2012 at 10:51 AM, David Grugeon wrote: > The most likely cause is that you have a macro assigned to Ctrl-A either in > an open workbook, an addin, or in your personal macros workbook. This last > is a hidden workbook which opens up when you open excel. You can see its > macros in the VBE so press Alt-F11 and have a look. There may be a macro > called AutoOpen or similar which sets up the key assignment. > > If Ctrl-A has its default assignment (selecting the current area of the > active sheet) it will not run a macro and will not give the error. > > You will need to find out what it is doing, and either remove the > reassignment of the key combination or fix the faulty macro. > > The error is likely to be because it is trying to run a macro which is > designed for a specific workbook, but that workbook is not in use or is not > active. > > Regards > David > > On 25 May 2012 14:24, SAGAR KASANGOTTUWAR > wrote: >> >> Dear All, >> >> This error is coming in all the sheets whenever I open any excel sheet and >> Press Crl.+A then error 1004 is showing on the screen. >> >> Thanks & Regards, >> K Sagar >> >> >> On Thu, May 24, 2012 at 6:05 PM, dguillett1 wrote: >>> >>> Provide an excel file. >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> From: SAGAR KASANGOTTUWAR >>> Sent: Wednesday, May 23, 2012 2:30 AM >>> To: excel-macros@googlegroups.com >>> Subject: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command >>> >>> Dear all, >>> >>> I am facing the problem in MS excel command Crl + A. Whenever I run >>> command Crl+A 1004 error in EXECL file. >>> >>> Kindly help me for resolve this error. >>> >>> Thanks & Regards, >>> Sagar Kasangottuwar >>> -- >>> 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 >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@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 >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> -- >> David Grugeon >> > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread t
$$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C
Hi, Please see the attached example and please help out with Macro. I have ONLY two Products say X and Y in column "A" and if the amounts match for both the products in Column "B" write as Closed in Column "C". Please see the example attached in excel. note : Check the two products in rows in alternative, do not sort or club together. Thank you, Srini -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Book100.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions
use this formula: =VLOOKUP(E3,Sheet1!E:G,3,0). On Thu, May 24, 2012 at 4:09 PM, vijayajith VA wrote: > Hi > Try ths > =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) > > > On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi wrote: >>> >>> Hi Experts >>> >>> >>> VLOOKUP is not working in attached file, can anyone help me why its not >>> working and what will be right formula? >>> >>> Pls help me here. >>> >>> Regards >>> >>> Amit >>> >>> -- >>> 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 >>> >>> To unsubscribe, send a blank email to >>> excel-macros+unsubscr...@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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Error 1004 at the time of Crl. + A command
Delete all the rows and columns and try again. On Wed, May 23, 2012 at 1:00 PM, SAGAR KASANGOTTUWAR wrote: > Dear all, > > I am facing the problem in MS excel command Crl + A. Whenever I run command > Crl+A 1004 error in EXECL file. > > Kindly help me for resolve this error. > > Thanks & Regards, > Sagar Kasangottuwar > > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to create running time in excel sheet
What do you mean by running time. please share more examples. On Wed, May 23, 2012 at 9:17 AM, PRAVESH KUMAR wrote: > Hi Group, > > please tell How to create running time in excel sheet?? > -- > > > *Thanks & Regards* > > *Pravesh Kumar* > > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Delete Zero subtotal blocks
Hi Don, Say for an example: I have data from A to H G col : HCol : 5 : -5 Subtotal: 0 Now, what I want is ...copy the entire block to another sheet and delete that zero subtotal block. Please do let me know if you need any more information. Thanks, Srini On Monday, May 14, 2012 1:55:06 PM UTC+5:30, sreenivas kammari wrote: > Hi, > > Is there anyone help me please on the below one. > > If the subtotal value is zero..copy to those block to another sheet and > delete the entire subtotal block. > > Thank you, > Srini > -- 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
$$Excel-Macros$$ Delete Zero subtotal blocks
Hi, Is there anyone help me please on the below one. If the subtotal value is zero..copy to those block to another sheet and delete the entire subtotal block. Thank you, Srini -- 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
