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
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
"Helper" sheet
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
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
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
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
