MACRO Help, Please Help

July 10, 2017 at 06:45:11
Specs: Excel 2013, MACROS
So I have the main raw data worksheet, which I am keeping but breaking down by creating a new worksheet at the bottom for each system so there are 9 additional worksheets at the bottom.

On the main raw data tab there are 141 different column titles in row 1 (A-EK columns), I am trying to narrow down to only about 22 of the 141 & carry them over in a certain order to each of the 9 worksheets.

I think the best approach would be to pull that order once & then copy/paste to the rest of the tabs; but I’m stuck on how to pull the order.

Can someone please explain how I can search row one for what I want & then return to a created tab in certain order? The 22 column titles I want to pull in a certain order e.g. new tabs would look like this; Row 1/Column A I want System, Row 1/Column B I want Assessment, Row1/Column C I want Type, & so on.

After all 22 column titles are created I would then want to return the raw data in each column (A-AB) from the Raw Data source to the 9 different worksheets I created. Can someone please explain how too get raw data from each respectable column with a changing amount of rows each month to the new work sheet?


See More: MACRO Help, Please Help

Reply ↓  Report •

#1
July 11, 2017 at 00:03:40
Maybe its me but I do not understand your requirements.

breaking down by creating a new worksheet at the bottom for each system so there are 9 additional worksheets

What system are you referring to?

Also please use the PRE tags when presenting any data this helps us understand it better. Read the link below.

https://www.computing.net/howtos/sh...

Try to explain your requirements again keeping in mind we cannot see your workbook.


Reply ↓  Report •

#2
July 11, 2017 at 04:54:04
How much macro experience do you have? Are you asking for generic tips and techniques that you can then use to write the code or do you need someone to actually write the macro for you?

As AWTL has noted, we don't have enough information to offer much help at this point. Besides needing to know a bit more about your data layout and requirements, we also need to know how much help you need regarding the actual coding.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •

#3
July 11, 2017 at 04:57:08
Disclaimer, I'm not an export & just learning MACRO world; I currently just record them, not write them, then I save them in note pad for copy/paste option for later use.


Is there an option to post an example excel file?

message edited by jordan112901


Reply ↓  Report •

Related Solutions

#4
July 11, 2017 at 05:00:13
Example would show what column each new tab is created from, I already created the Tabs but when pulling the data I want all the data; e.g. system 6 has 6-A, 6-B, & 6-C, but the key search would be all with 6 in it so it pulls A, B, & C.

I kept all the different main column titles in row 1 for Raw Data Tab & showed in Tab 1 what needs carried over. I thought once I did that, I could write a MACRO to create the new titles in row 1 that I have highlighted in tab 1, then would copy & paste through the rest of the new tabs since all with have the same titles just different raw data based on that system tab.

message edited by jordan112901


Reply ↓  Report •

#5
July 13, 2017 at 01:31:21
Once more, please read the following and present your data

https://www.computing.net/howtos/sh...


Reply ↓  Report •

Ask Question