Yesterday we created the excel file using Excel Object and entered some data into it, and saved it. You can find this post here How to Create a Blank Excel File and Enter some data then Save it
Let’s Now Read that data which we created yesterday
How to Read Values from a given excel Sheet
'Create Excel Object
Set Objexcel = CreateObject("Excel.Application")
'Make it Visible
'Open the Excel File
Set Objworkbook = Objexcel.Workbooks.Open("C:\SMCExcelExample.xls")
'Get the Control on Specific Sheet
Set Objworksheet1 = Objexcel.Worksheets.Item("Sheet1")
' Display the Values
'Quit from Excel Application
Like this, you can read values from specific Cells. Now using UsedRange method you can get the range of the excel and then use For..Loop you can read whole content altogether
Now, you tell me how to read and copy values from one sheet to another sheet in the same workbook.
Share your thoughts in comments below, if correct I will publish it else tomorrow I will provide the solution.