hello!
I have a workbook with soon about 50 sheets. Every sheet has a list of 7 digits numbers. The numbers start with 117,107,105,104,103,102,101,106. I want one sheet for every one of these "Standard numbers" which contains every number in the workbook starting with one of these numbers.
EX. Sheet1 for numbers starting with 117, this needs to scan every sheet and find all numbers starting with 117 and put them in nice list in Sheet1.
thanks for any reply!
regards Ossa
Please attach a sample workbook with expected output for getting better understanding of your requirement
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for reply!
In sheet Rogaland 105, I want all numbers from all sheets between start:end to be listed, also with content form column C,D,EHour statistscs 04.06.2013 1302.xlsx
Can you please show the expected output for better understanding
From what i understand the problem
my example attached
run macro SheetNames and C4 to I9 gets populated
Y variable not required...i was just debugging
Last edited by humdingaling; 06-07-2013 at 04:04 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Now I filled some sample information in Rogaland- 105 sheet. This information will come from every other sheet between start:end.Hour statistscs 04.06.2013 1302.xlsx
Last edited by ossa; 06-07-2013 at 08:47 AM.
I looked at your Macro. I think it would work if it took the whole range c22:c2000, d22:d2000, e22:2000etc. and also the project number from column B. In fact it is not vital that it sorts out numbers starting with 105,107. Just that all numbers with seven digits, from my workbook would end up in one sheet, in one list, with its information from all columns. Thanks!
does anyone has any ideas on this one?
I found this link, but dont know how to use it properly: http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
Thanks
Last edited by ossa; 06-10-2013 at 01:52 AM.
sorry
thought you were doing the code yourself so didnt add to solution
so you want to copy range C22:E2000 into summary sheet?
ok try this code instead
had to make data go vertical instead because it just doesnt read well going horizontal
Please Login or Register to view this content.
the sheet name is now at top across first row
Last edited by humdingaling; 06-12-2013 at 09:50 AM.
made it 20 instead of 22 to take the header at the same time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks