Macro - How to use a Macro to capture daily statistics

Hi I have created a Macro:

Example

Column A Column B
Fruits 20
Veg 30
Non Veg 40

I want to capture this everyday using a Macro , I have already setup the macro which copies the data on Column C and do a Paste special and saves the file. But now the task is how will the macro run on the second day, Ideally I need the macro to move to Column D because Column C contains data of the first day. BUt the macro is created based on Column C.

How to we configure a formula which moves to the next cell

Rather than specify which column to paste the data in you can check for the last populated column and then enter the new data in the one next to that.
The link below should help explain how to do all this.
https://www.thespreadsheetguru.com/b...lumn-using-vba

BSB

Sub Macro5()
'
' Macro5 Macro
'

'
Range("A1").Select
ActiveWindow.SmallScroll Down:=-9
Range("A1").Select
Selection.End(xlToRight).Select

End Sub


What code should I enter to make the macro move to the next cell right side which is empty, so my rest of the formulas can work.

Probably easier to provide a solution if you attach the workbook so we can see what you really need.

BSB

06.04.2017
Work 05:00 05:00:00
Cooking 04:00 04:00:00
Playing 03:00 03:00:00
Studying 02:00 02:00:00

Based on the above Macro I provided data is populate on Column C, But now tomorrow I come and try to take the stats for 07/04/2017, then the 06/04/2017 data will be overridden, I need the macro work on the next column which is D.

Sub Macro5()
'
' Macro5 Macro
'

'
Range("A1").Select
ActiveWindow.SmallScroll Down:=-9
Range("A1").Select
Selection.End(xlToRight).Select

End Sub

The code you've provided simply moves the selected cell from A1 to the last populated cell in row 1. It doesn't actually do any of what you're describing.

If you can attach the actual file, it will be clear to us what the process actually is. i.e where the data is before and where it needs to go.

BSB

the code I provide just moves to last Populated cell in the row. I need code to move it to the next cell. Excel Iam unable to attached.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on REPLY then GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I Have attached the spreadsheet I need to capture the stats everyday, so the formula should move from C to D E F G H etc

Hopefully the script below will help.

Please Login or Register  to view this content.

See attached.

BSB

Unable to download attachment, can you resend

:-((( is there a way to download from this website ?

Click on the filename of the attachment in post #12 or click where it says "Download" to the right of the filename.

Navigate to the folder where your browser saves downloaded files and open it from there.

BSB

Thanks, it worked as I expected. Super

Originally Posted by BadlySpelledBuoy

Attached again as requested.

BSB

Originally Posted by BadlySpelledBuoy

Hopefully the script below will help.

Please Login or Register  to view this content.

See attached.

BSB

Thanks its worked as I expected

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.