Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-30-2011, 10:01 PM
gsrikanth gsrikanth is offline two doubts Windows XP two doubts Office XP
Competent Performer
two doubts
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default two doubts

firstly



1. shortcut key to list box

there is no shortcut key to list box, we will go there using mouse only
list box where we get address of the cell i.e., M13

2. Copies multiple worksheet data in 1 worksheet?

i have 5 row data in first worksheet, in second 5 row data like that there is 500 work sheet, i want to get all data in work sheet. i think it is vba micro
Reply With Quote
  #2  
Old 12-31-2011, 01:10 PM
JBeaucaire JBeaucaire is offline two doubts Windows XP two doubts Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

1) No idea about that.

2) 'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.
Sheets to One Sheet - Part 1
There's a sample file there, too, to make it easy to try it out.
Reply With Quote
  #3  
Old 01-06-2012, 05:55 AM
gsrikanth gsrikanth is offline two doubts Windows XP two doubts Office XP
Competent Performer
two doubts
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by JBeaucaire View Post
1) No idea about that.

2) 'MANY SHEETS TO ONE SHEET
Here's a macro for merging data from multiple sheets into a "consolidation" sheet where the source sheets are the same layout.
Sheets to One Sheet - Part 1
There's a sample file there, too, to make it easy to try it out.
JBeaucaire in every sheet last row is not comming suggust or any other code plz
Reply With Quote
  #4  
Old 01-06-2012, 09:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline two doubts Windows XP two doubts Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Maybe try this addin
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 01-06-2012, 09:57 PM
gsrikanth gsrikanth is offline two doubts Windows XP two doubts Office XP
Competent Performer
two doubts
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Maybe try this addin
i want take lap of now() function, now() function cell is in this format
hh:mm:ss.000
for every action, cut, copy, paste now() function return time, i want to capture time in another cell and save.
i mean to say now() data come adjacent cell make it paste special is well not change

i want to recording?
Reply With Quote
  #6  
Old 01-06-2012, 10:05 PM
gsrikanth gsrikanth is offline two doubts Windows XP two doubts Office XP
Competent Performer
two doubts
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

an another question
i have in excel worksheet naming Page1, Page2, etc.,

in view code vba it is in the order
Page1 then it come
Page10
Page11
after Page 19
there come Page 2
Page 20
Page 21
I have problem with it
while merging worksheet
i want come in order
Page1
Page2
Page3
how to sort this
Reply With Quote
  #7  
Old 01-07-2012, 03:33 PM
JBeaucaire JBeaucaire is offline two doubts Windows XP two doubts Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Change your sheet names to be the same syntax.

Page01
Page02
Page03
Page04
Page05
Page06
Page07
Page08
Page09
Page10
Page11
etc....
Reply With Quote
  #8  
Old 01-08-2012, 09:38 PM
gsrikanth gsrikanth is offline two doubts Windows XP two doubts Office XP
Competent Performer
two doubts
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by JBeaucaire View Post
Change your sheet names to be the same syntax.

Page01
Page02
Page03
Page04
Page05
Page06
Page07
Page08
Page09
Page10
Page11
etc....
its not working, like above said only it comming
general in sql we have convert to number

we have the formula to_number(Page XXX, 99999)
the it will come in order
how in excel worksheets?
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


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