VBA to look for reference and then copy and insert value only into another sheet

Nova1979

Board Regular
Joined
Feb 4, 2020
Messages
113
Office Version
  1. 2010
Platform
  1. Windows
Good Morning/Afternoon/Evening good people of Mr Excel,

I have no knowledge on VBA and am looking for some assistance in pulling data from a sheet to another.
I apologise in advance as I do not have access to the XL2BB addon to excel due to restrictions where I work and can only provide screen shots of the information/data.

I take raw data and pate it into a workbook sheet titled "RAW DATA". The example below contains all columns copied but only contains example data in the relative columns I am needing to work with. Also to note that the numbers in columns V and AI are a text format. In the screen shot I have shrunk the columns (due to being blank for this purpose) in an attempt to retain the column references,
"RAW DATA" sheet
1734511280067.png


Below is the format I would like it to be converted on a "Master" sheet, noting that that numbers are originally copied as a text format and need to be changed to a number format as there is conditional formatting related to columns I, K, L, M, N, and O. I have a "Helper" sheet that pulls the date ranges and the reference number in column A, B and C. The helper sheet is in place so I can change the date references.
"MASTER" sheet
1734510911063.png
"Helper" sheet
1734511633752.png

Currently I am using a "Temp" sheet to pull information, but even then, I don't know enough regarding formulations to pull data based of reference and then have it insert itself moving everything else down. (Nor do I know if it is even possible with formulation), however this is very clunky for what I am trying to achieve.
I believe that a VBA would be able to pull direct from the raw data (even if it utilises the helper sheet) and place it into the MASTER sheet without the need of a temp sheet like I am currently using

I appreciate any and all help provided. Hopefully I am clear enough in what I am trying to achieve.
Thanks in advance
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Hello good people of Mr Excel.

I have attempted to attach a link to the trial document. If this does not work, please let me know and I will try to resolve to get the help I am after

Copy of 8 Shop trial data.xlsx

Thanks all
 
Upvote 0

Forum statistics

Threads
1,225,611
Messages
6,185,994
Members
453,334
Latest member
Prakash Jha

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