Exporting data from one Excel spreadsheet to another spreadsheet is always a problem if you want to have the same content in the second too. We sill see how to solve this problem with an example.
I have a query. Whenever I export a file from the internet the data gets saved into a new Excel file instead of the Excel sheet I am working in. As a result I have to copy the data from that file to the Excel file I am working in. This is very time consuming. Is there a shorter method to directly export the data into the working Excel file?
Another example problem: I have recorded a macro for a particular worksheet. That macro does two things:
Now I want to run this macro in all worksheets except the first worksheet. What is the code to do that?
To solve the firs problem:
To solve the second issue:
Dim j As Integer, k As Integer
j = Worksheets.Count
For k = 1 To j
If Sheets(k).Name = "Sheet1" Then GoTo nnext
NAME OF THE MACRO
Photo: © Everypixel