Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

[Eugenio Grant]

Variables identified as type = "double" should be treated differently in
order to adjust to a expected format...

On Wed, Feb 11, 2015 at 11:03 AM, Gaurav Devrani 
wrote:

> Why second line need to be restructured in different format. Like Pos3
>
> pos 5
>
> Please let me know. I will work on that.
>
> On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant 
> wrote:
>
>> I have a Excel Sheet lile this:
>>
>> type  Begin   End   Text   Var
>> simple   1  2  Car v43
>> double   3  5  Ball v50
>>
>> I want to reestructure and save to Word, (via VBA or Macro) reestructured
>> like this:
>>
>> [v43] Car
>> simple
>> POS 1 to 2
>>
>> [v50] Ball
>> double
>> POS 3
>> POS 5
>>
>> Thanks for your help.
>>
>> --
>> 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, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Thanks & Regards
> Gaurav Devrani
>
>  --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/ag1HegTY7Hk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*_*


*Eugenio Grant MoraData & Procesos**eugenio.gr...@gmail.com
*


*_*

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Reestructure Excel File and Save as Word file

[Gaurav Devrani]

Why second line need to be restructured in different format. Like Pos3

  pos 5

Please let me know. I will work on that.

On Wed, Feb 11, 2015 at 8:09 AM, Eugenio Grant 
wrote:

> I have a Excel Sheet lile this:
>
> type  Begin   End   Text   Var
> simple   1  2  Car v43
> double   3  5  Ball v50
>
> I want to reestructure and save to Word, (via VBA or Macro) reestructured
> like this:
>
> [v43] Car
> simple
> POS 1 to 2
>
> [v50] Ball
> double
> POS 3
> POS 5
>
> Thanks for your help.
>
> --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks & Regards
Gaurav Devrani

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

[Paul Schreiner]

The code itself isn't difficult.
But it would be a VERY specific solution.
 
If you decide to change the row to output the result,
or starting column,
or even where you put the values you're using,
it would require you to find someone to modify the code.
 
Unless you're wanting to invest the time to dive into the world of VBA macros, 
I'd suggest sticking with the simpler copy/drag of the Excel functions.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Enock Wangila 
>To: excel-macros@googlegroups.com 
>Sent: Wednesday, February 11, 2015 10:13 AM
>Subject: Re: $$Excel-Macros$$ Re: Help with excel data fill formula
>  
>
>I have no VBA coding experience. Could you refer me to a resource that
>I can use to write the command or a better alternative.
>
>
>
>On 2/11/15, Paul Schreiner  wrote:
>> Sorry, EXCEL functions cannot act on other cells.
>>
>> If you wanted to write a VBA macro, then this could be done.
>> You could even make it an "event" macro on "Worksheet one"
>> such that when the values in the two cells change,
>> "worksheet two" automatically updates.
>>
>> Paul
>> -
>> "Do all the good you can,
>> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can." - John Wesley
>> -
>>
>>
>>>
>>> From: Enock Wangila 
>>>To: excel-macros@googlegroups.com
>>>Sent: Wednesday, February 11, 2015 9:15 AM
>>>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>>>
>>>
>>>
>>>
>>>
>>>Hi,
>>>
>>>
>>>Thank you Paul for the response. It is what I was looking out for. Just one
>>> more question, could the formula fill up the cells without having to drag
>>> it? If one exists, will much appreciate.
>>>
>>>
>>>Cheers.
>> --
>>>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, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>2) Don't post a question in the thread of another member.
>>>3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>4) Acknowledge the responses you receive, good or bad.
>>>5) Jobs posting is not allowed.
>>>6) Sharing copyrighted material and their links is not allowed.
>>>
>>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>>---
>>>You received this message because you are subscribed to the Google Groups
>>> "MS EXCEL AND VBA MACROS" group.
>>>To unsubscribe from this group and stop receiving emails from it, send an
>>> email to excel-macros+unsubscr...@googlegroups.com.
>>>To post to this group, send email to excel-macros@googlegroups.com.
>>>Visit this group at http://groups.google.com/group/excel-macros.
>>>For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>>
>> --
>> 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, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>-- 
>
>*Enock Wangila,*
>*Intern Analyst*
>
>*Umati Capital Ltd*
>
>
>*Eden Square *
>
>*Block 1, 7th Floor*
>*P.O Box 856-00606*
>
>
>*Mobile: +254 708 037 464*
>*Email: ekwang...@gmail.com *
>
>
>
>
>
>-

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

[Enock Wangila]

I have no VBA coding experience. Could you refer me to a resource that
 I can use to write the command or a better alternative.



On 2/11/15, Paul Schreiner  wrote:
> Sorry, EXCEL functions cannot act on other cells.
>
> If you wanted to write a VBA macro, then this could be done.
> You could even make it an "event" macro on "Worksheet one"
> such that when the values in the two cells change,
> "worksheet two" automatically updates.
>
> Paul
> -
> "Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can." - John Wesley
> -
>
>
>>
>> From: Enock Wangila 
>>To: excel-macros@googlegroups.com
>>Sent: Wednesday, February 11, 2015 9:15 AM
>>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>>
>>
>>
>>
>>
>>Hi,
>>
>>
>>Thank you Paul for the response. It is what I was looking out for. Just one
>> more question, could the formula fill up the cells without having to drag
>> it? If one exists, will much appreciate.
>>
>>
>>Cheers.
> --
>>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, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>2) Don't post a question in the thread of another member.
>>3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>4) Acknowledge the responses you receive, good or bad.
>>5) Jobs posting is not allowed.
>>6) Sharing copyrighted material and their links is not allowed.
>>
>>NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>>---
>>You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>>To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>>To post to this group, send email to excel-macros@googlegroups.com.
>>Visit this group at http://groups.google.com/group/excel-macros.
>>For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
>
> --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>


-- 

*Enock Wangila,*
*Intern Analyst*

*Umati Capital Ltd*


*Eden Square *

*Block 1, 7th Floor*
*P.O Box 856-00606*


*Mobile: +254 708 037 464*
*Email: ekwang...@gmail.com *

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Reestructure Excel File and Save as Word file

[Eugenio Grant]

I have a Excel Sheet lile this:

type  Begin   End   Text   Var
simple   1  2  Car v43
double   3  5  Ball v50

I want to reestructure and save to Word, (via VBA or Macro) reestructured 
like this:

[v43] Car
simple
POS 1 to 2

[v50] Ball
double
POS 3
POS 5
   
Thanks for your help.

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

[Paul Schreiner]

Sorry, EXCEL functions cannot act on other cells.
 
If you wanted to write a VBA macro, then this could be done.
You could even make it an "event" macro on "Worksheet one" 
such that when the values in the two cells change, 
"worksheet two" automatically updates.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Enock Wangila 
>To: excel-macros@googlegroups.com 
>Sent: Wednesday, February 11, 2015 9:15 AM
>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>  
>
>
>
>
>Hi,
>
>
>Thank you Paul for the response. It is what I was looking out for. Just one 
>more question, could the formula fill up the cells without having to drag it? 
>If one exists, will much appreciate.
>
>
>Cheers.
-- 
>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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Help with excel data fill formula

[Enock Wangila]

Hi,

Thank you Paul for the response. It is what I was looking out for. Just one 
more question, could the formula fill up the cells without having to drag 
it? If one exists, will much appreciate.

Cheers.

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

[Paul Schreiner]

Hmm.. your question and expectations are unclear.
 
a "formula" technically is an equation that may or may not contain functions.
 
=TODAY() + 3
is a formula that uses the TODAY() function to calculate the date 3 days from 
the current date.
 
>From your question, you want to insert a specified value (5000)
into a specified number of cells on a sheet named "Worksheet two".
 
what are the limits on the "cell entries to fill"?

on "Worksheet two", you can place the formula:
=IF(COLUMN()-1<='Worksheet one'!$B$3,'Worksheet one'!$B$2,"")
in cells B4 through Z4

is that the kind of thing you're looking for?

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-

 From: Enock Wangila 
>To: excel-macros@googlegroups.com 
>Sent: Wednesday, February 11, 2015 5:54 AM
>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula
>  
>
>
>
>
>Here is an illustration of what I am requesting for. I hope it helps make the 
>case clearer.
>
>
>Cheers  
>-- 
>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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Count duplicate records.

[Paul Schreiner]

REALLY need more infomation.
 
 
 
 
 
 
I was tempted to leave it at that:
 ask for more info, but not say what info is needed. 

There ARE functions that CAN be used (or used in combination) to count 
duplicate records.
But it REALLY depends on the format of the data and what is considered 
"duplicate".

you said you wanted a "formula".
By "formula", do you mean Excel "function" or VBA functions in a macro?

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Ahmad Mustfa 
>To: excel-macros@googlegroups.com 
>Sent: Wednesday, February 11, 2015 6:00 AM
>Subject: $$Excel-Macros$$ Count duplicate records.
>  
>
>
>Hi all.
>I am looking for a  formula to count duplicate records for a specific 
>class/field in excel. Please help. Thanks
>
>
>--
>Regards,
>
>
>Ahmad Mustafa
>+44 7768197568
> 
-- 
>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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ User name to be picked up in excel

[Paul Schreiner]

Where do the names come from?
what does the value in column "K" have to do with these names?
 
I see JKD lsted for case 48 and 12, so it evidently isn't some form of unique 
index...

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Pravin Gunjal 
>To: Excel Macros ; Paul Schreiner - Excel 
>; Vaibhav Joshi (Vabz) - Mumbai Excel ; 
>Ms-Exl-Learner - Chennai  
>Sent: Wednesday, February 11, 2015 6:24 AM
>Subject: $$Excel-Macros$$ User name to be picked up in excel
>  
>
>
>Hi, 
>  
>The user name to be picked up by formula in the column L once the value is 
>entered in column K 
>  
>I have entered few names manually.  Please help. 
>  
>Regards,
>Pravin Gunjal
-- 
>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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
>2) Don't post a question in the thread of another member.
>3) Don't post questions regarding breaking or bypassing any security measure.
>4) Acknowledge the responses you receive, good or bad.
>5) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
>members are not responsible for any loss.
>--- 
>You received this message because you are subscribed to the Google Groups "MS 
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

[Pravin Gunjal]

Hi Vabs

Following is the code:

Function savedbf() As Boolean
Dim filename As Variant
Dim temp As Variant
Dim currentFile As String
Dim defaultFile As String

currentFile = ActiveWorkbook.Name
temp = Split(currentFile, ".")
temp(UBound(temp)) = "dbf"
defaultFile = Join(temp, ".")
If defaultFile = "dbf" Then
defaultFile = ActiveWorkbook.Name & ".dbf"
End If
filename = Application.GetSaveAsFilename(InitialFileName:=defaultFile,
FileFilter:="DBF 4 (dBASE IV) (*.dbf),*.dbf", Title:="Save As DBF")

If filename = False Then Exit Function

savedbf = DoSaveDefault(filename)
End Function

Function DoSaveDefault(ByVal filename As String)
' Declare DB vars
Dim path As Variant
Dim file As Variant
Dim tfile As Variant
Dim table As Variant
Dim dbConn As ADODB.Connection

' Initialize DB vars
path = Split(filename, "\")
file = path(UBound(path))
file = Replace(Left(file, Len(file) - 4), ".", "_") & Right(file, 4)
tfile = "__T_DB__.dbf"
path(UBound(path)) = ""
path = Join(path, "\")
table = Left(tfile, 8)
filename = path & file

' Check if file exists
On Error Resume Next
GetAttr filename
If Err.Number = 0 Then
Dim mbResult As VbMsgBoxResult
mbResult = MsgBox("The file " & file & " already exists. Do you
want to replace the existing file?", _
VbMsgBoxStyle.vbYesNo + VbMsgBoxStyle.vbExclamation, "File
Exists")
If mbResult = vbNo Then
DoSaveDefault = False
Exit Function
Else
SetAttr filename, vbNormal
Kill filename
End If
End If

Err.Number = 0

GetAttr filename
If Err.Number = 0 Then
MsgBox "Unable to remove existing file " & file & ".",
vbExclamation, "Error Removing File"
DoSaveDefault = False
Exit Function
End If
On Error GoTo 0

' Open DB connection
Set dbConn = New ADODB.Connection
dbConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path &
";Extended Properties=""DBASE IV;"";"

' Declare excel vars
Dim dataRange As Range

Set dataRange = Selection

If dataRange.Areas.Count > 1 Then
MsgBox "The command you chose cannot be performed with multiple
selections. Select a single range and click the command again.", _
VbMsgBoxStyle.vbCritical, "Error Saving File"
DoSaveDefault = False
Exit Function
End If

' Expand selection if single cell (Expands selection using the Excel
2003 save DBF behavior)
'If dataRange.Cells.Count = 1 Then
'If IsEmpty(dataRange.Cells(1).Value) Then
'MsgBox "The command could not be completed by using the range
specified. Select a single cell within the range and try the command
again.", _
'VbMsgBoxStyle.vbExclamation, "Error Saving File"
'DoSaveDefault = False
'Exit Function
'Else
'Set dataRange = dataRange.CurrentRegion
'End If
'End If

' Expand selection if single cell (Differs from normal Excel 2003
behavior by not stopping at blank rows and columns)
If dataRange.Cells.Count = 1 Then
Dim row1 As Integer
Dim rowN As Integer
Dim col1 As Integer
Dim colN As Integer
Dim cellFirst As Range
Dim cellLast As Range

row1 = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlByRows,
SearchDirection:=xlNext).row
col1 = ActiveSheet.Cells.Find(What:="*", SearchOrder:=xlByColumns,
SearchDirection:=xlNext).Column
rowN = ActiveSheet.Cells.Find(What:="*", After:=[A1],
SearchOrder:=xlByRows, SearchDirection:=xlPrevious).row
colN = ActiveSheet.Cells.Find(What:="*", After:=[A1],
SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column

Set cellFirst = ActiveSheet.Cells(row1, col1)
Set cellLast = ActiveSheet.Cells(rowN, colN)
Set dataRange = ActiveSheet.Range(cellFirst.Address,
cellLast.Address)
End If

' Declare data vars
Dim i As Integer
Dim j As Integer
Dim numCols As Integer
Dim numDataCols As Integer
Dim numRows As Long
Dim createString As String
Dim fieldpos(), fieldvals(), fieldtypes(), fieldnames(), fieldactive()

numCols = dataRange.Columns.Count
numDataCols = 0
numRows = dataRange.Rows.Count
ReDim fieldtypes(0 To numCols - 1)
ReDim fieldnames(0 To numCols - 1)
ReDim fieldactive(0 To numCols - 1)

' Fill field names
i = 0
For Each c In dataRange.Rows(1).Columns
' Mark column active if not blank
If WorksheetFunction.CountA(c.EntireColumn) > 0 Then
fieldactive(i) = True
numDataCols = numDataCols + 1

If VarType(c.Value) = vbString Then
fieldnames(i) = Left(Replace(c.Value, " ", "_"), 10)
Else
fieldnames(i) = "N" & c.Column
End If
Else
fieldactive(i)

$$Excel-Macros$$ User name to be picked up in excel

[Pravin Gunjal]

Hi,



The user name to be picked up by formula in the column *L* once the value
is entered in column *K*



I have entered few names manually.  Please help.




*Regards, Pravin Gunjal*

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Data Entry.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Add No of Years Specified

[Hilary Lomotey]

Splendid Paul, exactly how i want it. thanks very much

On Tue, Feb 10, 2015 at 9:33 AM, Paul Schreiner 
wrote:

>  [image: Boxbe]  This message is eligible
> for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule
> 
> | More info
> 
>
> How's this?
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Hilary Lomotey 
> *To:* excel-macros 
> *Sent:* Tuesday, February 10, 2015 11:30 AM
> *Subject:* $$Excel-Macros$$ Add No of Years Specified
>
> Hello Experts,
>
> i am developing a form and i need assistance with a code, i can do it with
> a formula but i dont like the final results because of the final output i
> want. Basically in sheet2, when i click on setup and i choose a start year
> for instance 2006 and specify the number of years for historical data after
> the 2006 say 4 years in textbox1, i want sheet2 column C to be filled  with
> 2007, D=2008 , E=2009 to make up for the 4 years and then if i specify that
> say 5 years for the forecast period in textbox3  then it should skip one
> column and start the forcast period from 2010 in G, Thru to column K=2014
> for the 5 year forecast period. But i want it in a dynamic way such that
> and period i specify will flow automatically and skip one column to start
> the forecast period.
>
> kindly assist with the VBA solution. i am unable to skip one column when i
> use formula and thats why i prefer the VBA solution
> --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>

-- 
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 Fa

$$Excel-Macros$$ Count duplicate records.

[Ahmad Mustfa]

Hi all.
I am looking for a  formula to count duplicate records for a specific
class/field in excel. Please help. Thanks

--
Regards,

Ahmad Mustafa
+44 7768197568

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Help with excel data fill formula

[Enock Wangila]

> Here is an illustration of what I am requesting for. I hope it helps make 
> the case clearer.
>

Cheers 

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Data Entry help illustration.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Re: Run time error...

[Vaibhav Joshi]

It is more clear now...

Cheers!!

On Tue, Feb 10, 2015 at 7:00 PM, Christos Alekopoulos <
christosalekopou...@gmail.com> wrote:

> Thanks Vabz but I don't want just a function that replaces any value. My
> post explains fully what I needed!
> Cheers
>
> --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Help with excel data fill formula

[Vaibhav Joshi]

Hi

Share excel file for more clarity..

Cheers!!

On Wed, Feb 11, 2015 at 11:26 AM, Enock Wangila  wrote:

> Hi Guys,
>
> Please help me find a solution to this challenge. I need a formula that
> helps me fill multiple cells in a different worksheet by entering a value
> in a single cell in another worksheet. For instance, I have a cell with a
> value of 5000 in one worksheet and I need a formula to populate 9 cells, in
> the same row, in a different worksheet. It has to be a formula or a code.
>
> Thank you for your input.
>
> Enock
>
>
>  --
> 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, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.