using vba excel, search and copy the entire row to another sheet one after other
copy a certain range of one sheet to a certain specifed cell in other sheet
Are there systems in classical mechanics that are provably non-deterministic? Can Blender render animated gifs? The standard files/tools that report memory seem to have different formats on different Linux distributions. For example, on Arch and Ubuntu.   Arch  $ free               total        used        free      shared  buff/cache   available Mem:        8169312     3870392     2648348       97884     1650572     4110336 Swap:      16777212      389588    16387624   $ head /proc/meminfo  MemTotal:        8169312 kB MemFree:         2625668 kB MemAvailable:    4088520 kB Buffers:          239688 kB Cached:          1224520 kB SwapCached:        17452 kB Active:          4074548 kB Inactive:        1035716 kB Active(anon):    3247948 kB Inactive(anon):   497684 kB  Ubuntu  $ free              total       used       free     shared    buffers     cached Mem:      80642828   69076080   11566748    3063796     150688   58358264 -/+ buffers/cache:   10567128   70075700 Swap:     20971516    5828472   15143044   $ head /proc/meminfo  MemTotal:       80642828 kB MemFree:        11565936 kB Buffers:          150688 kB Cached:         58358264 kB SwapCached:      2173912 kB Active:         27305364 kB Inactive:       40004480 kB Active(anon):    7584320 kB Inactive(anon):  4280400 kB Active(file):   19721044 kB    So, how can I portably (across Linux distros only) and reliably get the amount of memory—excluding swap—that is available for my software to use at a particular time? Presumably that's what's shown as "available" and "MemAvailable" in the output of free and cat /proc/meminfo in Arch but how do I get the same in Ubuntu or another distribution? How can I learn the basics of SharePoint 2013 in a few days? I have very little knowledge of SharePoint, and want to learn about SharePoint 2013.  Most of the resources that I've found are either about what's new in 2013, or they have a bunch of links to SharePoint 2010.  I also don't have the time to read a thousand page book.  A hundred or so would be fine.  Can anyone recommend a resource (site / book / video / tutorial) for a beginner to learn the basics of SharePoint 2013 in a few days?  I've downloaded a Kindle book, "Getting Started With SharePoint 2013."  It's perfect for absolute beginners, who just want to know how to upload &amp; download documents, but I'm looking for more than that. Graphing the amount of time a function takes How could I write my name, for example, to look like the \LaTeX logo? How could I write my name, for example, in a \LaTeX style? It is just interesting, as in Google all other things pop up when I try to search for an answer! How many days a year is a U.S. citizen allowed to stay in Morocco? I arrived in Morocco in October of 2014 and renewed my visa by traveling to Spain by ship for a day and getting my passport stamped again in January of 2015. My question is, am I allowed to leave the country and repeat this process this year by traveling again to another country, other than my own in order to return to Morocco for another 90 days? And if so, how many times a year is this allowed? I have read 180 days on some websites but there is not any clear answers anywhere about this that I can find. How can a company use money from stock investors when they are constantly being bought and sold? I am interested in the mechanisms which a company can use the money that investors give them when they buy a public stock since they are being bought and sold constantly. How can a company spend other people's assets when the shareholders still own their stocks and they still retain a liquid value? To me it seems like stocks are a case of "having your cake and eating it too". PDOException “could not find driver” There are a lot of poorly drawn schematics here. A few times people have actually asked for critiques of their schematics. This question is intended as a single repository on schematic drawing rules and guidelines can point people to. The question is  What are the rules and guidelines for drawing good schematics?     Note: This is about schematics themselves, not about the circuits they represent. Why did the gamma ray burst from GW170817 lag two seconds behind the gravitational wave? , reporting on the announcement of gravitational wave GW170817, explained that for the first time we could identify the precise source of a gravitational wave because we also observed the event in the electromagnetic spectrum. It notes however that the gamma ray burst detected by the FERMI space telescope was observed nearly two seconds later than the gravitational wave.   Did the gamma ray burst actually arrive at Earth two seconds after the gravitational wave, or is this time delay just some kind of observational artefact? If the delay is real, what is its cause? Is the delay due to the gamma ray burst somehow being slowed, or was it 'emitted' at a different time in the merger event? What does a delay even mean when the gravitational wave was detected for over 100 seconds? Is it a delay from peak GW to peak gamma ray? Is there a *simple* example showing that uncorrelated random variables need not be independent? Batch Requests/sec reported by DMV millions of times larger than Activity Monitor I have verified through SQL Server Profiler that my request per-second are around 30 request/s as is corroborated by SSMS Activity Monitor but sys.dm_os_performance_counters is reporting hundreds of millions/s.  Any idea what might be causing this gross discrepancy?  Query:  SELECT     RTrim(LTrim(object_name)) as object_name,     RTrim(LTrim(counter_name)) as counter_name,     cntr_value FROM     sys.dm_os_performance_counters  WHERE      instance_name IN ('', '_Total')     and counter_name IN (         N'Batch Requests/sec'         , N'SQL Compilations/sec'         , N'SQL Re-Compilations/sec'         , N'Transactions/sec')   Results:  object_name counter_name    cntr_value SQLServer:Databases Transactions/sec    191721399 SQLServer:SQL Statistics    Batch Requests/sec  242955426 SQLServer:SQL Statistics    SQL Compilations/sec    42048371 SQLServer:SQL Statistics    SQL Re-Compilations/sec 1200947 Why does Sass change the format of my colors? Why do C# multidimensional arrays not implement IEnumerable? I am a Indian citizen holding a work residence permit from Norway for two years.  I want to make some trips in the rest of the Schengen area. I am planning my first trip to Portugal on 22/08/18 till 26/08/18, a second trip to Italy from 22/11/18 to 27/11/18, and again to Portugal from 06/02/19 to 16/02/19.  I will stay permanently  inside Norway after each trip to other Schengen countries.  How does the 90/180 rule work in this case?  Am I allowed to make all those trips while holding my residence permit in Norway? Can you let me know if I'm exceeding the 90-day limit with these trips? Zero probability and impossibility I read a comment under :     There are plenty of events that can occur that have zero probability.   This reminds me that I have seen similar saying before elsewhere, and have never been able to make sense out of it. So I was wondering    if zero probability and impossibility mean the same? if an event with zero probability doesn't mean that the event is impossible to occur, how probability theory represents/describes impossibility?   Thanks and regards! Rotate touchscreen and disable the touchpad on Yoga 2 Pro in rotated mode On my Lenovo Yoga 2 pro I installed Ubuntu 14.04 32bit and kept the installed Windows 8 on another partition.  In Windows, When you turn it into tablet mode, the keyboard and touchpad turns off so you don't accidently click on it at the back of the "tablet".  In ubuntu 14.04 only the keyboard turns off, but the touchpad stays active. Not even the Fn+F6 combination doesn't turn it off.  So far I can only disable it with  synclient TouchpadOff=1   (and re-enable with 0)  I tried xev to get the keycode for Fn+F6 but pressing this combo generates no output. Turning the monitor to the back neither.  How can I disable the touchpad automatically when I rotate or turn the monitor on the back, and re-enable the Fn+F6 Hotkey?      UPDATE: After some weeks sudo apt-get upgrade Fn+F6 is working now, so there is only the question how to rotate the screen and how to disable the touchpad automatically when rotating the screen. When looking at my objects in 3d view I'm seeing a gray cone that seems to be hiding other objects.   Can anyone help me turn this off and explain what it is please.  Screenshots attached. Scale a div to fit in window but preserve aspect ratio