I need to add some coding to allow inserting of rows based on a cell value - but to insert one row down from that cell to allow the formatting to be copied from the second row - here is a snapshot of what I need below: The user would be entering a number into C3 for example, I then want it to insert that number of rows between row 4 and 5? (the range "Invoices" refers to all dark blue cells in column C where the number would be entered)
thanks
Excel Sheet_1.JPG
Something like:
Note this code should be entered in the worksheet module, not a general module.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This may be a case where "a picture is worth a thousand words" but the best way to get help is to upload the file after removing all sensitive data.
Alf
Ps to add to Olly's solution. If your data is in a table you may need to set table to range, run macro and then convert range to table.
Last edited by Alf; 11-28-2014 at 07:19 AM.
Thats brilliant, works perfectly. Thanks very much Olly - this has completed my log finally!
Sorry just an extra point - can I get the formula in column H (its just a calc for the gross value =F4+(F4*G4) ) to copy into the inserted row/s?
the inserting row works perfectly, just need this formula to be automatic as the column is locked down not user driven.
many thanks in advance
Hi,
can I get the formula in column H (its just a calc for the gross value =F4+(F4*G4) ) to copy into the inserted row/s?
many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks