Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to capture start and ending Ref. Nos. in an array
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2011, 12:45 AM
Catalin.B Catalin.B is offline How to capture start and ending Ref. Nos. in an array Windows Vista How to capture start and ending Ref. Nos. in an array Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
well, this is an option you can use, in the sample attached
(note that the formula in the yellow cell refers to the last cell value, it is different from the cells above..)
Attached Files
File Type: xlsx Query101.xlsx (11.3 KB, 12 views)
Reply With Quote
  #2  
Old 09-07-2011, 04:32 AM
KIM SOLIS KIM SOLIS is offline How to capture start and ending Ref. Nos. in an array Windows XP How to capture start and ending Ref. Nos. in an array Office 97
Novice
How to capture start and ending Ref. Nos. in an array 		 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default
Hi Catalin,

Bullseye! You got it right and fast! You're an expert extraordinaire . Many thanks to you.

Best regards,

Kim

PS/ Will appreciate if you can set it up in my sheet 2, please?
Reply With Quote
  #3  
Old 09-07-2011, 06:07 AM
Catalin.B Catalin.B is offline How to capture start and ending Ref. Nos. in an array Windows Vista How to capture start and ending Ref. Nos. in an array Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
I do not consider myself an expert... there are more experienced people on this forum than me... but i do know some magic tricks
You will be amazed how simple it is to do what you want:
just select the table you want to move in sheet2, than cut and paste in sheet 2...
and thats all!! excel does the rest...
Attached Files
File Type: xlsx Query101.xlsx (11.4 KB, 12 views)
Reply With Quote
  #4  
Old 09-07-2011, 07:36 AM
KIM SOLIS KIM SOLIS is offline How to capture start and ending Ref. Nos. in an array Windows XP How to capture start and ending Ref. Nos. in an array Office 97
Novice
How to capture start and ending Ref. Nos. in an array 		 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default
Hi again Catalin.

Got it now . You make it simple for novices like me - a real help indeed.
And thanks for sharing how it is done. You're much kinder than you're helpful.

Best regards,

Kim

PS/ Been to many Excel Forums. This by far gives the clearest solution and advice. Glad to hitch here finally. Others talk Greek, if you get the drift. . Good day. No offense meant, folks.
Reply With Quote
  #5  
Old 09-07-2011, 07:43 AM
Catalin.B Catalin.B is offline How to capture start and ending Ref. Nos. in an array Windows Vista How to capture start and ending Ref. Nos. in an array Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
you're welcome...
glad it worked
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM
outlook programmatically read an attachment into byte array chriskaza81 Outlook 0 11-19-2010 01:03 AM
capture sender's contact to 'Contacts Folder' gianimpact Outlook 0 02-09-2010 07:56 AM
How to capture start and ending Ref. Nos. in an array Array into ComboBox + Macro-Text into ActiveDocument Vivi Word VBA 1 01-27-2010 07:03 AM
How to capture start and ending Ref. Nos. in an array Add text to the beginning/ending of each line in word ballmoney Word 1 01-17-2010 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft