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

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.

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

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

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

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 t

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

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

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] B

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

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 -

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

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

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 val

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

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 "dupl

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

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

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

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 = J

$$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 offic

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

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 >

$$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 thi

$$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 FOR

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

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)) i

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

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 anothe