Spreadsheet data
Solved/Closed
ankharm
Posts
6
Registration date
Sunday April 7, 2013
Status
Member
Last seen
April 16, 2013
-
Apr 7, 2013 at 12:28 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 16, 2013 at 10:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Apr 16, 2013 at 10:34 AM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Functions of spreadsheet - Guide
- Pendrive G:\ is not accessible I/O device error' ✓ - Pen Drive, USB & SD Card Forum
- Excel Golf Skins Sheet ✓ - Excel Forum
- We weren't able to confirm your identity from the video you submitted. you can submit a new video and we'll review it again. learn more. - Instagram Forum
- Is not accessible incorrect function - Pen Drive, USB & SD Card Forum
9 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Apr 8, 2013 at 10:45 AM
Apr 8, 2013 at 10:45 AM
Hi Ankharm,
Let me see if I understand you the right way.
Situation 1:
You want 1 big sheet where a column is used to input operator name. Copy rows of data to the correct sheet (operator name = sheet name).
Situation 2:
Each operator uses his own sheet (operator name = sheet name). Copy rows of data from each sheet and paste it to a single (big) sheet.
Both situations can be realized. So pick one.
Then provide some sample data containing:
2 or 3 "Operator" sheets with some data.
The "big" sheet with some data.
Use a filesharing site (www.speedyshare.com) to upload your file and post back the download link.
Pasting to the next empty cell is mostly done in this way:
Range("A"&rows.count).end(xlup).offset(1,0)
Best regards,
Trowa
Let me see if I understand you the right way.
Situation 1:
You want 1 big sheet where a column is used to input operator name. Copy rows of data to the correct sheet (operator name = sheet name).
Situation 2:
Each operator uses his own sheet (operator name = sheet name). Copy rows of data from each sheet and paste it to a single (big) sheet.
Both situations can be realized. So pick one.
Then provide some sample data containing:
2 or 3 "Operator" sheets with some data.
The "big" sheet with some data.
Use a filesharing site (www.speedyshare.com) to upload your file and post back the download link.
Pasting to the next empty cell is mostly done in this way:
Range("A"&rows.count).end(xlup).offset(1,0)
Best regards,
Trowa