Welcome, Guest
You have to register before you can post on our site.

Email:
  

Password
  





Forum Statistics
» Members: 617
» Latest member: PRAVEEN21SINGH
» Forum threads: 760
» Forum posts: 1,871

Full Statistics

Latest Threads
VBA check if
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
12-Jan-2021, 08:45 PM
» Replies: 1
» Views: 1,023
Dependent Drop Down
Forum: Ask Excel Question
Last Post: Anil Kumar Pal
23-Nov-2020, 10:05 AM
» Replies: 1
» Views: 730
for and next
Forum: Ask VBA Question
Last Post: Abhay
08-Sep-2020, 03:26 PM
» Replies: 0
» Views: 806
PAN NO. FORMULA
Forum: Ask Excel Question
Last Post: dsharma789@rediffmail.com
06-Jul-2020, 11:51 AM
» Replies: 0
» Views: 835
Getting error while tryin...
Forum: Ask VBA Question
Last Post: Rinku Sharma
25-Jun-2020, 09:01 PM
» Replies: 0
» Views: 673
Hyperlink Pivot table dat...
Forum: Ask Excel Question
Last Post: sanj_edu
14-Jun-2020, 06:37 PM
» Replies: 0
» Views: 667
Calculate idle time no mo...
Forum: Ask VBA Question
Last Post: Inderjeet Pal
28-Apr-2020, 11:59 AM
» Replies: 0
» Views: 769
Making Pivot table
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
17-Feb-2020, 12:39 PM
» Replies: 1
» Views: 1,095
Need help on code
Forum: Ask VBA Question
Last Post: Inderjeet Pal
15-Feb-2020, 04:23 PM
» Replies: 0
» Views: 824
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 1,033
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 1,784
Array
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 12:16 PM
» Replies: 4
» Views: 1,693
find unique values as hig...
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 10:07 PM
» Replies: 4
» Views: 2,544
add numbers in a cell
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 08:36 PM
» Replies: 0
» Views: 744
Copy value from cell (A1)...
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
26-Dec-2019, 07:34 PM
» Replies: 1
» Views: 1,064

 
  VBA check if
Posted by: slydem - 26-Dec-2020, 08:35 PM - Forum: Ask VBA Question - Replies (1)

Hi all !

I have a question. My excel file have many forms and vba process. i'm looking to add something, but it's out of my competence. someone can help me with this ?

I would like to add a function (click button)Inside a userform. this function must check if:

sheets "feuil1" "b:b"  "C:C" = "feuil2" "b:b"  "C:C", and get error only if C is not = c

exemple:

Feuil1:                                         feuil 2

row B:       row C:                          row B:       row C:

700             4                               700              5
701             5                               704              1
702             2                               705              9
703             6                               703             6
704            1                                701             5
705             9                               702             4



MSGBOX: 700 and 702 not balance.

I dont konw if this is clear ?


  Dependent Drop Down
Posted by: Anil Kumar Pal - 20-Nov-2020, 05:25 PM - Forum: Ask Excel Question - Replies (1)

Dear All,

Hope you are doing well.

I need one help in attached sheet as i want to make dependent drown down on each next column. Next column should get filter or show only related items of selected previous column item.

Please help me out.

Thanks in advance.



Attached Files
.xlsx   Dependent Drop Down.xlsx (Size: 10.82 KB / Downloads: 5)

  for and next
Posted by: Abhay - 08-Sep-2020, 03:26 PM - Forum: Ask VBA Question - No Replies

Hello there,

Greetings!



May I request you to help me  with......



I need to create FOR AND NEXT LOOP IN EXCEL VBA. WHERE I WANT LAST VALUE OF i TO BE PICKED UP FROM A CELL OF WORKSHEET. 



For i = 1 to ?



How I can pick the value for ? from a cell of corresponding worksheet. 


Regard,


  PAN NO. FORMULA
Posted by: dsharma789@rediffmail.com - 06-Jul-2020, 11:51 AM - Forum: Ask Excel Question - No Replies

FORMULA FOR SELECT HUF AND INDIVIDUALS PAN NO. FROM A COMMON LIST


  Getting error while trying to pull data
Posted by: Rinku Sharma - 25-Jun-2020, 09:01 PM - Forum: Ask VBA Question - No Replies

Hello,

I am trying to fetch data for multiple clients. using a query. Since, the list of clients is huge. I am trying to use VBA to pull the data but I am getting this error. This is triggering for recordset which is open. Have added a sample file. 

Can anyone please help. 

[img]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAWYAAADPCAYAAADGQnuEAAAYUElEQVR4Ae2dvW4budeHdU8BXPhSXKlyveXbpUjh1jcQIGUAYbsg7SLYD+xis8Z2/2Kr3IHvgC8Oh4dzSJGSrNFYZzxPAGNmKH6e89PDn2gH2gT+EQEiQASIgKsIbFzNhskQASJABIhAAMyIgAgQASLgLAKA2VlCmA4RIAJEADCjASJABIiAswgAZmcJYTpEgAgQAcCMBogAESACziIAmJ0lhOkQASJABAAzGiACRIAIOItAAvPXcL/ZhM391+b0/nu8DZvNbXj8L4Tw32O41ftm7Vco/HofNjLf28cgU+r9+3q/Cbdx0qaGtJV1zrIOiWOKkxkyhBRfmXP66YS6aLX3MMuc90ahgAgQgStHwID5NtzeHoJK67VrzH6A3Ai2HgxDCAphM02B9djWvHCR295cqvII2PvQ3gYvMhE6IQJEYMERKMB8f3/bcZj3HSd4jZVXkItutLNp7AFQ2s4JxHpuGp+6vH7WelyJABEgAkH/55+CQq4WXP+Fx+ii9XUJmb2XZ6lTf0Qf6gjoN9pfhGRdr9dej0zq+tLvWHb7+Fg87x/FDHPLDrlw0HYd/TWMJyG2vpjxcR7juGWdUWBVeTGPXl+nzKlVZxyVOyJABJYZgcIxC4SKj/oC03iOa8Fi7wcw7J3jpjPVsVzamCOECOnkcitIDWE8UH9vY7Dz2U+CnI/rPIq12X66c7BOvDeOLbf3di5SbkCum5WtEu9N+6Nz6sV+r1MKiAARWFgE9sAcfymWfqk2gswAwwJt76hAV2/rq/u1TtxsAMlJKzxjD41+23OR2tVYOgW9Sl9xPQKyDmhbc9jrtxpHwJlhq/1WdXQOdV9xPG2TzsLrvo7NKb5exjQPxw0RIAKLjsA+mOPRxG14/KpAk/VZ4Jj7LhxMHWneqDeCdojf8JcfyVUfrF/1XcytlYsE5GI99Zoac9jr14xbzM8C39QpplKXD243HrF0+zoyp6JdMRgPRIAILDwCDTCPDm50sRYs9n4AzFhPo2HrSJk810cZ+25vPHY4VL/Vt3GfOgVzVeiX86z7GRqMczDwjEsQh5zGEbesf6oXAanjt/ssNzbdqI71NS5gnJPtvxf7sR13RIAILDMCbTBH12zBaYFg72XR8jyenw6/aKvrKIy0noJs3ASGYwEzZgReo/6ekzW/PMu/5auSUcBTXzNzLI4lzBxs+b39y5QBisPfUt+H+3xEYvrUYeK1jFEGfHyt05cdO59J1/2X/faWX0yFByJABNxHIIHZ/TyZIBEgAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNREAzKtJNQslAkRgKREAzEvJFPMkAkRgNRHYPD8/B36IARpAA2jAjwYAMxsTGzMaQAPONACYnSUE1+LHtZALcnEtDQBmwIxbQgNowJkGALOzhFxrh2Zc3CEa8KMBwAyYcUtoAA040wBgdpYQXIsf10IuyMW1NACYATNuCQ2gAWcaAMzOEnKtHZpxcYdowI8GADNgxi2hATTgTAOA2VlCcC1+XAu5IBfX0gBgBsy4JTSABpxpADA7S8i1dmjGxR2iAT8aAMyAGbeEBtCAMw0AZmcJwbX4cS3kglxcSwOAGTDjltAAGnCmAcDsLCHX2qEZF3eIBvxoADCfA+anh3Cz2YbdOW1f0ua1xnnJnKiLu0QDs2ugCeabzSZs8s9NeHi64E4isLl5CE+SXHu/pGQX896FbY7VJmy2u5i0p4cbE8MUz/iard+G+267CRuJUTHOBXOwpFgz19khgFP2995qg1nBqfC8pDt8E7DZha3GaLcN250m9ik83LQ3MoHtzcNTkKvWj/BOINc3R6y33abNy4wDoAAUGliNBo6D+VkcXnJ2NVT1OV0fxOkl96jwUeAMVwHXWOdGARTbb8M2vbbdjfVyP1InO9M2/KIDr+sUc9uGXf2cNx+dV7nWYU1tZ1uuTeBsYmXfRHHu0kf1eppL/PTw/BwE1ALv5ieJ2Edn3XYs7lfz5t3XnxoErkuPzXEw77bDx2oFmDpF+xyhMTrBZ9umBoWFkd5b6EjbTQJQ7ucw0IYkdOrUc6ufIyzHuWcXu1fvkNh1I2kDXN3yPrjHOWco27ja2NkY2XLuATEaeHMaaIM5u8501qmJFzj0wNwqTy5QXfSeG9T+9CrjtO6lzM4p3lcQ7NWx/dX9957lE0LdTmNw8CqgrVxtnJfOdQRxuZko2NW1p6uN6cFxD20avLZ098T816fhNpgVCAVUKmhaqNUQq58tVOxreq9X26e9t6/bvux9r05dfsrz2WB+Ls6Q5Q01umURVwXmei66nl65vs71zTkk4Ls++B7K+WEwCwDi0UJyfAIMPW9WNywQr0FSP1uQ2D60nl6lXvNegDYeN7QX1Klj+6v7j/Mq2xVHGbpB2flX908PW/NXK9KXccwytomXglrPzfNYVZ9FDPS12JfpW8u5Amk08OY0cBzMCuAEnAiTdKxQ/vIu/QmciKSGYSUccZFyvNFsb9vW9/Y4owXNCC9zHHDqplG0M5tQa4xqLcPGNY6p0H1+Ho4n4vFN0WbYCIbjHT3iqNyCXbe2jXMEzO1NuYqfxozrmwPWWvLfBPNaFs86ARoaQAMeNQCYcVW4KjSABpxpADA7S4jH3Zs54SrRwOtqADADZtwSGkADzjQAmJ0lBGfyus6EeBNvjxoAzIAZt4QG0IAzDQBmZwnxuHszJ1wlGnhdDQBmwIxbQgNowJkGALOzhOBMXteZEG/i7VEDgBkw45bQABpwpgHA7CwhHndv5oSrRAOvqwHADJhxS2gADTjTAGB2lhCcyes6E+JNvD1qADADZtwSGkADzjQAmJ0lxOPuzZxwlWjgdTUAmAEzbgkNoAFnGgDMzhKCM3ldZ0K8ibdHDQDm1wKzfiuJXuce95xxzmnz0nXMMcYcfb50XafUn3Oec/Z9ytqoc9FPHV0w26+Qil8D9fB00YGbu5QVl70/N+mX6KM39kv71vp67fV7qfJzxjmnzSnztf3a+1PanlLnUJ+HXjvUd69dr/xQX/ralLbaR+86Z9+9MSmfjYlNMEcoF993N3xP3f731134Y9CSxPXSuWp9vc4t6nPGOafNKeuw/dr7U9qeUmfNfWp85oiB9s11NgA3Derzc2iCufimZ02KJj5et2F70/gCUnktf2Fq+uLQ1O4hfgHr8OWjpRvXLxgdvrx0+JJS80WtMn7Rb/llqUO/w1zGL0JNG0Ya+yl/oWyac7HpjF8e2+yrNXb6otU81+rTRHN9Ohe9HlmXzHlYt35hq8THrL2Oc64/5mXTWWe37zS343Fo5baTgzpW2224uXkIJ48h67I/rXzEeVtNpvnFb3jfhByHoq3qTvq3X5Ar38ZeadHmN8XoqKbinKt+Hx7i2sf4a640x8+h0I7mrzfvotys08aL+1I/C4lHE8zyxoniKRYhItuGXRSDEXUUvwgrva5tVMBJPHvQ1HrSfrsbgqdt5LV8P4hb20fhSv26X+mnnrf2EeuO4t9tx/v4pu/21Rm7mF8FDl2XXnV9di5xnr2+xzjKWrfbbRjWvgvb3M7MX/tNcNE4jfGz8zvS98E4NMbs1rdj2lzqZiPwS3Vy3sa55ZzU+azWWGph1GQs17ZFfBprSBtHno/mLbfrrCWufexvT1OtfnOfndw3++zFpeyjne9q7ro2ru5hfR6YVfQxwSKQm/Cws27ZOIEsRiOSKECtY3Z6W1fv9apiim3TBmHnUdeT+rlsEPFGNhbtx15zvTRHfdar1pVn7aN+TevINdar1qf166u2i22G+e22A2Tim13KdSPSa3bLOsaJ8Xh+Dkf7bsU0zk3H0uvpY455sDlpxLq1Lo2PxrWen5qFVrltc+oadDypb/vcK3+hpuq52L7j3CT3jT5PnXdvvjpvru5hbD8ZNsF8/CjDOmoDZis2FUItmCi00d1037TaTq+2v96bsR6/btsSvvRb19NnvdZjt9oUdRrr077qa9FuAHN0yjt1yOkIY5ecs7bXdnqty+vnVO9FfWsfetWx9FqX18+tenUdfdartmld6zry3NNCvYHWbbX/yeUNmErfrX61TK92DjrfWGb6rOvaNlbvvXpan+vywVx8FDRCib/8qwVQfBQ1H1FVCHX96rkYS15TgeZ6g0j1o2asr87xmDC1j6eHsM3nhAI6A06Zp9bbm3NnbG2jc9V2Wm7mldenY+i197E89bG9uQn6y9anh2080nh4EpdZzmncZaV8XFce187tWN95bpWb7Y3ZrZ/a69hST2PVbdNbl+2rrNPTQi5P6x2cb9l2jNtwnqz6yuV2zroO298xTZ15lLGv0968pbyT797c7Tq4dw3qpmMWcUZxm4+WWbgx6fpxVq7meKB+TQAlZQZU0vcu/iJw6OMm/TJIz7T1taK86DeNV/dbP9s3UXbKacwM6RpAjefW2EnUea5Vf1oe/8xQ16fz06vOL8fYxDHOd3zTPefNz8wvtzNHQVIvlRfxK96E5Ru66NvOTeenuSvikMY8VL8Yc8z53rxsH60xqn7iJprXbrSQy0w8TlmD1jHtVeuaR90gI7TzfAdg5nhXGsh1bb9Hf/nX6bMXl16+Y32rJ7u5cR9zU+vK2XMXzN3JZ2GS4G6MnCV51fOsNzVy49oprlqrRpuA2QQDUbylzVbdp/nkQa6B8kI08HIwL2RhQPYtQZa1oOd1aQAws9HgotAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpgHA7CwhOKN1OSPyTb5bGgDMgBm3hAbQgDMNAGZnCWntnpThqtDAujQAmAEzbgkNoAFnGgDMzhKCM1qXMyLf5LulAcAMmHFLaAANONMAYHaWkNbuSRmuCg2sSwOAGTDjltAAGnCmAcDsLCE4o3U5I/JNvlsaAMyAGbeEBtCAMw0AZmcJae2elOGq0MC6NACYATNuCQ2gAWcaAMzOEoIzWpczIt/ku6UBwAyYcUtoAA040wBgdpaQ1u5JGa4KDaxLA4AZMOOW0AAacKYBwOwsITijdTkj8k2+WxoAzIAZt4QG0IAzDQBmZwlp7Z6U4arQwLo0AJgBM24JDaABZxoAzM4SgjNalzMi3+S7pQHADJhxS2gADTjTAGB2lpDW7kkZrgoNrEsDgBkw45bQABpwpoEmmH/55ZfAz+EYTHEwP//8c+DncAymxFfabv7vf/wcicGUGKPfw/qV+EyJbxfM379/D/y0YyCb1pSgS9J+/PjBTycGU0UNmE/blNDwfO/BqRoGzGdsQIB5PkHLhjVV1BbMbID7udJPE4B5PzaX0stUDQNmwOzOuU8VNWA+DBzAfDg+l4DzVA0DZsAMmDtHKpd4g3rsAzAD5jd5Ts1RxrzCnuo2cMyH8wOYD8fnEpvpVA3jmHHMfcf87X149+59+PbKjnKqqN2A+UrxOwaWNw1mJzGfquF5wPzlY/jw4cP48/HLec752+fw+Pg5fBN42vszYHrJvzBZjGMWkW42YVP8vAvvv53oGK4k8qmingXMjVjefToSxyvF782AuRW/Vpk1Dsdet3VnvJ+q4YuD+dvnx/Dhw8fwxcDzy8fy+WRIOoKxnfOiwDzF8V5J5FNFPRuYbSwlNptNOAjnK8UPML/+p7w65lM1fGEwfwufHx/D52/tv/+Nrjc76QTrBN/PH0eH/fGLtJe+xrLHjx8H99yrX0PcPst9HvfA/MxmYkFc3y8ezAkY7+9GN50Bk4CTXbaF0YwOwwp7qqhfBcwSCwveIm7pU0l8/S7cvdM423IDj24/m7CZIf6LOcqwcVHt2TK5z58Gq9jGejb2RzZR7f9C16kaviyYIwB77vhL+PjhQxig+z1EZy1HHAmaWv5djkFaxxcK2l59fV3hmp9lXDOnXN7ZPLT9geuiwJyFm+Agb/Qk6AzjT3cJAJ/CnXWB9k1wIcFaAPfup4r61cD8Q+J1Fz7lazra0LjFOI9HR9/evxvirK9rTPPz68R/UWCu9SvPcbPS2DdinjU+xv6HaDzm6sjxk+Zk4nWqhi8PZoVqDbYaiPIswGyVax/2Nb3Xq/avz3ptlWe3rA7cgFrrv+C6KDC3HFcGQUfUKsq6npbPfJ0q6lcHs8RpDyB34VMdv1ivU64wsfmq218o7osCs42HrF9jEmOpn0T0amKr9XLMBOQG1Ll8HlBP1fBlwfxd3GnnqKAFztcCs4L+BfCtjy/sM2CeR8zqoKeK+tXArG9+vdZv9rpcnsW1tcoFQPmTS7Vh1v1OfH4zYK6hLXHR2Oo1x2rVYE5HFPbo4Pv3MPzy78BRhgWnBbjca19arleFrD7but/TPGK/5bgWsOfev1kwx4/ko6vIH72zuOcF8rLAbI8d7L2JUQWHGM+7TwM8zMfqMc4VPKr2Gp+p1zcB5qjVxrmxxkyvqt1609Pyma5TzcWFHfNwbjv8ZYYeG3wIH/TP5SI8tbz85V/8kziBrYI2gfdL+qVg/cu/Vn07bq6vfdrjDLsRKOBfcF0UmPc+Yr8L7z9Vf59sRRzP4oaPhu/u7vg7Zn3jSoyKWI4bWARl/bq4uVZZ6i/COPVXxNnEP/4CtuUKdU5nXt8GmJM7tjnRmOvVvmY2wqkb2yntXYL5XCe6lHaLAfOZb9xThDdnnaminuUo4xqxFEiLw77w2IsB85R1W7MxpZ8z207V8CyOeSmAPXeegNl8XD9TuIdgM1XUSwbzJ/MnjHP9FQFgnle/ou2pGgbMLzjCUJAD5nmFPVXUSwbzoQ3rUq+tAswzGIaXxH+qhgEzYL74R+WXCLhVd6qoAfPhjRMwH45PS5MvLZuqYcAMmN80mBVCXPe/1UQ2sHN/BDwvhdWa6s8GZvm4zk8/BucKWtpJ0vg5HIMp8ZW2gHgfxHVMpsQY/R7W7yxgnpIw2p7vQogdsUMDaEA00DzKQByIAw2gATRwPQ0A5gnnbAj3esIl9sT+LWsAMAPms38B9JbfGKwN8F9TA4AZMANmNIAGnGkAMDtLyDV3acbGJaIBHxoAzIAZt4QG0IAzDQBmZwnBsfhwLOSBPFxTA4AZMOOW0AAacKYBwOwsIdfcpRkbl4gGfGgAMANm3BIaQAPONLD56aefAj/EAA2gATTgRwObv/76K/z555/hjz/+CL///nv47bffwq+//soPMUADaAANzKQB4azwVrgr/BUO//333+Gff/4J//77b/h/4YYNjdj8TJkAAAAASUVORK5CYII=[/img]

Thank you,
Rinku Sharma


  Hyperlink Pivot table data
Posted by: sanj_edu - 14-Jun-2020, 06:37 PM - Forum: Ask Excel Question - No Replies


.xlsx   HyperLink.xlsx (Size: 326.75 KB / Downloads: 2)

Problem Area:
if we click on this link then it is correctly select the linked pivot cell.
However this is not dynamically and if we have some data in MAY in future then it will still select the "B8"data in pivot table which will be incorrect.
Help Required:
when click on data of dashboard, i will go to my correct month pivot data and then anyone can extract those data by double click.
Both Dashboard and Data Pivots are in different sheet in same workbook.


  Calculate idle time no movement of mouse and key board
Posted by: Inderjeet Pal - 28-Apr-2020, 11:59 AM - Forum: Ask VBA Question - No Replies

Hi team I am creating time tracker and looking for a code in which system idle time can be calculated when no movement of mouse and key board.


  Making Pivot table
Posted by: Jyoti - 17-Feb-2020, 12:11 PM - Forum: Ask Excel Question - Replies (1)

Hello all, 

I need your help for solve this query. whenever i'm going to make pivot table i'm facing error, please find attached error

 help me to  solve this.




Attached Files Thumbnail(s)
   

  Need help on code
Posted by: Inderjeet Pal - 15-Feb-2020, 04:23 PM - Forum: Ask VBA Question - No Replies

I want to copy multiple ranges and charts in the outlook body through VBA. Can nyonr hrlp with the code


  Date Selection In Range
Posted by: @m!t $@!n! - 14-Jan-2020, 01:33 PM - Forum: Ask Excel Question - Replies (1)

Hi Sir,

PFA and suggest your view.

Thanks & Regards,
Amit



Attached Files
.xlsx   Recent Live Clients Summary - Date Selection - 12.xlsx (Size: 29.06 KB / Downloads: 5)