use format painter select sheet 1 range click format painter go to sheet 3
click first cell of range. welcome
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matches columnB in sheet1, append the data from the
> row in sheet2 to the end of the row
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
PFA !!!
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matches columnB in sheet1, append the data from the
Dear Sir,
Thank you very much.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja
wrote:
>
> check this out.
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
> On Wednesday,
For sure bob give me 10 minutes
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matches columnB in sheet1, append the data from the
> row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple
> rows with the same column data and the d
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
___
Do one thing highlight the wrong values retrieved with the formulas it will
help us to understand your query as well.
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matches columnB in sheet1, append the data from the
> row in sheet2 to the end of
Have you checked the Test sheet columns where I have put the new formulas.
after comparing it with your desire result i found no error ?? if yes then
confirm few things.
Comparison is going in between.
1)Columns 1 of sheet2 match with column 2 of sheet1 ? then sheet1 rows data
append with sh
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
Hello friends,
Thanks to all members in advance.
I have query regarding microsoft word. it is 60 page project file, 15-40
pages fixed like to be locked.
I want to edit between 1 to 14 and 41 to 60. is it possible?
Please let me know. if you have further question regarding the same
question.
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matches columnB in sheet1, append the data fr
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
check this out.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO.
Dear Expert, You did an excellent Job. Thanks for it.
On Wednesday, 17 December 2014 15:41:22 UTC+3, Vabz wrote:
>
> hi
>
> can you share your experience with us?
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar
wrote:
>
> Welcome Ashu.
>
> --
> 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
Check this sheet , you're trying to achieve this ?
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, December 18, 2014 5:27:30 AM UTC+5:30, Bob Engler wrote:
>
> If columnA in sheet2 matche
If columnA in sheet2 matches columnB in sheet1, append the data from the
row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple
rows with the same column data and the data from sheet2 needs to be added
to all sheet1 matching rows. ie:
Sheet1:
hr abc ddd rrt
hr dew ggg wqq
hr
I'm sorry, but according to the forum rules:
3) Don't post questions regarding breaking or bypassing any security measure.
we should not address that here.
If you use Google, you'll find thousands of methods and service providers!
Paul
-
“Do all the good
Hello ,
Can anyone please help to provide solution on how to unprotect the workbook
if password is lost.
I have attached one sample file.
Thanks,
Yudy
--
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
Welcome Ashu.
--
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,
Dear Vaibhav/Ashish Sir,
Thanks for your help. I am looking for this only.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar
wrote:
>
> Hi Ashu,
>
> Check this!!
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
Hi Ashu,
Check this!!
Regards
Ashish
--
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 titl
Dear Sir,
I want only single formula. I have some blank Cells in A and B column in
sheet 2. Query is attached please check again.
--
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.
Hi Ashu,
Use Simple Vlookup function which is suggested by Vaibhav Sir.
and Delete NA# with help of filter.
It's simple.
Regards
Ashish
--
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.
Dear Sir,
I have some Blank cells in A column and Some Blank Cells in B Column in
sheet 2.
I want to match the C column data from Sheet 1.
only single formula required. If we don't want to put any formula in A and
B column but some cells are blank in both columns.
It is possible.
Thanks
Ashu K
Dear Sir,
I have huge data, So i want only single formula. or can it done by vba help.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A and B column, I want
> to get data in C column only. Don't want to pu
Yes, only if class no. is also unique the same way Name.
Check this cell with blue color.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A a
Dear Sir,
Thanks for your support. I dont want to get data in A and B column, I want
to get data in C column only. Don't want to put formula in A and B column.
It is possible. to get data from Sheet 1 without put any formula in A and B
column in Sheet 2.
pls help.
Thanks
Ashu Kenith
On Wed, De
Hi
Check this..cell with yellow colour has formula.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:21 PM, Ashu k wrote:
>
> Dear Seniors,
>
> Please help. how can i get data from sheet 1
>
> Ashu Kenith
>
>
> On Wed, Dec 17, 2014 at
Dear Seniors,
Please help. how can i get data from sheet 1
Ashu Kenith
On Wed, Dec 17, 2014 at 6:30 PM, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam Date
>
>
> and,
>
> I have data in Sheet 2
>
> Name Class Roll No. Exam Date
>
>
> But some Name
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
and,
I have data in Sheet 2
Name Class Roll No. Exam Date
But some Names are not in Name Column and Some Class are not in Class
Column, I want to get all Roll No. in Sheet 2 from Sheet 1.
Example data attached. Pleas
hi
can you share your experience with us?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 2:14 PM, Vaibhav Joshi wrote:
>
> Hey Zafar,
>
> You can try this code...
>
> Hope this helps / you can also share any alternate method you have found
>
Hi Rakesh
Did you checked this?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 10:32 PM, Vaibhav Joshi wrote:
>
> Mr. Aptech...
>
>
> Check this..
>
> Goto Input sheet, Pres Alt + F8 to run macro..
>
> Cheers!!
>
> +
> *I did not do this f
33 matches
Mail list logo
