VBA Help I think

[markr98]

Hello, I'm trying to combine and remove some data from several columns and need to make it into another sheet and delete some data. Here's what I got.

I need to combine the following columns from the import tab to export tab.
Columns G,H,I,J need to copy over to Export tab P,Q,R,S, with all the items expect for the part that start with the U####. After those are moved over to the export page I the data from columns L,M,N,O moved to start at the last row right under the previous data. I would like this to be seem less data transfer. I want to make this as simple as possible.

I'm attaching a sample one with the data in the import locations and what I need for the finished product. Any help would be great thanks.

Mark

[AB33]

Please change the title of you topic before your re-mind by the moderators.

[No(r)way]

Hi Mark,
I am by far no excel genious, so this can probably be done in a smoother way. But I tried using the code below in the file you attached and it worked just fine.

Please Login or Register  to view this content.

[AB33]

No(r)way,
You also not adhering by the rules of the forum on code tags. Please read form's rule.

[arlu1201]

markr98,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.