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 ?

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

  Dependent Drop Down.xlsx (Size: 10.82 KB / Downloads: 6)

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,

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

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.xlsx (Size: 326.75 KB / Downloads: 3)

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.

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.

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)
   

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

Hi Sir,

PFA and suggest your view.

Thanks & Regards,
Amit

Attached Files

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