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 help, i have attached of the sample of what i am
> talking about. if anyone can me in writing a macro which can create raw
> data basis on the count in front of number and considering their header.
>
> Please help
>
> --
> Pankaj Pandey
> Bhopal
>
> --
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


temp.xlsx
Description: MS-Excel 2007 spreadsheet

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, 2017, 4:22 AM
 
 
 
 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, 2017, 6:30 PM
  
  
 
 
  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 "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
 data to
  determine how it is to
   be interpreted.
   Without
   knowing the characteristics of
 the
  "raw data", it
   would be impossible to
  reverse-engineer the file.
   It's
   like saying:  "I'm standing
 outside
  of my home,
   tell me how I got here"The
   answer requires first knowing
 where
  you started and what
   options are available to get
 from the
  start to the
   end.Lots
   of options are AVAILABLE, but if
 your
  starting point is two
   streets away, the use of an
 airplane
  is unlikely.
   Teleportation is WAY cooler,
 and
  should remain in
   consideration for that reason!
 :)
   More
   details are
 
 required. 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
  
 
 -
   
   
   
      On Thursday, June 1,
   2017 10:20 AM, 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 help, i
 have
  attached of the sample of
   what i am talking about. if
 anyone can
  me in writing a macro
   which can create raw data basis
 on the
  count in front of
   number and considering their
 header.
    
   
   Please help
   -- 
   Pankaj Pandey
   Bhopal
   
   
   
   
   -- 
   
   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
 
 https://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

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, 2017, 6:30 PM
 
 
 
 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 "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 data to
 determine how it is to
  be interpreted.
  Without
  knowing the characteristics of the
 "raw data", it
  would be impossible to
 reverse-engineer the file.
  It's
  like saying:  "I'm standing outside
 of my home,
  tell me how I got here"The
  answer requires first knowing where
 you started and what
  options are available to get from the
 start to the
  end.Lots
  of options are AVAILABLE, but if your
 starting point is two
  streets away, the use of an airplane
 is unlikely.
  Teleportation is WAY cooler, and
 should remain in
  consideration for that reason! :)
  More
  details are
 required. 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
 
 -
  
  
  
     On Thursday, June 1,
  2017 10:20 AM, 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 help, i have
 attached of the sample of
  what i am talking about. if anyone can
 me in writing a macro
  which can create raw data basis on the
 count in front of
  number and considering their header.
   
  
  Please help
  -- 
  Pankaj Pandey
  Bhopal
  
  
  
  
  -- 
  
  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
 https://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

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, name a range called "Data" that includes the original "Data" without
> the column headings
> L4:M1000 in your example.
>
> Then you can use a macro like this to rebuild the detailed list:
>
>
> Sub Restore_Data()
> Dim nRows, rCell As Range, nCol, nRow, dRow, dCol
> Dim nCnt
> ActiveSheet.Range("Data").ClearContents
> dCol = ActiveSheet.Range("Data").Column
> dRow = ActiveSheet.Range("Data").Row - 1
> For Each rCell In ActiveSheet.Range("Result").Cells
> If (Int(rCell.Value) > 0) Then
> For nCnt = 1 To rCell.Value
> dRow = dRow + 1
> ActiveSheet.Cells(dRow, dCol).Value =
> ActiveSheet.Cells(rCell.Row, "A").Value
> ActiveSheet.Cells(dRow, dCol + 1).Value =
> ActiveSheet.Cells(3, rCell.Column).Value
> Next nCnt
> End If
> Next rCell
> MsgBox "Finished"
> End Sub
>
> *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*
> -
>
>
> On Thursday, June 1, 2017 1:42 PM, Secret Shot 
> wrote:
>
>
> 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 hope now i can get required help.
>
> Thanks in advance.
>
>
> On Thu, Jun 1, 2017 at 8:17 PM, Paul Schreiner 
> wrote:
>
> 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 data to determine how it is to be interpreted.
>
> Without knowing the characteristics of the "raw data", it would be
> impossible to reverse-engineer the file.
>
> It's like saying:  "I'm standing outside of my home, tell me how I got
> here"
> The answer requires first knowing where you started and what options are
> available to get from the start to the end.
> Lots of options are AVAILABLE, but if your starting point is two streets
> away, the use of an airplane is unlikely. Teleportation is WAY cooler, and
> should remain in consideration for that reason! :)
>
> More details are required.
>
> *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*--
> ---
>
>
> On Thursday, June 1, 2017 10:20 AM, 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 help, i have attached of the sample of what i am
> talking about. if anyone can me in writing a macro which can create raw
> data basis on the count in front of number and considering their header.
>
> Please help
>
> --
> Pankaj Pandey
> Bhopal
> --
> 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+unsubscribe@ googlegroups.com
>

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 this to rebuild the detailed list:

Sub Restore_Data()
    Dim nRows, rCell As Range, nCol, nRow, dRow, dCol
    Dim nCnt
    ActiveSheet.Range("Data").ClearContents
    dCol = ActiveSheet.Range("Data").Column
    dRow = ActiveSheet.Range("Data").Row - 1
    For Each rCell In ActiveSheet.Range("Result").Cells
    If (Int(rCell.Value) > 0) Then
    For nCnt = 1 To rCell.Value
    dRow = dRow + 1
    ActiveSheet.Cells(dRow, dCol).Value = 
ActiveSheet.Cells(rCell.Row, "A").Value
    ActiveSheet.Cells(dRow, dCol + 1).Value = ActiveSheet.Cells(3, 
rCell.Column).Value
    Next nCnt
    End If
    Next rCell
    MsgBox "Finished"
End Sub
 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
- 

On Thursday, June 1, 2017 1:42 PM, Secret Shot  wrote:
 

 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 hope now i can get required help. 

Thanks in advance.   

On Thu, Jun 1, 2017 at 8:17 PM, Paul Schreiner  wrote:

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 data to determine how it is to be interpreted.
Without knowing the characteristics of the "raw data", it would be impossible 
to reverse-engineer the file.
It's like saying:  "I'm standing outside of my home, tell me how I got here"The 
answer requires first knowing where you started and what options are available 
to get from the start to the end.Lots of options are AVAILABLE, but if your 
starting point is two streets away, the use of an airplane is unlikely. 
Teleportation is WAY cooler, and should remain in consideration for that 
reason! :)
More details are required. 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
-- --- 

On Thursday, June 1, 2017 10:20 AM, 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 help, i have attached of the sample of what i am 
talking about. if anyone can me in writing a macro which can create raw data 
basis on the count in front of number and considering their header.   

Please help
-- 
Pankaj Pandey
Bhopal-- 
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+unsubscribe@ googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://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.

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 hope now i can get required help.

Thanks in advance.


On Thu, Jun 1, 2017 at 8:17 PM, Paul Schreiner 
wrote:

> 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 data to determine how it is to be interpreted.
>
> Without knowing the characteristics of the "raw data", it would be
> impossible to reverse-engineer the file.
>
> It's like saying:  "I'm standing outside of my home, tell me how I got
> here"
> The answer requires first knowing where you started and what options are
> available to get from the start to the end.
> Lots of options are AVAILABLE, but if your starting point is two streets
> away, the use of an airplane is unlikely. Teleportation is WAY cooler, and
> should remain in consideration for that reason! :)
>
> More details are required.
>
> *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*
> -
>
>
> On Thursday, June 1, 2017 10:20 AM, 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 help, i have attached of the sample of what i am
> talking about. if anyone can me in writing a macro which can create raw
> data basis on the count in front of number and considering their header.
>
> Please help
>
> --
> Pankaj Pandey
> Bhopal
> --
> 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 https://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 https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Pankaj Pandey
Bhopal

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

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 "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 data to determine how it is to
 be interpreted.
 Without
 knowing the characteristics of the "raw data", it
 would be impossible to reverse-engineer the file.
 It's
 like saying:  "I'm standing outside of my home,
 tell me how I got here"The
 answer requires first knowing where you started and what
 options are available to get from the start to the
 end.Lots
 of options are AVAILABLE, but if your starting point is two
 streets away, the use of an airplane is unlikely.
 Teleportation is WAY cooler, and should remain in
 consideration for that reason! :)
 More
 details are required. 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
 -
 
 
 
On Thursday, June 1,
 2017 10:20 AM, 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 help, i have attached of the sample of
 what i am talking about. if anyone can me in writing a macro
 which can create raw data basis on the count in front of
 number and considering their header.   
 
 Please help
 -- 
 Pankaj Pandey
 Bhopal
 
 
 
 
 -- 
 
 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 https://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 https://groups.google.com/group/excel-macros.
 
 For more options, visit https://groups.google.com/d/optout.
 oi legi electorale si a legii rurale paralel cu continuarea programului de 
rme. Pana la sfarsitul anului 1864 era adoptata  intre altele  legea 
introducerii dmului de unitati si masuri metrice  septembrie   era infiintata 
scoala de uri si sosele  in fine  erau decretate legea instructiunii  25 
noiem-H decembrie   legea organizarii

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 data to determine how it is to be interpreted.
Without knowing the characteristics of the "raw data", it would be impossible 
to reverse-engineer the file.
It's like saying:  "I'm standing outside of my home, tell me how I got here"The 
answer requires first knowing where you started and what options are available 
to get from the start to the end.Lots of options are AVAILABLE, but if your 
starting point is two streets away, the use of an airplane is unlikely. 
Teleportation is WAY cooler, and should remain in consideration for that 
reason! :)
More details are required. 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
- 

On Thursday, June 1, 2017 10:20 AM, 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 help, i have attached of the sample of what i am 
talking about. if anyone can me in writing a macro which can create raw data 
basis on the count in front of number and considering their header.   

Please help
-- 
Pankaj Pandey
Bhopal-- 
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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$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 a macro which can create raw
data basis on the count in front of number and considering their header.

Please help

-- 
Pankaj Pandey
Bhopal

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


temp.xlsx
Description: MS-Excel 2007 spreadsheet