Hi I have a monitor which records in 10 minute intervals the output from my rooftop solar panels.
I transfer the daily data to an Excel 365 day ‘Master Sheet’.
Unfortunately, the monitor supplies a CSV (read only file) which ONLY
contains two columns with 10 minute intervals and kWh output.
13:00 1.44
13:10 1.896
13:20 1.926
13:30 2.148
13:40 2.106
13:50 2.106
I copy and paste the data into columns ‘B’ and ‘C’ and then add the
relevant date into column ‘A’ 144 times.
I would like to add a macro which takes the date in the LAST DATE CELL, (in
the attached sheet A145) and increment it by one day. I would then like the
macro to paste the same date into the next 144 cells.
I’ve created a macro which does this, but it only works on the specific
cell that was originally selected (A2) rather than carrying on from the new
required cell (A146).
I’m using Excel for Mac 2011.
Any help or suggestions would be much appreciated.
Best regards
Ian
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
24 Hour Data Entry. Needs a Macro....xlsx
Description: MS-Excel 2007 spreadsheet
