Excel - Converting data for SAP upload
Closed
dd1975
Posts
1
Registration date
Tuesday 2 March 2010
Status
Member
Last seen
2 March 2010
-
2 Mar 2010 à 07:21
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Mar 2010 à 07:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Mar 2010 à 07:34
Related:
- Excel - Converting data for SAP upload
- How to copy data from one excel sheet to another - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Upload files to mediafire - Guide
- Sap crystal reports viewer - Download - Data management
- How to copy data to multiple worksheets in Excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Mar 2010 à 07:34
2 Mar 2010 à 07:34
One way could be
1. Read first line and store products in array.
2. create a do while loop till row does not have a value in column A
3. Create a row counter
4. Store the value of cell A in that row
5. create a for loop with in the do loop to scan each cell. Max would be the max number of column that you could have
6. scan each cell with in your for loop to see if it has a value. if it does just copy by name, product (array index would help as it is column -2) and the price to a new sheet
1. Read first line and store products in array.
2. create a do while loop till row does not have a value in column A
3. Create a row counter
4. Store the value of cell A in that row
5. create a for loop with in the do loop to scan each cell. Max would be the max number of column that you could have
6. scan each cell with in your for loop to see if it has a value. if it does just copy by name, product (array index would help as it is column -2) and the price to a new sheet
