I have a couple hundred worksheets that I need to copy 4 cells of information moved into one list with the Sheet name. They are in a square pattern, plus there is information in the columns and rows after them. Does anyone have a macro that I could use? I don't want to type it by hand and don't have the time to write one. Anyonehave one I could use?
Thank you in advance!
Please attach a file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not).
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Sample Data.xlsx
Here you go, a small example of what I need. The cells I need are highlighted.
Hi ksamarin88
What's the output to look like...straight listing in a "square pattern"?
Location: A
Sample Point: B
Location: C
Sample Point: D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks