LinkBack URL
About LinkBacks
Problem: I have a HK1114.text file, I need to get the total value of 24 hours (data medium red frame) per day in each cell
Please see the attached file
Thank you
Sorry I do not know much about English.Book1.xls
Problem: I have a HK1114.text file, I need to get the total value of 24 hours (data medium red frame) per day in each cell
Please see the attached file
Thank you
Sorry I do not know much about English.Book1.xls
Import the text file:
On a new sheet:
1. Data > From Text (delimited)
2. next
3. next
4. finish
5. select A1 for start cell
6. select entire column A
7. data, text to columns
8. check semi-colon delimiter
9. finish
10. delete first six and last six rows of data
11. The data you want to sum is in column J and the days are in column D, so use:
($S1 has day of the month in the sample workbook)
Please Login or Register to view this content.
Ben Van Johnson
The standard
Thank you very much
But if I use vba code must write how?
The standardOriginally Posted by protonLeah
Import the text file:
On a new sheet:
1. Data > From Text (delimited)
2. next
3. next
4. finish
5. select A1 for start cell
6. select entire column A
7. data, text to columns
8. check semi-colon delimiter
9. finish
10. delete first six and last six rows of data
11. The data you want to sum is in column J and the days are in column D, so use:
($S1 has day of the month in the sample workbook)Please Login or Register to view this content.
Thank you very much
But if I use vba code must write how?
Here's a macro to import the text file, distribute text to columns and fill the summary table.
You will have to modify the line in red for your path, etc.
The macro is attached to a button and will import to the same sheet.
Please Login or Register to view this content.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks