# Posts by VMAL

• ## If specific word in 1 column, 5 adjacent columns get automated text

Re: If specific word in 1 column, 5 adjacent columns get automated text

Hi,

Regards,

VMAL

• ## If specific word in 1 column, 5 adjacent columns get automated text

Hi All,

I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
I have attached a sample sheet below.
What I’m trying to achieve is,
If Column F is Yes then sheet stays as it is. E.g. Column F/ Row 4
If Column F is No then Column G, H, I, J, K automatically come with the word N/A. E.g. Column F/ Row 5
All your help will be truly appreciated.

Regards,

VMAL

• ## If statements and automatic cell highlight if specific value

Re: If statements and automatic cell highlight if specific value

That worked perfectly, Exactly what I required.

Thank you very much Luke M.

Regards,

VMAL

• ## If statements and automatic cell highlight if specific value

Re: If statements and automatic cell highlight if specific value

Hi Luke M,

A macro is not a must.

Regards,

VMAL

• ## If statements and automatic cell highlight if specific value

Hi all,

I fairly new to VBA and would be grateful if one of you could help me.

I am trying to create a Macro to do the following.

1. If column D, from row 10 to last row,
· Value = 25 then column F on that row = 17.5
· Value = 30 then column F on that row = 21.0
· Value = 35 then column F on that row = 24.5

.Value = 25 then column K on that row = 21
.Value = 30 then column K on that row = 26
. Value = 35 then column K on that row = 30

§ Value = 25 then column P on that row = 26.5
§ Value = 30 then column K on that row = 31.0
§ Value = 35 then column K on that row = 36

2.
Ø If column G, H & I is less than Col F on same row then highlight cell RED (Fail).
Ø If column G, H & I is greater than Col F on same row then highlight cell GREEN (Pass).
Ø If column G, H & I empty then highlight cell YELLOW (Missing).
3.
ü If column L, M & N is less than Col K on same row then highlight cell RED (Fail).
ü If column L, M & N I is greater than Col K on same row then highlight cell GREEN (Pass).
ü If column L, M & N empty then highlight cell YELLOW (Missing).

4.
§ If column Q, R & S is less than Col P on same row then highlight cell RED (Fail).
§ If column Q, R & S I is greater than Col P on same row then highlight cell GREEN (Pass).
§ If column Q, R & S empty then highlight cell YELLOW (Missing).

Point No. 2,3 and 4 are repetitive.

I have attached a sample sheet.

Once again Thank you for all your help.

Regards VMAL

• ## Copy & insert rows fom one sheet to another based on data in main sheet

Re: Copy &amp; insert rows fom one sheet to another based on data in main sheet

Perfect. Got it working perfectly.

Thank you for all your help.

Regards,

VMAL

• ## Copy & insert rows fom one sheet to another based on data in main sheet

Re: Copy &amp; insert rows fom one sheet to another based on data in main sheet

Hi,

Sorry to bother you again.

I cant seem to get the highlighted cells to copy from the Main sheet to the respective sheet.

Any idea on how i could do that

Thank you again for all your help.

Regards,
VMAL

• ## Copy & insert rows fom one sheet to another based on data in main sheet

Re: Copy &amp; insert rows fom one sheet to another based on data in main sheet

Hi KirshnaKumar,

I managed to get exactly what i needed.

Thank you for all your assistance

Thanks,

VMAL

• ## Copy & insert rows fom one sheet to another based on data in main sheet

Hi all,
I have been trying to solve this problem but can’t seem to. I would be grateful if one of you awesome excel users would be able to help.
I have attached a sample sheet below.
I have one main sheet called Project Details where I want to input all data.
In the sub-sheets i.e (Jhon, Adam, Josh,Katy..etc) I only input the headers.
I want to create a macro so that in the main sheet (Project Details) any Column from C to F that shows Jhon’s name, that whole row will be moved into Jhon’s sheet.
For example, Row 7 shows Jhons name is cell C7 so I want the whole of row 7 from (A to O) to copy into Jhons sheet using the macro.
Similarly, Row 8 shows Jhons name is cell D8 so I want the whole of row 8 from (A to O) to copied into Jhons sheet and so on.
Since Jhons name isn’t in row 10, that row will not be moved into Jhons sheet.
I hope that makes sense and one of you will be able to assist me.
I am new to VBA, I created a macro but can’t seem to make it work.
All your help will be truly appreciated.
Regards,
VMAL