excelvbacopypastecells
In main sheet there is 800 names(A1:A800). Each cell should go to different sheet with an order. First cell to first sheet etc
I have nearly 800 cells(A1:A800) in my main sheet. Each cell should copy to different sheet with an order. First cell in main sheet('main'!A1) copy to first sheet('1'!A1) , second cell('main'!A2) copy to second sheet('2'!A1) etc.I created 800 sheets already. I don't know VBA very well. I couldn't find any code that fits my problem. Thanks for help!
Solution
If I am seeing what you are trying to do, it shouldn't be too hard.
You could hardcode a for loop to 800.
for i = 2 to 800
Range("A"&i).Copy Destination:=Sheets(i).Range("A" & i)
next
- Copy paste cells from button row
- Excel: Dynamic stacking or arrays n-number of times
- Get the value of the second non-empty cell in a row
- SUMIF with UNIQUE criteria for multiple columns, adding all values with same name
- How can I use filter function in Excel to filter based on selections including those that are "ALL"?
- Convert Excel formula to Power Query (if countifs)
- Openpyxl - I can't set cell format and sum values correctly in time format (h:mm)
- Find/Replace Row number within Formula
- Extracting & summing data from a single cell in excel
- How to map table references in a JSON file to corresponding values in an Excel file using Python?
- Convert number in excel to M or B
- How to have instructional text in Excel?
- How to copy a range to several worksheets by using a list of worksheets to copy to
- How to count resolved comments only via VBA in Excel
- Excel VBA - how do I get the RowSource of a ComboBox to change depending on the value of another Combobox?
- check if a file is open in Python
- How to copy only plain text of cells in Excel?
- VBA - Capitalise range of cells before the last period
- Getting the next value of the same user if the type is "no type"
- Reporting Services export to Excel causes 'Repair' and removes styles
- Excel VBA macro to group rows based on condition
- Convert table to reflect column names as row values
- Combined two arrays and the result returned has an empty key and value
- VBA: ListBox Change event firing twice
- Excel VBA offset without activating the cell
- Creating a dymamic array which sums different columns depending on row
- Excel's fullname property with OneDrive
- Why I can't compare two dates using comparison symbols in Excel?
- How to I call/trigger a ribbon control sub from a regular sub?
- If certain columns are empty within a range, delete entire row (Excel macro)