Conditional selecting and pasting in excel -

-

I am quite new to VBA coding, so I used to hope that you can help me with the following problem.

I am looking for the best way to organize the following:

With a set of data, I get various types of documents (a definitive document type of all) with my information (Such as the customer's name, address, amount, VAT, ...) from this file, I would like to select some doctor type (eg DG, EG, SA, ...) which holds concessions every time and with those items Copy copies of those related rows Land.

For example

Customer Name Date Dosage Discount Doc Type

25739484 Burt 01/01/2010 100 15% 2% EG

< P> Now my question is:

  1. What is the easiest way to say which type of doctors I have chosen and pasted (this file is for reusing the company Is it the users to put them into different cells?
  2. Depending on the doctor types choosing users, how can the macros select those rows and copy them to a new file?

Thanks a lot! !!

Allen

Please note that this is not complete and I Smile I hope this helps you get started. 

  In the form of a slow DT, the worksheet as the string DIS has been retarded in the form of slow CNT as the Boolean decimal spaces as long as the user has been doc type DT = Ask for the input box ("Enter the Doctor Type") 'Get the active sheet = thisWorkbook.ActiveSheet if DT & lt; & Gt; "" Then do not loop over the rows while CTT = CNT + 1 "Doctor type column for doctor type if ws.Cells (cnt, 6) = dt then 'keep copy of the line here' keep track Exit the "empty" rows, after 1000 emptys, loop if ws.Cells (cnt, 6) = "" empty number = empty count 1 if empty number = 1000 is done = true loop end if

Comments

Post a Comment

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

-
I'm new to this I'm writing a clr. stored procedure that can be used to get values ​​used in a calculation Call for another stored procedure for Gives an archived methodology int (I think SqlInt32? Value of the table's value is int) which is then necessary to convert to decimal. Here I have the code: Public static integral mood (SQL MDMMYLUE, escalistering AMY type, out of SQLDCM Result) {aResult = 0; Try {SqlConnection conn = New SqlConnection ("Reference Connection = True"); SqlCommand cmd = New SqlCommand ("sp_GetType", conn); Cmd.Parameters.AddWithValue ("@ myValueType", aMyValueType); Cmd.CommandType = CommandType.StoredProcedure; Conn.Open (); Object type = CMD. Exclamation Asser (); Conn.Close (); Decimal type FORCalculation = Convert. ToDecimal (type); Decimal value = convert toDecimal (aMyValue); // ** calculation calc = new calculation (); Decimal result = calorie.docalulation (typefarculation, value); I get an exception...
Read more

Calling GetGUIThreadInfo from Outlook VBA -

-
I need to find the active window'm writing a VBA macro in MS Outlook, which is a specific process. The goal of this is to get the active window / document name even if its original application has more than one document interface. User processor with GetCurrentThreadId is active, I am using GetGUIThreadInfo to get .dll. Here is the correct code: private type RECT as as Left LongPtr top LongPtr right LongPtr down LongPtr termination of private type GUITHREADINFO cbSize as LongPtr flags LongPtr hwndActive LongPtr hwndFocus LongPtr hwndCapture LongPtr as as as as as reset as LongPtr rcCaret as LongPtr hwndCreate as LongPtr hwndMoveSize as HwndMenuOwner end of Private Equity PtrSafe function GetWindowThreadProcessId Lib "user32" (_BVV hnw LongPtr as LongPtr Nig Mr. announced as PtrSafe function GetGUIThreadInfo Lib "user32" _ (ByVal dwthreadid as LongPtr, _ lpguithreadinfo as GUITHREADINFO) LongPtr Sub MyFunction () as dim strWindowTitle string = space as s...
Read more

Obfuscating Python code? -

-
I'm looking for a way to hide my Python source code. print "Hello World!" How can I encode this example so that it is not human-readable? I have been asked to use Base 64 but I'm not sure how. itemprop = "text"> It is limited only, first level ambiguous resolution, but has built-in: byte-code in Python Is a compiler for: dragon-o-m py_compile & lt; Your program.py & gt; creates a .pyo file with a byte-code, and where the docstrings are removed, etc. You can rename .pyo with the .py extension, and python & lt; Your program.py & gt; runs as your program, but it does not have your source code. PS : If your program blur modules like this, you need to rename them with the .pyc suffix (I Not sure it will not break a day), or you can work with .pyo and run them with python -o ... .pyo ( Import should work). This will allow dragon to search your modules (otherwise, Python looks for the .py module).
Read more