So glad to hear that, thank you =)

@@youngwill8820 Thank you as well.

Appreciate it!

Hey there, are you using the web or application version of Excel?

Did you save it as a macro enabled workbook?

Thank you!

Hey there, which part is not clear so I can help?

Hey there, you can sure, as long as the other VBA code doesn't conflict with this code in any way it should still work. Let me know if this helps =)

Thank you so much!

@@harkaacharya8157 Hey there, thank you for the comment. Help me understand fully what you are looking for. Do you mean dependent dropdowns that update based in your first selection?

@@adwayduttagupta9887 Thank you for the comment =)

Thank you as well =)

Hey there, do you have the fill tab in the formatting dialogue box?

Hey there, apologies for the delay. I don't yet have a way set up to share files. Sorry I cannot help more but not sure I would be able to offer a good solution without fully understanding. I am trying to remedy the data transfer issue and hope to have something set up soon. Wish you all the best.

@@CareerSolutionsforToday Ok.When I want to create a simple table. I select some cells, then Insert, then Table, and something appears below that says Create Table. And you can directly give Ok or you can select the box where it says "My table has headers". But even though I don't want to select "My table has headers" and I don't give that, I just give Ok, it appears with "My table has headers". What can I do to stop this from happening, to stop appearing with "headers"?

@@forestdamian5601 Hello and thanks for this, I think I totally understand now. Did the option of selecting "Header Row" on the Table Design tab not help? That is how I can remove the header row if not needed. Let me know =)

@@CareerSolutionsforToday That's what I tried, it didn't work. It's probably something memorized

@@forestdamian5601 Oh I am sorry to hear that. Not sure why it would force the headers if you deselect them. I hope you find the answer you need.

Thank you so much!

Hello, I would be happy to try and help. I am not 100% sure I fully understand the question, but if you go to the Table Design tab in Excel with the table selected, and then click on the checkbox for header row, it removes the header formatting. Let me know if this helps, or if you were wondering about something else.

@@CareerSolutionsforToday I could send you some pictures so you can understand exactly what it is about. But how to send them to you? Thank you

@@CareerSolutionsforToday I made a short video of a few seconds. I can send it to you if you want. But how, where?

Hey there and thank you for the comment. So you cannot create or edit macros in Excel online but you can create macros in the app version and then transfer them.

Thank you!

Hey there, you can use the same menu you used to enter to exit the program if you'd like =)

Thank you so much!

Hey there, sorry to hear that, not sure why it wouldn't work on a shared sheet. Are you able to add a note at all?

What do you mean by hidden?

Hey there, so in your example based on the video are you wanting to replace the candy store dropdown with a sales figure? Apologies if I am a bit lost, trying to make sure I understand your question.

​@@CareerSolutionsforTodayokay thanks for your response. So I want a situation where if I choose taffy, with 180 I'll get the answer of candy baron. Like I want to get the value of the label area if I'm giving the type and amount or quantity.

@@amandakennedy6895 Hey there, so to find the solution you are looking for with this same table, you would switch cell C3 to candy type "taffy" and switch cell C4 to number sold "210". Then in cell C5 you can enter the function: =INDEX(B7:D7, MATCH(C4, INDEX(B8:D11, MATCH(C3,A8:A11, 0), 0), 0)) And this will return the candy store name based on sales and candy type. Let me know if this helps.

Thank you so much for the comment =)

Thank you!

Thank you so much as well =)

Thank you as well!

Hey there, the background is just based on my Excel theme and that is how you can change it, by adjusting the theme. Let me know if this helps =)

Hey there, hold down the Ctrl key while you drag and this will stop/change the auto-increment method. Let me know if this helps.

Hey there, I have a video on my channel for when this doesn't work as well. Check here: kzbin.info/www/bejne/gKGwqnyQra10iZI

Thank you!

It is VBA code yes =) Let me know if this helps.

Thank you so much!

@@pauljohnson8921 Are you using the application version of Excel or the web version?

@@stephenrowland5436 Thank you so much!

Thank you as well =)

Thank you again!

Thanks so much!

Thank you so much for the comment =)

Hey there, sorry for my delay. Still haven't found the reason or workaround for this. I will let you know if I uncover anything. I hope you have a great weekend =)

@@RH7777 Just remove the VBA code and conditional formatting and it will be removed.

@@Shelby.Correia Thank you as always =)