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

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

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

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?

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

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?