Cut/copy Multiple Lines of data with VBA or Formula ??

**Aeneren** · 08-31-2014, 07:20 PM

Hello Again,

Trying to pull specific Group of data from one Sheet and paste it onto another sheet Using a specified Group #. . .

Attached a stripped down Workbook with notes in it to try and show what i want little better.

Thanks
Aeneren Arrow

**protonLeah** · 08-31-2014, 08:24 PM

You will have to get rid of all those merged cells. They are unnecessary.

**Aeneren** · 08-31-2014, 08:39 PM

Well unfortunately i cant they are throughout the spread sheets.

That is a Stripped down copy of the entire thing and to do so would mean rebuilding the entire WB and that is something i would rather not do at this time

Aeneren

**alansidman** · 08-31-2014, 09:47 PM

If you wish to have a VBA solution, then you will need to comply with Ben's suggestion. VBA does not play well with merged cells.

**xladept** · 08-31-2014, 11:00 PM

We may, nonetheless, be able to accommodate you!

**Aeneren** · 09-01-2014, 12:00 AM

alansidman, I know it does not play well with merged cells but I do have several areas working with VBA and they are merged.

xladept if you are able to give some insight into how this can be done I would greatly appreciate it

Aeneren

**xladept** · 09-01-2014, 12:44 AM

I'll attempt it tomorrow

**kvsrinivasamurthy** · 09-01-2014, 02:40 AM

Pl see file with VBA.
Worksheet_change event is used.

**xladept** · 09-01-2014, 04:27 PM

Hi Aeneren,

The reverse procedure is unclear to me, in order to update the data sheet from the main which field(s) can we match on??

Meanwhile here's a routine to bring the data over to the main by group:

Please Login or Register  to view this content.

**Aeneren** · 09-03-2014, 03:58 PM

kvsrinivasamurthy . . . xladept thank you for your time and input . . .

Sorry i had a family emergency and this is first time ive had chance to check back on this.

xladept . . kvsrinivasamurthy Is there anyway to do more of a "Cut and paste" in both directions, or use the VBA to pull it then a seperate maybe a Click Button to activate a cut and paste that would Read the Range on the Main page and then "Cut Paste" back to the Data page over using the second set of numbers and the "Match"

Thanks Again
Aeneren Arrow

**xladept** · 09-03-2014, 05:44 PM

I could do it with the entire group - is that what you would want??

**Aeneren** · 09-03-2014, 05:56 PM

No what you have to pull from data to the main works great and is what im looking for . . . .

Now after i update the data on "Main" that was pulled need someway of taking whats has been updated and putting it back on the "Data"

Aeneren Arrow

**xladept** · 09-03-2014, 06:24 PM

Hi Aeneren,

In my post #9 I asked you which field(s) we could match upon - is it the third field starting column F along with the Group Number?

**xladept** · 09-03-2014, 06:56 PM

Hi Aeneren,

If my assumption is correct then here's the couplet:

Please Login or Register  to view this content.

**Aeneren** · 09-03-2014, 07:06 PM

Ok i will try these out when i get home and on a system and post on them tomorrow

Aeneren Arrow

**Aeneren** · 09-09-2014, 07:10 PM

stripped chartA.xlsmXladept sorry had some problems getting your code to work . . . had a issue on my main Book that is now resolved. . .

1. Your Code works it pulls data from the one sheets onto the Main sheet just fine. .
2. Your Code to send the Data back to the original code does work but it is sending not only the data that was pulled but everything on the said Lines A:ZZZZZZ or how ever far there is data ive placed the code in a test book so that you can see what is happening. It should only be sending the Data that was pulled and updated back.

**xladept** · 09-09-2014, 07:44 PM

I had to change a few values:

Please Login or Register  to view this content.

**Aeneren** · 09-09-2014, 08:23 PM

Thank You Xladept it works Great and I didn't have to unmerge a single thing

Thanks for your work on this for me
I would give Rep again but it wont allow it

Aeneren Arrow

**xladept** · 09-09-2014, 11:35 PM

You're welcome and thanks for trying to rep me again! Excellent!

Cut/copy Multiple Lines of data with VBA or Formula ??

LinkBack

Thread Tools

Rate This Thread

Display

Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Re: Cut/copy Multiple Lines of data with VBA or Formula ??

Thread Information

Users Browsing this Thread

Similar Threads

Need formula that calulates best options from multiple lines of data.

[SOLVED] Move Formula Multiple Lines With Copy, Paste

Copy Multiple lines of data by Part # to New sheet

copy data across worksheets and add multiple lines

[SOLVED] Copy multiple wrkbooks, multiple lines of each

Bookmarks

Bookmarks

Posting Permissions