Edit vba to split values over 10 columns and required rows

**JNEWMAN** · 03-31-2019, 06:30 PM

Hi Forum
The attached script works really well but I would like it to load as 10 column's across and the rest of the value in required rows 10 across, i.e. if it was 1 to 50, then it would load numbers 1 to 10 in columns A1:J1, next 10 would be A2:J2 ect, hope this makes sense.

Please Login or Register  to view this content.

Thanks in advance
James

**mjr veverka** · 03-31-2019, 07:27 PM

Even as for the proverbial Scotsman, you are extremely economical/frugal in sample data, that would help in solving the case ...

... give an example of the data layout before and after the macro.

**JNEWMAN** · 04-01-2019, 03:07 AM

Good point, the more information the clearer it is..

I have a attached a spreadsheet data sample of the current output (A1)
and what I am hoping for in (E1). Hope it makes more sense looking at it.

Thanks
James

**jindon** · 04-01-2019, 04:36 AM

See if this is how you wanted.

Please Login or Register  to view this content.

**JNEWMAN** · 04-01-2019, 05:14 AM

Hi Jindon
Don't think my first reply to went through to you, on testing it provides exactly what I am looking for, but is multiplying the No. of Units entered by 10. i.e. when I input 30 units it produced 300

I noticed that the No. of Units is driving the number of rows it produces, if I enter i.e. 3 in No of Units it gives me 30, looks exactly what I was looking for but I need the No of Units to be the actual number required as it could 15 and I would need to add it as 1.5. Hope its workable as its near perfect.

**jindon** · 04-01-2019, 08:17 AM

Sorry, but I don't understand what you are trying to do.

If you explain step by step logic, it may help to understand.

**mjr veverka** · 04-01-2019, 10:24 AM

Hmm ... maybe this way (?):

Please Login or Register  to view this content.

**JNEWMAN** · 04-01-2019, 11:16 AM

Works well Porucha, many thanks for your input.

Best regards
James

Edit vba to split values over 10 columns and required rows

LinkBack

Thread Tools

Rate This Thread

Display

Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Re: Edit vba to split values over 10 columns and required rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Split Cell Contents to New Rows & Copy Cells containing single values to the new rows

Converting rows to columns and adding extra rows as required

[SOLVED] Formula required to split uneven data into different columns

split multiple semicolon separated values into new rows for multiple columns

[SOLVED] Populate cell values into 6 named text boxes in a userform then edit if required

split & transpose columns to rows?

Split rows into columns?

Bookmarks

Bookmarks

Posting Permissions