Search results

Hi, Want to generate or display table for values entered in cell A2 to B2 cell. If the values of A2 and B2 cell change then table should be generated. Tried with below code but didn't get desired output. Option Explicit Sub table() Dim i As Integer Dim j As Integer For i = 2 To 4 For j...

Thank you bosco_yip for giving the solution, it helps me a lot.

Thank you Aligw, it works. Thanks again.

Hi All, I am applying the formula for extracting the first, middle and last name. Got the success but if only First name and last name is given then formula does not work. And if also if middle name is not present then it should display X value. Kindly help me or advice me on this. Please find...

Thank you RDAngelo for providing the solution. As i can see it will delete the duplicate rows of column A of Task, but i need to extract the data on the basis of Priority level (P1,P2,P3,P4 and P5) as P1 is the highest and P5 is lowest. That is why if you see my code i have used For Loop and If...

Hi All, Need help to copy the full row if Priority Level criteria matches (P1=Highest, P2, P3, P4 and P5=Lowest). Also column (A) Task having duplicate rows of same Task. Till now i have written the code to copy the P1 data from sheet Data into another sheet name Data1 of workbook named...

Hi All, Need help to copy the full row if Priority Level criteria matches (P1=Highest, P2, P3, P4 and P5=Lowest). Also column (A) Task having duplicate rows of same Task. Condition to be followed are below:- 1. Suppose if Priority level is P1 or P2 or P3 or P4 or P5 then it should only copy...

Hi All, Need help to find the last row in column and paste the H2 formula up to last column till the data is present in last row. Used below code but not getting success. Also code will automatically add column name Mid value in H column. Example if cell H2 contains a formula of mid(G2,20,2)...

Hi All, I am new to this programming world of VBA and need help on below requirement. Not able to under stand from where to start. Please find the requirement details:- 1. The source of data is file name "SourceData.xlsx" of sheet name Data. Done some calculation also, extracted the Priority...

Hello Sir, I am new to this programming world of VBA and need your help on below requirement. Not able to under stand from I start. Till now I have open the file through code. Requirement details:- 1. Need to paste the Task code and other details in another sheet on the basis of Priority...

Thanks Logit for quick solutions and it works. Thank you!! Warm Regards, Amit Singh

Hi All, Need help to find a specific word named "Product Line" from column or range (column I of LOB). Two condition to be met:- 1. If a mentioned word "Product Line"is find in column I of LOB, then it will run normal code which i have already written. 2. If a mentioned word is not find in...

Thanks for asking the query over this. If you see my attachment, then you will find that from range column AD to BA, if we don't find any value between above mentioned range then delete the entire rows. Hope i have clear your query and do let me know if you have any other query. Thank you...

Hi All, Can anyone solve this query as still i didn't get any solution. Please let me if you require any other information. Thank you!! Warm Regards, Amit

Hi All, Can anyone solve this query as still i didn't get any solution. Please let me if you require any other information. Thank you!! Warm Regards, Amit

Hi All Need help to remove the blank rows from the workbook sheet. I have highlighted the column (yellow) based on which the blank rows to be deleted, means row of cells which don't have the value needs to be deleted. I have attached the two workbook, 1st workbook is the file where changes...

Hi All, Need help to find and paste the cell value in a column if specific criteria find in a column. I am still working on the code but not getting the desired output. Two requirement with conditions:- 1. If a "Product Line" is find in column named LOB(D column) against the column named Sort...

Hi, Need help to find the blank cell just after the column header after applying filter in Column I of LOB column by choosing the criteria "Product Line" Query:- Find the blank cell just after the Header column after applying filter Condition 1:- If blank cell found, column K of Customer...

Thank you Chihiro for solving the query and it work perfectly. Thanks a lot!!:) Warm Regards, Amit Singh

Thank you for replying over my query. Request you to treat this sample of data as a normal table and rest i can modify it accordingly. Treat it as this the source of data. Thank you!! Regards, Amit Singh

Hi All, Need help to remove rows from the column which starts from "Product"(after that any word contains), but the starting word will be Product. I have highlighted the cell which i need to remove in yellow color. Steps to follow:- 1. Apply filter in column name Comments. 2. Delete or remove...

Hi All, Need urgent help to copy paste the cell value to another sheet of column till it finds blank rows. I have attached the file with 3 sheet tab, Student sheet is source tab, Marks sheets is output tab and OutputRequired sheet tab is the desired output which i want. Below is the code...

yes, checked the file and it is working. Thanks a lot for your help. Thank you.

3) Do You mean columns which has empty cells? Yes, the column which have empty cells and also column which have filled and empty both. 4) hmm.. 5) Use code-tags. It will select and copy the column C1 range with header name(Maths) and paste to another sheet name Marks of Column A1(Maths). In...

Hi All, Need urgent help to copy paste the cell value to another sheet of column till it finds blank rows. I have attached the file with 3 sheet tab, Student sheet is source tab, Marks sheets is output tab and OutputRequired sheet tab is the desired output which i want. Below is the code...