Excel - Converting data for SAP upload
Closed
dd1975
Posts
1
Registration date
Tuesday March 2, 2010
Status
Member
Last seen
March 2, 2010
-
Mar 2, 2010 at 07:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 2, 2010 at 07:34 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 2, 2010 at 07:34 AM
Related:
- Excel - Converting data for SAP upload
- Transfer data from one excel worksheet to another automatically - Guide
- Convert number to words in excel - Guide
- Tmobile data check - Guide
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 2, 2010 at 07:34 AM
Mar 2, 2010 at 07:34 AM
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
