Dear Groups Member Please Help me, i have attached one Sheet i need that
when we fill Sheet 2 then automatically update Annual, Monthly & Sheet -1
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Us
Dear Ashishi,
Sending the the sample file.
thanks in advance for your cooperation.
On 8 October 2012 21:55, ashish koul wrote:
> can you attach the sample sheet
>
>
> On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote:
>
>> Dear wabs,
>> Thanks for your reply.
>> The amount should be allocated eq
Named and left open as I need to send them to their respective owners. I
attached a file for your reference to help better understand. You'll
notice how Bob has many numbers and others have 2 and others have one Sales
ID number. I also attached the Header format and the exact number of
colum
How do you want the files named?
Do you want them in a specific folder?
Do you want them left open at the completion of the macro? or close them all?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you
Option b please. Multiple rows based on value in column A. So everytime
4011 is found in column A, I would want the the corresponding row data
pasted into a separate workbook and tha sme for 4010, 4012, etc...I
appreciate the help. I know it's not hard, I'm just limited in terms of my
VBA kn
Are you saying that you want each row of data copied to a NEW workbook?
or are you say that you have multiple rows
that you want copied to separate workbooks based on the value in column A for
each row?
either way is easily done.
Paul
-
“Do all the good
I need a macro that will copy specific rows based on the first value in my
example:
A1 B1, C1, D1, E1, Etc... thru AA1
0041
0042
0043
0041
0041
0043
Etc...
A1 is the reference value. B1 through AA1 indicate the Data range I need
copied to a new worksheet but a workbook would be bet
This is a link by Lalit Mohan, one of the members of this forum
http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-through-excel-vba/
Regards,
Sam Mathai Chacko
On Mon, Oct 8, 2012 at 11:05 PM, sreekanth m
wrote:
> Hello Friends,
>
> Can anyone help me to Open Gmail URL and L
Hello Friends,
Can anyone help me to Open Gmail URL and Loging to it by Entering the
credentials using VBA
PFA, the screenshot for your reference,
*I need to Enter UserName, Password and Stay Signed In should be checked.
Then Click on Sign In and it should get navigated to GMail Account.*
P
Hi all,
I am Pritiranjan choudhury. I am from Delhi. I am working at Morningstar as
a financial research associate. i am 24.
On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current posters,
>
> Welcome to excel group,one of the largest online community of exc
hi Ashish,
Pl provide the solution, if you can.
On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com
wrote:
>
>
>
> Hi Ashish,
>
> The excel list is consists of account nos in text format in column A i.e.
> 05223300056, 05223300057, 05223300058 & so on rest w
can you attach the sample sheet
On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote:
> Dear wabs,
> Thanks for your reply.
> The amount should be allocated equally over the period of time.
> For example, for expenditure B, total expenditure of Rs. 1 has been
> distributed prorata basis. It wor
Dear wabs,
Thanks for your reply.
The amount should be allocated equally over the period of time.
For example, for expenditure B, total expenditure of Rs. 1 has been
distributed prorata basis. It works out 3667 for 22 days in April, 5000 for
may(full month) and 1333 for for June . The period
Always show a before/after and the logic
On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote:
>
> Need help
>
>
> Dear All,
> I need your help in automatic some calculations in spreadsheet.
>
> I have data in excel as below;
> It consists of 2 parts. first part is Expense stateme
Hi Anil,
It is not possible without macro.
Regards,
Swapnil.
On Mon, Oct 8, 2012 at 3:59 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Swapnil,
>
> ** **
>
> Find attached file with required solution, can you please help,
>
> ** **
>
> Regards,Anil Bhange
>
Some things you can try:
1. Try opening you file in Office Web Apps. http://skydrive.live.com/
2. Install open-source LibreOffice and try opening your file in that.
http://www.libreoffice.org/
3. Try opening your spreadsheet using a database connection (See
below)
4. Try
Hi
Can you explain base for allocation, theer is no standard method that can
be assumed on the basisi if data given by you.
Rgds//Vabs
On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote:
>
> Need help
>
>
> Dear All,
> I need your help in automatic some calculations in s
Dear Team
I want the performance count total allocate to Agency fe , date wise for
done,dp
Thanks
karthik.N
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Po
Most welcome Ramana in EXCEL-MACRO faimly. It is a great place to learn advance
excel and vba
Keep and See continue posting
Sent from BlackBerry® on Airtel
-Original Message-
From: Ramana
Sender: excel-macros@googlegroups.com
Date: Mon, 8 Oct 2012 03:24:40
To:
Reply-To: excel-macro
Hi All,
I am Ramana. Working in Thomson Reuters... I am learning Excel VBA and want
to be part of VBA forum.
I am a begginner and would like to work on VBA in future.
Thanks & Regards,
Ramana.
On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote:
>
> Hey all new and current poster
Dear Sanjib,
-- is an unary operator, without using it, Formula revert TRUE,TRUE or
TRUE,FALSE.
We can't sum it because it is Text, -- convert it in values like 1,1 or 0,0,
We can also use instead of --
1. 1*
2. 1^
3. 0+
4. /1
Hope you will understand,
On Sat, Oct 6, 2012 at 2:22 PM, San
Thank you sir
Regards,
Sanjib
On Sat, Oct 6, 2012 at 8:46 PM, ashish koul wrote:
> visit
> http://www.excelbanter.com/showthread.php?t=182549
>
>
>
> On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Noorain Ansari,
>>
>> Would you please te
Hi Anil,
Excel provide by you is quite confusing as I can see that there are
multiple entries of depot 4101. Pls provide final output you required.
Regards,
Swapnil.
On Mon, Oct 8, 2012 at 1:24 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Experts,
>
> ** **
>
> I need
Hi Vijayendra
Copy and paste the below formula in AJ6 cell
=IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"")
Drag the AJ6 formula to the remaining cells of AJ Column.
Refer the attachment file for details.
Hope that helps!
Let us know, in case of any further assistance.
<><><><><><><>
Dear All,
I have some data which includes amount data. I need the latest data’s date.
Request you to let me know what formula I can use it for the same.
Excel file is attached with example.
Regards,
Vijayendra
94491 67631
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
--
Join official facebook page of
25 matches
Mail list logo
