I run a report every week where i need to put borders around the text and numbers only on the spreadsheet. Is there a macro someone has created to help me with this issue.
I run a report every week where i need to put borders around the text and numbers only on the spreadsheet. Is there a macro someone has created to help me with this issue.
It's fairly simple, but will be easier to help you with something specific to work with.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
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...
See attached. Thanks for the reply.
Last edited by Andrew1972; 10-03-2014 at 04:54 PM.
I have uploaded the files. Can you please take a look at these and let me know how i can add borders? I have attached one without the borders and one with. Thank you.
Maybe:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 06-15-2015 at 03:40 PM.
Hi Andrew
Another approachPlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
It worked almost perfectly except it didnt border the date in column j. How do i correct this? And thank you in advance.
Sorry I forgot to attach the spreadsheet.
Hi Andrew
Your original File didn't have a Column J...change the 9 to 10...
Please Login or Register to view this content.
jaslake,
Can I bother you with one more question? When I first run my report, I need to insert a row between each change in job. Can I add this insert function to the macro you provided? See attached spreadsheet for reference.
Hi Andrew
Would this be Column 1?
When I first run my report, I need to insert a row between each change in job
Not sure what you mean. I have attached what i need it to look like.
Hi Andrew
Try this
Please Login or Register to view this content.
Perfect. Thank you so much for your help, this will save me so much time.
You're welcome...glad I could help...thanks for the Rep.
If this resolves your issue please mark your Thread as SOLVED.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks