Thanks Royuk
Yes, It is the faster way but I need to make some analysis based on that sheet and which result shows up in another sheet. I need data for the specific cell as mentioned earlier.
Thanks.
Thanks Royuk
Yes, It is the faster way but I need to make some analysis based on that sheet and which result shows up in another sheet. I need data for the specific cell as mentioned earlier.
Thanks.
Hi, Hope everybody is fine.
I am using a code to input the same data to the same cell
Private Sub CommandButton1_Click()
Dim names As Range
Set names = Range("J10:J15")
Dim cell As Range
For Each cell In names
cell.Value = cell.Value
Next cell
End Sub
But the problem is I need to expand the range up to J10 to J1000.
When I did the code takes an unexpectedly long time though not all the calls in J10 to J1000 had value.
So can anyone help me how to modify the code only for the cell having value and to work faster.
Thanks and Best Regards.
Thanks, RoyUK,
Actually, I data moved from Sheet 4 to 3 as summation based on ID, After that other sheet2 works based on the value of sheet 3.
In that case, PivotTable does not fulfill my objective. Yes there is a problem result for 133428 is incorrect because those values formatted differently
And I change all the values as [hh]:mm:ss formation.
Can It do by formula or VBA ?
Thanks again and appreciate your support as always.
Thanks, RoyUK for your response.
If it is possible with VBA then I think it will be best.
Here I attached my file Time_Table.zip
Thank you in Advance for the help.
Hi All
Hope everyone is fine.
I searched many forums and google it but did not get the expected result.
Facts:
I have two worksheets, In Sheet4 Range L10:L1000, M10:M1000 & N10:N1000 have data and Matching Column is P10:P1000
Now In Sheet 3 W10 Value check through Sheet4 P10:P1000 if Matched found then it sums the matched value L10:L1000 data to H10, M10:M1000 data I10, and N10:N1000 data to J10.
It goes the same as from W10 to last available data in the W10:W column in sheet 3.
Can It Do with VBA coding?
If so, then it will be so great for me and highly appreciated.
Thanks in Advance.
Dear KjBox,
I am really impressed by the work you did for me. It works like a magic.
"Sometimes giving thanks is very little as appreciation. "
May God grant you a long and happy life.
Thanks and Best Regards
From the previous post.
The Frist time it updates.
Then I changed the monthly rent in the update sheet of the same entry and update
then 16048 is not found in the network listing also not found by the search.
Hope you understand, sorry for the poor description.
Thanks and best regards
Thanks, Kjbox,
I have attached the file again.
In this, in the Network listing, you see 16048 two Entries. Then in the update sheet, you see the data I wanted to update.
Now if I click on the update then something happens that is not clear to me.
I do not understand the cause. Please see what is happening?
Thanks and Best regards.
Matching To the exect word will be best I think so.
Thanks Again.
Yes, Kjbox my sample file has no formula. Sorry for that As I thought VBA will not affect the formula.
As it affects the formula so my search function is not working.
Thank you for the feedback.
Thank You KjBox,
Your code works fine but when I click to update it removes all the formulas in Sheet1 or Tabel1 also It changes other cell values.
Suppose I have a particular row. The code changes all the values of that particular row or it duplicates some other row.
I here attached my work file for your kind consideration. For Upload.xlsm
Thanks and best regards
Thanks, RoyUK for updating the title of the thread.
I have attached a Sample.xlsx File.
The color yellow is used to show the matching cell.
Sorry, If I am unable to describe my thoughts to you.
Thanks and always appreciate your help.
Hi Everone
Hope all are well.
I search many forums to find something but nothing seems to be similar to the problem which I describe below, hope someone helps me with a solution.
I have two worksheets named 1 and 2, Sheet 2 is the source data sheet and sheet 1 is the destination datasheet.
In sheet 1
SL | ID | Name | --- | Contact Person | Class | Result |
1 | 111 | Martin | Justin | O | 156 | |
2 | 112 | Jhon | Rubel | A | 160 | |
3 | 113 | Albert | Rose | C | 190 |
And In Sheet 2
ID | Contact Person | Class | Result |
112 | Rubel | A | 180 |
113 | Rose | C | 190 |
Now the question is after putting data in sheet 2, A command button will be clicked then the row checked in sheet 1 to the last value for a matching (ID, Contact Person & Class) if any row matched with these three conditions (ID, Contact Person & Class) found then the matched Result Column data update and unmatched data will be same as it is.
Like in sheet 1 & sheet 2 ID 112 & 113 matched, but only SL 2 result value will be updated as (ID, Contact Person & Class) matched and the result value is different but
SL 3 will be unchanged as it is the same as before. and
SL1 will remain the same too.
Hope someone helps me to ease the difficulties of value update.
Thanks in Advance
Hi, KjBox,
Thanks for your feedback,
If you don't mind, I am asking what is code for condition 2.
that is; Condition 2: if B column has "Credit or Other" then the input box opens to ask for "Date of Savings Entry Creation" after the date enter it unload in AA Cell and will show a message as "Savings Entry date is 13/01/2022.
Hope you help me to understand.
Thanks and best regards.
Thank you KjBox,
It works as expected as I want and appreciate you for the code.
By the way, Can a triple condition be applied in this code
Like
In the above table when E column data is entered then an input box opens based on B column value.
Condition 1:if B column value is Debit then the input box opens to ask for "Date of Loan Creation" after the date enter it unload in AQ Cell and will show a message as "Loan Creation date is 18/02/2022.
Condition 2: if B column has Credit or Other then the input box opens to ask for "Date of Savings Entry Creation" after the date enter it unload in AA Cell and will show a message as "Savings Entry date is 13/01/2022.
Condition 3: if B column has Nothing then no input box opens or skip.
Thanks and Best regards