Hi Vaibhav Bhai,
Sheet is working fine. Superb!
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
On Oct 11, 2014 6:51 AM, "Ahmed Siddique" wrote:
>
> Thanks Paul.
> Actually I am learning on daily basis following your posts and
implementing as much in my projects. I was not able to change the captions
actually, so had to use two buttons.
> But thanks a lot.
>
> On Oct 10, 2014 7:50 PM, "Paul
Dear paul,
its so nice..
That changed part working fine ..But am facing error in the below line of
the code
* With .PivotFields(aryRowFields(i))*
Thanks,
Lax
On Monday, October 27, 2014 5:45:46 PM UTC+5:30, Paul Schreiner wrote:
> There's really nothing I can do to help.
> It'
Check this sheet with code under module "Move_Same_ColoredTab"
This will move all same colored sheets to new WB with existing WB name with
suffix 1,2 ,3 etc.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval
wrot
I'm not sure what I'm looking at here with:
'--
B_n:Cells(Frow, Fcol).Select' force location
Tytle = "Enter charges:"
'---
On 10/22 You had written:
Attempted to try:
Private Sub Workbook_SheetSelectionChange( ByVal WkSh As Object, ByVal AmAt As
There's really nothing I can do to help.
It's not a macro problem, it's a problem in your data files.
In Customer.xlsm,your Co1 thru Co8 sheets have columns A-O
but in your new workbook, you've dropped the "City" field and the "HS" field.
CoL Cust Cust_reval
A CUST# CUST#
B CUST-N
Since I don't know much about your workbook,
I first had to create a workbook with 50 sheets with one of 10 randomly
selected tab colors.
I then made some assuptions and threw this together:
It MOVES all sheets to new workbooks. (except for the last sheet)
It does NOT provide names for the new wor
Dear paul,
Thanks for the Intrest to help me..But i have to run the macro for Customer
reval.Xlsm only.Im newbie for vba and am in the learning phase..please help
me to edit the codes whish should work for Customer reval.Xlsm .Becoz this
file is the final file for us now.Please help me on the sa
The problem seems to be that in your workbook Company_Reval.xlsm,
your consolidated sheet is missing column headings in column N and O
All columns in your pivot table have to have column headings.
looking a bit closer, it looks like your new file is missing the City column
from column J, which
For each tab color separate workbook or colored WS in separate WB?
Want to copy or move WS?
+
*I did not do this for you. God is here working through me for you.*
On Mon, Oct 27, 2014 at 1:33 PM, Nilkanth Raval
wrote:
>
> On 26 October 2014 09:06, Ashish Kumar wrote:
>
>> Nilkanth
>
>
> D
On 26 October 2014 09:06, Ashish Kumar wrote:
> Nilkanth
Dear Sir,
Thanks for your reply.
Exactly i want to *Separate the Worksheets by Tab color & convert it into
Workbooks.*
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“S
11 matches
Mail list logo
