How can I auto populate a different worksheet based on values on …
Jul 18, 2017 · As I enter data onto my main worksheet I would like excel to auto populate separate worksheets based on values entered. Example: If I enter Apple in cell B2, Excel …
How can I split the data in one EXCEL column into two columns?
Sep 10, 2019 · I have an EXCEL 2016 file that is a list of people which has the first and last name in the same cell, separated by a comma: Smith, Robert Jones, Mary etc. I would like to split …
Link Excel 2016 cells from one worksheet to another...and more
Nov 12, 2015 · I wish to input and save data onto an excel worksheet, in which certains cells then share/repeat the same data to be saved on another sheet. In my case, details from an invoice …
What is the best way to pull and seperate data from a table?
From Moderator: Duplicated here ==> Marked HansV MVP as solution I have a table that shows a sports league's schedule and results. I want to pull data from that table for each team and then …
How do I separate data from one column to different columns?
May 26, 2012 · I want to separate data from one column to different columns. One column have contain data with following structure. order_id,page_id,first_name,last_name,email,order_date …
Export selected sheets as separate pdf file - Microsoft Community
Jul 10, 2025 · Hi, Need help to create macro to export certain selected sheets as separate pdf files. Steps are: 1. An excel file is open 2. It contains several sheets 3. It also contains a sheet …
how to split mr & mrs john smith into two cells
how to split mr & mrs john smith (cell F) into two cells: Mr. & Mrs. John into cell G Smith into cell H
time splitting into shifts - Microsoft Community
Nov 15, 2010 · Hi All, I have to split up time periods into 3 shifts: 14:00-22:00, 22:00-06:00, 06:00-14:00. I'Ve created formulae which work if finish day is not later than start day +1, but I have to …
Find the first value from a column - Microsoft Community
Oct 31, 2021 · Is there a formula which can be placed in the F column which can find the first value from E column whenever there's a value in C column? For example, the formula from F1 …
Bell Curve - Show Data Table with legend keys - Microsoft …
Jan 9, 2019 · Bell Curve - Show Data Table with legend keys I am working a Bell Curve chart and need to insert the data table with legend in excel 2016. I have searched and found where one …