Automatically copying specific data from raw data on one sheet to another sheet, given selected criteria

Question

Have a couple of questions.

I have tried to make excel do this using lookup function but can't get it exactly right.

1. Getting excel to read the data on a Raw data sheet and only copy selected data to another specific sheet. Thus I want Columns A, H, I L only if data in Column G matches a specific word.

When attempting this I can only get it to copy with blanks in-between, I can't have the blanks for this to work. I only want the data that fits the criteria shown on this other sheet automatically.

2. Getting excel to copy only selected columns to another sheet automatically.
3. Getting excel to assign a specific name or value given a time. I want it to assign a letter if a time fits between a period. for example. if time is 0935 it assigns letter B (where B = 0900-1000).

I have attached an example workbook with Mock data to demonstrate what I am struggling with.

Any help would be much appreciated.

Travis

https://www.dropbox.com/scl/fi/gbdvvmcglra18nfjtbd2l/Mok-Excel-Sheet.xlsx?dl=0&rlkey=qvddm1f68cqq454azl2xj84ae

Answer 1

Hello, TravisEO

Thanks post your message in the Microsoft community.

I understand from your message that you need to add some custom functionality to your Excel sheet.

We downloaded your form and tested it. Your first and third questions should be implemented by adding VLOOKUP and IF functions. However, I'm sorry, but the Microsoft community is mainly responsible for solving problems arising from the daily use of Windows systems and Office components, rushing to give you a solution will probably not solve your problem.

To better answer your question.

Please click the link below to go to the Excel forum to initiate a question and our relevant engineers will provide you with support.

Microsoft Excel Community

From your second question, we understand that you need to copy only selected columns, you can follow the next steps:

Select the column you need to copy, right-click the mouse > select copy > right-click in the table you need to paste (don't paste yet) > selective paste > keep the source column width, you can copy the column you selected completely.

Due to design reasons, I‘m so sorry that the automatic copy feature is currently not available. We have recorded your comments and believe that more personalized settings will be available in the future.

Laraine | Microsoft Community Support Specialist

---

* Beware of scammers posting fake support numbers here.

* If this answer is helpful, please mark it and vote, as it will benefit other community members reading here.

Answer 2

I have a question. I have a column with township and range data - 130N-102W-25 All in the same format. I'd like to break this data down and put each in a separate column... I can do it manually but that's a pain and I'm not an Excel wizard and there must be a formula(s) for coping each of these into a new column.

Help!

thanks

jc

Answer 3

Hi Travis

Your scenario and requirements are ideal for using Power Query.

You may find in this link a copy of your file with a PQ solution https://we.tl/t-fHy6YSaUEc

Notes:

1. I choose to use a combination of Power Query and regular Excel formulas

Nevertheless, It is also possible to output the same results using Power Query only.

2. Add/replace the data in the Raw Table Go to the Data ribbon tab and click Refresh All, to update all the output tables

The following videos will help you to understand the solution and perhaps give you more ideas for further reports

https://www.youtube.com/watch?v=dq3UvGkGhts&t=116s

https://www.youtube.com/watch?v=8MlDYKPxznQ&t=430s

https://www.youtube.com/watch?v=oVZW1gCObHY&t=374s

I hope this helps you and gives a solution to your problem

Do let me know if you need more help

Regards

Jeovany