Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread GENIUS
I think there is some misunderstanding, actually I need a macro for column A:F, I want to create the same i.e. column A:F thru macro, because if you see column A:F created thru formulas and the source of references has been taken from column I:L, so column I:L are just for references and nothing

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread silvers.r via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 9:04 PM

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:47 PM

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread hopkinsruben865 via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:17 PM

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 6:13 PM

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Wed, 1/18/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: "excel-macros@googlegroups.com" Date: Wednesday, January 18, 2017, 4:37 PM So, you're saying that you're trying to learn

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-18 Thread Paul Schreiner
So, you're saying that you're trying to learn how to write macros and you'd like us to write a macro that would take the list in columns A:F and create the list in columns I:L? The problem with that is that you're asking us to take the "input" (columns A:F) and compare it to the output (columns

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-17 Thread GENIUS
sometime when you have to learn a new function or formula, for this purpose one must have a file on which the same function or formula must be applied so I need a data set for my learning about a new function or new formula, I have created it thru function but the same I want to create thru macr

Re: $$Excel-Macros$$ converting sheet to macro

2017-01-17 Thread Paul Schreiner
 What exactly are you trying to do?I see in your attachment, that you have a list of employees with Department, Hiring Year, Region, Gender and "Amount" Then, it seems you've begun a list with only the Hiring year, Gender, Department and Region. so, are you simply taking the information from the