Master workbook

[vletm]

Aman Semwal
... hmm?
Did You watch my previous snapshot?
It is from SHEET3 ... and
... where would You sent that data?

... or if You're writing about that other sheet
... which You wrote many times, which didn't work ...
Could have [ Copy ]-button.

After that, anyone could paste sheet's usedrange to 'anywhere'.
... but do that sheet already give information,
which someone misses?

 

[Aman Semwal]

Aman Semwal
... hmm?
Did You watch my previous snapshot?
It is from SHEET3 ... and
... where would You sent that data?

... or if You're writing about that other sheet
... which You wrote many times, which didn't work ...
Could have [ Copy ]-button.
View attachment 49685
After that, anyone could paste sheet's usedrange to 'anywhere'.
... but do that sheet already give information,
which someone misses?

For now I am working on this file and need this table of sheet 3 to be copied and let this get paste in new workbook....
This is needed coz I want to filter this and make some manual change if somebody is on leave or for some reason...

 

[vletm]

Did You check my newest upload - YES or NO?
... did I read correct ?
You would like to MANUALLY EDIT those values
(which You have told that NOT CORRECT ) ...
Why there is that 'SHEET1' from selected rows moves to ... correct sheet?
WHY?

 

[Aman Semwal]

Did You check my newest upload - YES or NO?
... did I read correct ?
You would like to MANUALLY EDIT those values
(which You have told that NOT CORRECT ) ...
Why there is that 'SHEET1' from selected rows moves to ... correct sheet?
WHY?

I have checked it, All are fine to go.... the only change i need is that still not able to copy the table... as The cursor only stay on C5 Cell and it doesnt move....

 

[vletm]

If You won't read my replies or
not watch snapshots
This is a challenge!

As I wrote few replies ago!
>> PRESS THAT [ COPY ]-button
and
GO to another
... where ever and PASTE !

 

[Aman Semwal]

I tried with that button but it's not working

 

[vletm]

I tried myself and it work!
1) Open that 'media' where You want to paste.
2) Go back to that 'sheet' where is [ Copy ]-button?
3) Press it
4) Go to that 'media' where You want to paste
5) Do Paste (the most best is PasteSpecial ... there are many possibilities!)

Step-by-Step-Instructions are made to FOLLOW!

 

[vletm]

Below few my possibilities to paste as ...

and
one real sample which has pasted => MF.png

 

[Aman Semwal]

I opened a new sheet and then I pressed the copy button and went back to the new sheet and try to paste the sheet by clicking Ctrl + V but the paste button is freezed which mean its not copying the table....

 

[Aman Semwal]

Also Please provide the background Vba code Password

 

[vletm]

Paste by clicking right button of mouse and select there PasteSpecial ...
As I wrote, I tested it and it works!
And follow instructions as I wrote.
If You cannot read --- how would You find something from any code?

 

[Aman Semwal]

I tried still unable to paste it as per instruction

 

[vletm]

hmm ...
Of course many things would be possible ...
as I have noticed ... skipping ... skipping ...
here it works
... so so so ...
Test this,
there is a new button [ PDF ] ...
Here, it makes PDF-file (at least here).

 

[Aman Semwal]

hmm ...
Of course many things would be possible ...
as I have noticed ... skipping ... skipping ...
here it works
... so so so ...
Test this,
there is a new button [ PDF ] ...
Here, it makes PDF-file (at least here).

I think my system is unable to generate the pdf or copy the table..... Therefore its not working in this...

 

[Aman Semwal]

Also my system do not generate the time as per your snapshot....
Please find the snapshot of mine...


Therefor please unfreeze all cell in sheet3 where I could copy it

 

[vletm]

Reply #49 - You still cannot read nor see!
Vital information: Sheet3 do not have any freezes!

You wrote: 'I think my system is unable to generate the pdf or copy the table..... Therefore its not working in this...'
Wow! I have never read that ---
What kind of system do You use?
It's challenge, if cannot do some basic things!
You would try to think other way and
maybe after that Your system would start working.

 

[Aman Semwal]

Then why C5 works and if i keep the cursor anywhere else why does it goes back to C5.... ????
My question is that from sheet 3 I would select the range manually and copy and then paste where i wish

 

[vletm]

ouch! ouch!
You didn't check that snapshot ... or
if You checked then You didn't watch it at all ...
That snapshot is from Sheet3 ... and
that is different sheet than Your mystery 'thinking'.
You haven't read ... no way!

One more version ...
Someway try to select range and press [ Values] ( this has worked ... )
Then, if miracle happens,
there would be
PDF, in same folder as this file
and
A 'New' Excel-file would be open, which has that 'cannot-copy-information!'

 

[Aman Semwal]

ouch! ouch!
You didn't check that snapshot ... or
if You checked then You didn't watch it at all ...
That snapshot is from Sheet3 ... and
that is different sheet than Your mystery 'thinking'.
You haven't read ... no way!

One more version ...
Someway try to select range and press [ Values] ( this has worked ... )
Then, if miracle happens,
there would be
PDF, in same folder as this file
and
A 'New' Excel-file would be open, which has that 'cannot-copy-information!'

Ya now its working fine...

 

[Aman Semwal]

Please send me the vba password for further....