I have made this code for I have two worksheets that are in the same
workbook.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1,
Kindly find the file attached.
On Tuesday, November 11, 2014 1:17:46 PM UTC+5:30, Mandeep Baluja wrote:
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1, Column B. If there
is a match, then copy/write the
Awesome ashish
On Tuesday, November 11, 2014 1:11:31 PM UTC+5:30, Ashish Kumar wrote:
Hi Saleem,
PFA
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 @
Yes there is option in excel to split the data in seperate column as same
format of pdf .
On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote:
Hello ,
I need your help with regards to the attached macro file.
I am trying to convert the pdf file to excel format but the
Thanks Mandeep.
--
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,
One thing I let you know that you're are truely awesome in excel and in
concepts the way you answering the questions of Excel VBA related. Wish you
good luck for you future.
On Monday, September 15, 2014 5:41:09 PM UTC+5:30, Mandeep Baluja wrote:
Who is Vabz and how much experience he'
Guys ..Kindly,can you please help me or give me root to solve this problem.
Waiting for your valuable comments.
Lax
On Tuesday, November 11, 2014 1:27:54 PM UTC+5:30, Laxmanan M wrote:
Hi All,
Need help to complete my task using vba.Thanks in advance..Attaching the
workbook here for
I got understand it today . thanks vab I can't expect this kind of
formula what a logical thinking .
On Saturday, August 16, 2014 8:02:59 PM UTC+5:30, Vabz wrote:
Cheers !!
On Aug 16, 2014 4:38 PM, Rajan Verma rajanve...@gmail.com javascript:
wrote:
Wow
On Monday, 11 August 2014
Hi Vaibhav Bhai,
It's great.
--
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
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 4:49 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Vaibhav Bhai,
It's great.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Select cell B4 then try this sequence..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 6:32 PM, Tarun Verma bhawani.pa...@gmail.com
wrote:
Thanks Vab for your prompt revert and i tried the same but getting
error in doing same.
Error
Hi
Can you share sample data with desired result..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 1:17 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
I have made this code for I have two worksheets that are in the same
workbook.
check this code for macro 1
Option Explicit
Sub Check_Dupe_2()
Dim n, i, str() As String
Application.ScreenUpdating = False
n = Range(A Rows.Count).End(xlUp).Row
ReDim str(1 To n + 1)
With CreateObject(Scripting.Dictionary)
For i = 1 To n
str(i) = Cells(i, C) Chr(30) Cells(i, AF)
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 4:06 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
One thing I let you know that you're are truely awesome in excel and in
concepts the way you answering the questions of Excel VBA
how to use function show all location by country name
pfa
Regards,
Anil Kumar Maurya
--
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
Check this...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 1:33 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
I have made this code for I have two worksheets that are in the same
workbook.
On Tuesday, November 11, 2014
This is driving me nuts. What am I doing wrong?
I'm need to open a new workbook and the name of that new workbook is
contained in a cell. All I need to do is copy the data, close the new
workbook, retain the data in the clipboard, then paste the data into my
original workbook. Here's where
I cannot test it right now, but there are some things that look odd to me.
I usually use Activeworkbook.close savechanges:=false
and, I'd suggest that you paste the clipboard before you close the workbook.
I'm not sure how Windows decides, but sometimes when you close the SOURCE of
the clipboard
I'd like to paste the data before I close the sheet, but I'm having trouble
figuring out how to do that. Since the name of the new worksheet is
variable (the name is in a cell on the original sheet), the usual Activate
commands don't seem to work.
On Tuesday, November 11, 2014 4:09:45 PM
I have worksheet where my URL links where the text is Yes' has a link
similar to this:
Thanks Vab,
your instruction working superb but still there is miss match fill is
attached with higlighting concern in red color.
Done % for grand total is 217%.
Thanks for you help
Regards,
On 11/11/14, Vaibhav Joshi v...@vabs.in wrote:
Select cell B4 then try this sequence..
+
*I
Hi Bud,
PFA!!
Do changes in macro according to your requirement in Set x and Set y.
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
Hi friends,
pfa
please help me only vlookup function use find duplicate value.
Regards,Anil Kumar Maurya
--
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
Hi All,
Need some help to create a User form based on the logic.
If any enter Sub Brand numbers in cell F12 Invoice number in cell
G12 then I want the H should be update automatic as per the above
table numbers.
I have done the exercise which is manual Vlookup formula but i need
the same logic
Hi All,
I want you to understand the requirements.
Sub Brand numbers Invoice number combination will be multiple.
Can anyone will be help me out to create a user form.
for eg:
Brand numbers Invoice numbersStatus
90121 97012
25 matches
Mail list logo