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