Four very super basic macros needed

I've started using excel macros for my work and noticed 4 repetitive tasks which could be simplified with a macro. Do you have a macro formula I can copy and try and out or do you know where I can find them.

1. Swapping two adjacent cells: e.g. swapping cell B3 with B4

2. copying the contents of a cell to another column based on color. e.g. if I highlighted cells B3 and B4 in green and left cell B5 and B6 un-colored, then a macro for copying B3 & B4 under column D, without me having to copy and paste manually.

3. Inserting an often used inspirational piece of text/quote into a cell without having to find the cell containing that quote and copying it. e.g. cell D7 contains quote but I am down working in cell D1007. I want to insert the quote in cell D7 into D1007.

4. quickly inserting cells containing dates and times; such that I have a template for the year. Best explained by looking at attached workbook. Desired result is on sheet 2 of the workbook.workbook example.xlsx

Welcome to the forum!

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

maybe these are close to what you want.

Please Login or Register  to view this content.

And for the 4th one isn't this just changing your template to use formula (eg each time is 30 min greater than the one to its left and each date is 1 more than the one above it unless its a header row.) Then pasting it wherever you want?

you don't need the ".value" in the color lines

Please Login or Register  to view this content.

the macro assumed you are using that specific green as your colour maybe you mean copy as long as it has any colour?

Please Login or Register  to view this content.