Posts by lakshi

Hi All,

I want to lock certain cells in an excel sheet. I tried options under Alignment and and Review (Protect sheet) but they are not working.

Can anyone help me to sort this out.

Much thanks!

Is there no one who can help me please!!!!!

HELLO,

Someone out there who could help me!!!!

Much thanks!!

Hi Roy,

This is the issue I have mentioned in a wrong thread earlier.

Kindly help me to sort this out.

Much thanks!

Hi Roy,

I didn't get a solution yet even i created a new thread. Could you please help me.

Much thanks!

Hi All,

Much thanks to someone out there who can help me to solve this issue.

I am really struggling.

Sorry for that. New thread was created.

Hi,

I want to sum up same filed values in a workbook, for the relevant filed's row in another workbook.

Here in attached files, Dashboard's workbook 'No of LA' column should get the sum of same week's figures in Table 3 in 'apr' sheet in M_WH1&2 workbook.

I tried a formular but it is returning only 0 and I cannot figure out why.

Highly appreciate the support to sort this out!

Hi,

I guess my issue slightly related to the issue mentioned here, hence i am posting my issue in this thread.

I want to sum up same filed values in several workbooks, for the relevant filed's row in another workbook.

Here in attached files, Dashboard's workbook 'No of LA' column should get the sum of same week's figures in Table 3 in 'apr' sheet in M_WH1&2 workbook. I tried a formular but it is returning only 0 and I cannot figure out why.

Highly appreciate the support to sort this out!

Hi Logit,

It works perfectly.

Thank you very very much for your help! I am a very new person to Excel VBA. I really appreciate the support.

This website and all the volunteers work here are really life savers!

Please find the attached workbook.

Thank u very much for the support!

Hi Logit,

If copy paste cell has a value which is calculated with formula, then in the pasted sheet (month end module), that value swaps with the value in previous

"NO " row. Columns F, G, I, J have formulas hence pasted value gets changed in destination sheet it seems. Since columns A,B,C,D,E,H have no formulas it copy paste exact value (correct value).

Could you please check it and help me to copy paste only the value excluding the formulas.

Much thanks for the support!

Hi Logit,

Thank you for the support! The code shared by you copy paste rows with "NO" in column J also. Do you have any idea why is that?

Hi All,

I am trying to copy paste selected rows from sheet "Request" to sheet "Month end console". If "YES" is mentioned in J column of the row, that row should be transferred to "Month end console"

Below is the code I tried. This works correctly until a row is met which is not mentioned as "YES" in J column. Once "NO" row is met, the next immediate YES row is pasted with the previous NO row's data. Have attached the workbook herewith. Much appreciate kind support from you all!

Many thanks!

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("J:J")) Is Nothing Then Exit Sub
If Target.Cells.Count > 1 Then Exit Sub
If Target.Value = "" Then Exit Sub
If Target.Value = "NO" Then Exit Sub
If Target.Value = "YES" Then Target.EntireRow.Copy Sheets("Month end console").Range("A" & Rows.Count) _
.End(xlUp).Offset(1, 0)
Target.Select
MsgBox "Data transfer complete!", vbExclamation
Sheets("Month end console").Select
End Sub

Thank you very much Roy

I really appreciate your support!

Hi Roy,

In the Inventory Control file you shared, stock out is working (master stock is updated when Register sheet is updated in Transfer out column But Register sheet is not updated when Transfer in is updated. Could you please assist.

Much thanks!

I read rules very thoroughly once again and i really could not understand why im not getting an answer for this question?

I really appreciate all the volunteer support you are extending towards whole strangers like me!

Please help me to get the mentioned issue sorted. I want to know how to change a stock when a change is done to a row in another sheet (given the stock is updated when new items are purchased also).

Much thanks!

I didn't get a solution though!

Hi all,

Highly appreciate if someone could mention if it is possible to create a command button in a specific cell (ex: D6) via a user form.

Much thanks!

Hi again. The issue was sorted. Please ignore above request.

What has happened was when I change from sheet to sheet (while writing the formula), the sheet mentioned in the formula is auto changed by the computer. I noticed it lately. When i change the sheet name in the formula manually , vlookup works correctly.