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

$$Excel-Macros$$ Oracle Apps Technical - Specialist AP/AR Harrisburg, PA

2017-06-01 Thread Adam Smith
Hello Partner, Hope you’re doing great. Please let me know if you have any suitable profile for the below position. Position: *Oracle Apps Technical - Specialist AP/AR* Location: Bay Area, CA Duration: Long term contract *Rate: $60/hr on C2C MAX* *Required Skills:* Looking for 8-10 years of Ora

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

$$Excel-Macros$$ Oracle Apps Technical - Specialist AP/AR Harrisburg, PA

2017-06-01 Thread Adam Smith
Hello Partner, Hope you’re doing great. Please let me know if you have any suitable profile for the below position. Position: *Oracle Apps Technical - Specialist AP/AR* Location: Harrisburg, PA *(LOCALS ONLY)* Duration: Long term contract *Rate: $60/hr on C2C MAX* *IN-PERSON INTERVIEW* *Required

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
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$$ Excel Add-in (that enables Auto-complete)

2017-06-01 Thread Carlisle Flores-Garay
Hi, I see your code and this spread sheet is great. I was wondering if there was a way to stop the code from running when you select the whole row to copy and paste it in a different line. On Thursday, April 25, 2013 at 3:24:17 AM UTC-4, Abhishek Jain wrote: > > Please see the attached. > > F

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

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

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