Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2015-04-01 Thread bobengler
B1<>$B$2:$B2 On Tue, Mar 31, 2015 at 10:42 PM, bobengler wrote: Here is a test of after I added the 2 rules. Can you see if I missed a step? Thanks, Bob   From: Vaibhav Joshi To: "excel-macros@googlegroups.com" Sent: Tuesday, March 31, 2015 4:02 AM Subject: Re: $$Exce

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2015-03-31 Thread bobengler
select color you want to give... After that Copy formula from G1 follow same process.. Cheers!! On Tue, Mar 31, 2015 at 7:15 AM, bobengler wrote: I could use your expertise again if you are available. I have

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2015-03-30 Thread bobengler
this helped you.Cheers!!On Dec 23, 2014 9:10 PM, "bobengler" wrote: Thank you for your time and expertise. It's good to know there is good support out there. Bob Engler From: Ashish Kumar To: Vaibhav Joshi Cc: "excel-macros@googlegroups.com" Sent: Friday

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread bobengler
Thank you for your time and expertise. It's good to know there is good support out there. Bob Engler From: Ashish Kumar To: Vaibhav Joshi Cc: "excel-macros@googlegroups.com" Sent: Friday, December 19, 2014 10:35 PM Subject: Re: $$Excel-Macros$$ Re: How t

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-23 Thread bobengler
to end of row of second sheet based on cell value Hi Bob Check this... Cheers!! + I did not do this for you. God is here working through me for you. On Sat, Dec 20, 2014 at 9:19 AM, bobengler wrote: > > >Could you change your code to get Sheet1 columns A-L and append S

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread bobengler
Could you change your code to get Sheet1 columns A-L and append Sheet2 columns A-T all into Sheet3 if they match like in the test data? The data I use is under a non-disclosure with my client so I can't really send it. Thanks, Bob From: Ashish Kumar To: Vaib

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-19 Thread bobengler
nd records too.. I assume that sheet2 doesnt have duplicates.. Cheers!! + I did not do this for you. God is here working through me for you. On Thu, Dec 18, 2014 at 11:38 AM, bobengler wrote: > > >It really needs a VBA Macro probably to check Sheet1 row by row to see if it >ha

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-17 Thread bobengler
Looks great. Is there an easy fix th bring over the colors in Sheet1 Column3 to Sheet3. If it's complicated, I can manually do it after it loads. I really appreciate your help. Thanks, Bob From: Mandeep Baluja To: excel-macros@googlegroups.com Sent: Thursday

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-17 Thread bobengler
The Test sheet looks good but can you do it where we do it with Sheet1 and Sheet2 putting the result in Sheet3? The highlight colors define what the value of Column3 is in Sheet 1 (I have manually done the hightlights in the real data). Thanks for the great help. Bob ___

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-17 Thread bobengler
It really needs a VBA Macro probably to check Sheet1 row by row to see if it has any matches in Sheet2. If you look at the Test Sheet, it shows what I need it to do. You will notice that a few rows have the same Column2 data in Sheet1. Thanks, Bob From: Mande

Re: $$Excel-Macros$$ Re: How to append row from 1 sheet to end of row of second sheet based on cell value

2014-12-17 Thread bobengler
Thank you for your help. Can you take a look at the Test sheet. It is what I'm trying to do using the new Sheet1 and Sheet2 I made. Bob Engler From: Mandeep Baluja To: excel-macros@googlegroups.com Sent: Wednesday, December 17, 2014 11:31 PM Subject: $$Excel