Copy data from one set of cells to another cells and repeat the process -sheet attach

**talhawahab** · 03-30-2011, 03:18 AM

Hi I am fairly new to VBA. I have a sheet which has a data from column A10 to M67. Now I want this data to be copied to column Q9 (so Q9 should show data from cell A10) , after this I would like to leave 2 rows gap below and go to cell Q12 and get the data from A11 and repeat it till the columns A is blank.
There has to be some simple way with either the formulas or macros but was not able to solve it.

This means fill data on Q9 from A10, then go to Q12 and get data from A11.
Q9=A10
Q12=A11
Q15=A12
Q18=A13

I have attached the spreadsheet and shown the example.

**watersev** · 03-30-2011, 03:58 AM

hi, talhawahab, please check attachment, run code "test"

**talhawahab** · 03-31-2011, 12:22 AM

Thanks Watersev...the code works brilliantly....I didn't understand what the code meant but does the job.
I only had one issue with the code after the code is run. the two lines which are copied are identical in Q9 and Q10 and that is fine. The problem is the only difference the second line should have is: if 1st line (row9) have figures in Credit column (column W), there should be figures in Debit Column (column V) in row 10 and viceversa.

**watersev** · 03-31-2011, 03:18 AM

hi, sorry, I did miss that part, corrected, please check attachment.

I assume in Debits and Credits columns we will always have one value and zero as a rule.

**talhawahab** · 03-31-2011, 08:18 PM

Thanks Watersev now the code is perfect!....you have saved lot of my time and lots of stress!!! very thankful to you. fully solved! Dr and cr are fine now

**talhawahab** · 03-31-2011, 09:56 PM

hi again...I have one small problem again...can you replace cell U10,U13,U16 (all second line) with one fix account number which would be in cell (P1).

**watersev** · 04-01-2011, 03:34 AM

Originally Posted by talhawahab

hi again...I have one small problem again...can you replace cell U10,U13,U16 (all second line) with one fix account number which would be in cell (P1).

hi, please check attachment, field "Job code" will remain empty as requested

**talhawahab** · 04-01-2011, 01:51 PM

Thnks watersev again

....ur a gem...

**talhawahab** · 04-26-2011, 11:34 AM

Hi again,
I would like to get a quick help from you please. I have two issues but I think are small and I am stuck with it.

First, if any (number/text) in cell U9, U12, U15, U18, U21 and so on is starting with "1" i.e (left("U9",1)="1") (for eg: 11210 or 1-6110) . if yes, Then delete that row (Q9:Y9) and one below (Q10:Y10) and repeat it but going --> going to U12.
'(only do this in U9, U12, U15, U18, U21 and so on.
'I had created the macro (macro name: clearing_line_which_has_1()
see below or see in the attached spreadsheet.

Please Login or Register  to view this content.

The second issue is where the data is 'copied from left side to right, (cell Q9:Y9) at the bottom (cell u34)....12110 remains (in cell U34,U37,U40). I would like to get rid of those numbers.

I would really appreciate if you can help me with this.

**watersev** · 04-26-2011, 03:50 PM

hi, talhawahab
1. As far as I understand it's a separate task though it can be incorporated in "copy_data" (please advise if so). Sample of possible separate code:

Please Login or Register  to view this content.

2. I've amended the code "copy data" not to create those "empty" strings with account number from P1

Please Login or Register  to view this content.

If any outstanding issues or questions, please shout, best regards

Copy data from one set of cells to another cells and repeat the process -sheet attach

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from one set of cells to another cells and repeat the process -sheet attach

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Re: Copy data from one set of cells to another cells and repeat the process -sheet at

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions