VBA: Extracting part of data in column A to paste it to column C,D,E on condition

A

Adar123

Board Regular
Joined
Apr 1, 2018
Messages
83
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
Hi everyone,

I have data in column A, B, C which looks as per table below. How do I create entries in new columns based on data contained in column A ="5DP" and "20DP" using VBA? Then cut-paste data from column C to a relevant cell C, D or E?

There are a few steps to take and I do not know where to start...

Thank you.

Data in current form:
Rich (BB code): 


ABC
NameProductValue
7_ROUNDED:FALSE_JUL2020_25DPOre104.3018356
7_ROUNDED:FALSE_JUL2020_35DPOre105.8981417
7_ROUNDED:FALSE_JUL2020_45DPOre107.2609272

How it should look like:
Rich (BB code): 


ABCDE
NameProduct25DP35DP45DP
7_ROUNDED:FALSE_JUL2020Ore
104.3018356​
105.8981​
107.2609​
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

J
  • Question
Complex Move data from two spreadsheets with similar data in different columns to a specific column in an existing spreadsheet(Sheet 3)
Replies
0
Views
117
JMC57
J
B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
188
bh24524
B
J
  • Question
Sum data in a range based on a column and row and an equation
Replies
1
Views
141
bobaol
B
F
  • Question
Match entries in corresponding cells in B,C & D to Column A and Arrange in Columns E,F,G based on best match
Replies
0
Views
361
frank933
F
T
  • Question
Complex VBA to loop through each worksheet and extract text
Replies
3
Views
177
bobsan42
bobsan42

Forum statistics

Threads
1,214,989
Messages
6,122,622
Members
449,093
Latest member
catterz66

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top