Question description:
This user has given permission to use the problem statement for this
blog.
Adding a column exactly like tab ZC-Zorba highlighted yellow with Twitch Irony 5322 to tabs . . . ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
Solved by F. F. in 52 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
02/10/2018 - 07:07
Hello
User
02/10/2018 - 07:07
Adding a column exactly like tab ZC-Zorba highlighted yellow with Twitch Irony 5322 to tabs . . . ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User
02/10/2018 - 07:07
I'll send the file
Excelchat Expert
02/10/2018 - 07:07
Welcome to excelchat, I see your question is about adding a column to many sheets.
Excelchat Expert
02/10/2018 - 07:07
I can help you with the problem. I'll also provide a full explanation of the solution.
Excelchat Expert
02/10/2018 - 07:07
Thank you.
User
02/10/2018 - 07:07
[Uploaded an Excel file]
User
02/10/2018 - 07:08
so when you open it please go to ZC-Zorba tab, it's 3 quarters to the right
Excelchat Expert
02/10/2018 - 07:09
Okay, I'm there.
User
02/10/2018 - 07:09
ok
User
02/10/2018 - 07:09
so if you see highlighted yellow Twitch Irony 5322 in column AL
User
02/10/2018 - 07:09
AL/AM
Excelchat Expert
02/10/2018 - 07:09
Hmm, I can see that.
User
02/10/2018 - 07:10
I want to put those in all the tabs exactly like this without messing up any other formulas in tabs ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User
02/10/2018 - 07:10
just adding twitch irony 5322 to ZD-Zorba, etc
Excelchat Expert
02/10/2018 - 07:12
You mean you want to insert new columns to these tabs? Just like the AL/AM column of ZC-Zobra tab?
User
02/10/2018 - 07:13
yes and put the formulas in just like AL6 and AM6
Excelchat Expert
02/10/2018 - 07:13
Got it.
Excelchat Expert
02/10/2018 - 07:13
Please give me a few minutes.
User
02/10/2018 - 07:13
no problem
User
02/10/2018 - 07:14
just please send when you are done
Excelchat Expert
02/10/2018 - 07:14
Sure, please stay with me.
Excelchat Expert
02/10/2018 - 07:23
[Uploaded an Excel file]
Excelchat Expert
02/10/2018 - 07:23
Please download and check the file.
User
02/10/2018 - 07:25
one moment
Excelchat Expert
02/10/2018 - 07:25
Sure, take your time.
User
02/10/2018 - 07:26
ok so sorry
User
02/10/2018 - 07:27
so AL6 from ZD-Zorba
User
02/10/2018 - 07:27
should be Jan-ZD
User
02/10/2018 - 07:27
I can change it, not a big deal
Excelchat Expert
02/10/2018 - 07:27
Okay.
User
02/10/2018 - 07:28
does that make sense?
Excelchat Expert
02/10/2018 - 07:28
I'm sorry not really. I have just copied the formula as instructed from the ZD-Zorba tab and pasted on other tab.
Excelchat Expert
02/10/2018 - 07:29
Sorry from ZC-Zorba
User
02/10/2018 - 07:29
yeah, but do you see other tabs are different names?
Excelchat Expert
02/10/2018 - 07:30
Yeah.
User
02/10/2018 - 07:30
it should follow what the name is
Excelchat Expert
02/10/2018 - 07:30
But I'm not sure what is it you are trying to say.
User
02/10/2018 - 07:30
ok look at Pennies 5375 in ZC Zorba
User
02/10/2018 - 07:30
look at the formulas
User
02/10/2018 - 07:30
then go to ZD-Zorba
User
02/10/2018 - 07:31
Pennies 5375
User
02/10/2018 - 07:31
do you see the difference in the formula
Excelchat Expert
02/10/2018 - 07:31
So you are saying each sheets formula should be different?
User
02/10/2018 - 07:32
yes
Excelchat Expert
02/10/2018 - 07:32
Oh okay. I didn't have that information earlier.
Excelchat Expert
02/10/2018 - 07:32
I will make the amendments.
User
02/10/2018 - 07:32
ok, you sure?
User
02/10/2018 - 07:33
I would look at what the Pennies 5375 say
User
02/10/2018 - 07:33
and it's almost identical
Excelchat Expert
02/10/2018 - 07:33
Hmm, I got the point.
User
02/10/2018 - 07:33
ok
Excelchat Expert
02/10/2018 - 07:36
[Uploaded an Excel file]
Excelchat Expert
02/10/2018 - 07:36
Please check now.
User
02/10/2018 - 07:36
alright I'll check it out
User
02/10/2018 - 07:38
they should all be AL
User
02/10/2018 - 07:38
not AJ
User
02/10/2018 - 07:38
I got it
Excelchat Expert
02/10/2018 - 07:40
You mean =IF($B6<=Setup!$C$4, 'Jan-Other'!$AJ$45, "") should be AL? instead of AJ?
User
02/10/2018 - 07:41
yes
User
02/10/2018 - 07:41
I got it
User
02/10/2018 - 07:41
no biggie
Excelchat Expert
02/10/2018 - 07:41
No No, I can make that change.
Excelchat Expert
02/10/2018 - 07:41
Please allow me a few more minutes.
User
02/10/2018 - 07:41
ok
Excelchat Expert
02/10/2018 - 07:41
Thank you.
User
02/10/2018 - 07:43
you need to add it in tab ZE-Fines
Excelchat Expert
02/10/2018 - 07:44
That changes also need to be applied to ZE-Fines tab?
User
02/10/2018 - 07:44
yes, you missed a tab
Excelchat Expert
02/10/2018 - 07:45
Sorry, that I missed.
User
02/10/2018 - 07:45
oh sorry
User
02/10/2018 - 07:45
I didn't put it in there
Excelchat Expert
02/10/2018 - 07:45
But it was not included in ZD-Zorba, ZE-Zorba, ZB-Zorba, Other-Zorba, ATP-Zorba, ZC-Fines, ZB-Fines, Other-Fines, ATP-Fines, ATP
User
02/10/2018 - 07:45
my fault
User
02/10/2018 - 07:45
yes, please add
Excelchat Expert
02/10/2018 - 07:45
I am doing it now.
Excelchat Expert
02/10/2018 - 07:48
[Uploaded an Excel file]
User
02/10/2018 - 07:48
ok, I'll look at it
Excelchat Expert
02/10/2018 - 07:48
I believe this should check out.
User
02/10/2018 - 07:50
ZE-Zorba
User
02/10/2018 - 07:50
you have ZD in AL6
User
02/10/2018 - 07:51
i got this
Excelchat Expert
02/10/2018 - 07:52
Thank you. I'm feeling ashamed. :(
User
02/10/2018 - 07:52
also Other-Zorba
User
02/10/2018 - 07:52
says Jan-ZB
User
02/10/2018 - 07:53
ATP-Zorba is wrong
Excelchat Expert
02/10/2018 - 07:54
Please give me 15 minutes.
Excelchat Expert
02/10/2018 - 07:54
I will ask our support team to send you the corrected file.
User
02/10/2018 - 07:54
I got it
User
02/10/2018 - 07:54
sorry
User
02/10/2018 - 07:54
I'll give you 5 stars
User
02/10/2018 - 07:54
don't worry
User
02/10/2018 - 07:59
ok, I'm done
User
02/10/2018 - 07:59
thank you
User
02/10/2018 - 07:59
I have another one I'll submit
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.