Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Excel format change
- Thread starter achiacu
- Start date
Without knowing the layout of the spreadsheets (original & modified), it's hard for anyone to help you out. For example, if your "Calendar-style" spreadsheet is set up with each month being a separate tab, being 7 columns (week starting on Sunday and ending on Saturday), and 5 rows of data per week; and you want to convert this into a speadsheet that has all the data on one spreadsheet with each day being on an individual row we can help you.
Odds are that you'll need to write a macro to convert the data from the existing format to a format that can be uploaded, but we need A LOT of information if you want any help here.
Odds are that you'll need to write a macro to convert the data from the existing format to a format that can be uploaded, but we need A LOT of information if you want any help here.
- Status