Hi..
I'm new here and I tried to look if I'll find solution for my problem but I was unsuccessful. I create document in excel 2013 and in first worksheet I have table with few columns.
In first column is name of material in second I want to show color and name of color which I choose/add in second worksheet...and all the time when I add new worksheets with new name of material, they show all in table... my problem is... in my table I can not do that they show me color and name of color in second cell of column, which I add or choose in another worksheet and cells that show this color and name of color have to be linked on name of material which you find in first column... and cell with this color and name has to follow up and down name of material, because I all the time add or delete new worksheets with different name of material...
in another columns in table I used this formula
=IF(ISERROR(VLOOKUP($C$1;INDIRECT("'"&ZALOGA!$A2&"'!$A$11:$B$11");2;0));" ";(VLOOKUP($C$1;INDIRECT("'"&ZALOGA!$A2&"'!$A$11:$B$11");2;0)))
which work great, only I have problem with cell in second column who have to show name of color and backgroundcolor
can anybody help me
Vba to copy cell interior color
- sebseb
- Thread is marked as Resolved.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
-
You need to attach an example workbook
-
Hello and Welcome to the Forum
Whenever you are posting a thread ... it is Super helpful to attach a sample file ...
It allows to truly visualize the situation ... and to propose a solution fully adapted ... !!!
-
here is
-
Barva = Color
-
-
You have code to use an InputBox to rename a sheet. I'm not sure what else you want
-
i need vba code for second colum wich show color and name of color in tabel ( worksheet ZALoga) which I choose/add in atherworksheet and this color have to go up or down basic on name in first colum
-
i wish that blue color follow cell text from first column and for this i need VBA code...
-
:)))
-
There's no code in the sample or an explanation of what you want.
Are you really using xls?
-
-
yes, i m sure 100%
-
sample does not have code because i have not that code
-
i ask you if you can halp me and create this code
btw sorry on my eng.. is not so good
-
if i had this code i put in sampel and ask where is problem with code, but i have not and try to finfdit
-
can somebody help me with this problem??
-
-
Hello,
Unfortunately ... your explanation of what you want to achieve ... is extremely confusing ...
Bohužel ... vaše vysvětlení toho, čeho chcete dosáhnout ... je nesmírně matoucí ...
May be you should write very simple words in Czech ...
Možná byste měli psát velmi jednoduchá slova v češtině ...
-
sorry but i am not czech
-
can we speak privately??
-
sorry but i am not czech
Just write in your own language ... with very simple words ... Google Translate can do miracles ...
-
Code
Hello, Unfortunately ... your explanation of what you want to achieve ... is extremely confusing ...
if look my print scr p3 you will see tabel and my wish or what i need is:
- all time when i add or remove new sheet (name of new sheet is show in colum a) in colum b color shoul be follow name from colum a
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!