$$Excel-Macros$$ Need help in macro

2016-08-26 Thread Manju Deva
Hi I need your help to create a macro for the below mentioned scenario. *Scenario* We need two columns namely User, drop down *“IF user enter data in User column(cells) a automatic drop down needs to create in a column B* *Else* *No drop down required”* *And the macro should ru

$$Excel-Macros$$ Need help in Macro

2009-02-20 Thread Nimaj
Hi, I am new to this space, please help me with a simple requirement in macro. Consider that my required value is 2300 Type Value Quantity Extended Value 100 2500.00 0 0.00 200 3500.00 0 0.00 300 5000.00 1

Re: $$Excel-Macros$$ Need help in macro

2016-08-27 Thread Learner Excel
HI Manju, See this help you -- On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote: > Hi > > > > I need your help to create a macro for the below mentioned scenario. > > > > *Scenario* > > > > We need two columns namely User, drop down > > > > *“IF user enter data in User column(cells) a automa

$$Excel-Macros$$ Need Help in Macro Loop for data dirstribution

2016-01-05 Thread Pankaj K Pandey
Good Evening Experts, I am stuck in a very big problem, In Attached file, I have some data in RAW data file and I want to distribute that data in all the other sheets basis on Wave name date and employee name. Sheet would be different basis on WAVE mean. for example data for Wave 1 need to go

$$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread Secret Shot
Dear Team, I have one very large excel table which i made from Raw data, accidentally raw data has been deleted and the only option i have is that table to convert back in raw data. Its about my job so pls help, i have attached of the sample of what i am talking about. if anyone can me in writing

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread Paul Schreiner
There is no standard format for "Raw Data".It depends on the original Application used to CREATE the source of data.Some systems output ASCII (text) files Some are tab delimited.Others are comma delimited (csv). The mechanism you used to read in the "raw data" used known characteristics of the d

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread 'Martin George' via MS EXCEL AND VBA MACROS
On Thu, 6/1/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: "excel-macros@googlegroups.com" Date: Thursday, June 1, 2017, 4:47 PM There is no standard format for &qu

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread Secret Shot
Dear Paul, I appreciate your quick response, However when i say raw data it means just simple table in Excel which i have shown in attached excel sheet only in column L and M. So you can consider it as requirement or data rearrangement from table 1 (Column A to G) to table 2 (Column L to M). I h

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread Paul Schreiner
In THAT case: If you name a range "Result" and have it include the "summary" table without the column headings or phone numbersB4:G9 in your sample Then, name a range called "Data" that includes the original "Data" without the column headingsL4:M1000 in your example. Then you can use a macro like

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread Secret Shot
Thanks Paul, This is exactly what i was needed. you are a life saviour On Thu, Jun 1, 2017 at 11:34 PM, Paul Schreiner wrote: > In THAT case: > > If you name a range "Result" and have it include the "summary" table > without the column headings or phone numbers > B4:G9 in your sample > > Then, n

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-01 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Thursday, June 1, 201

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-02 Thread 'Martinez David' via MS EXCEL AND VBA MACROS
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump. To: excel-macros@googlegroups.com Date: Friday, June 2, 201

Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.

2017-06-02 Thread Saleem Ansari
PFA Solved question.. On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote: > Dear Team, > > I have one very large excel table which i made from Raw data, accidentally > raw data has been deleted and the only option i have is that table to > convert back in raw data. > > Its about my job so pls hel