Hi
This is a table, named Table_1;
Using VBA I want to create a hyperlink in the A column, with the Text "Link here".
The address is located in the B column.
The address is local, on the same hard drive.
Then I want to delete the current B column, with the hyperlink still working.
I want to do this for the entire A and B column.
(I'm trying to help my colleague, and this is just a part of his question).
Best regards 
- My Goal is to visualize when a person has been present on site
I have a master table with headers; [A1]Date, [B1]Hours, [C1]Total_Date, [D1]Who, [E1]In/Out
Here I enter each and every event in chronological order. This table is 500 rows long and filled with data at the moment.
I want to visualize with a "simplified chart" for each and every name in the column [D1] when they have been on site.
An example chart is inside the attached excel-file.
(I cant to VBA sufficiently! This is just me thinking out loud!)
For this to work I thought I could evaluate in the lines of;
For [Who]
is [Chart date] AND [Chart_time] in between [IN_x] and [OUT_x]
then Current cell = "x"
Else Do Nothing
End if
My attachment displays fake data and pre-filled out "simplified chart".
Any help, using VBA or functions would be greatly appreciated.
Best regards
Good day
This is a VBA-question
In a table, called "Table1" with four (4) headings and ten (10) rows (A1:D11) I would like to select the Table row of the active cell.
I.e. If I place my marker in A4 the row A4:D4 would be selected.
And no, the entire row can not be selected 
Best regards
Re: Print one or multiple sheets based on checkbox values and then clear checkboxes
Ok, thank you for your help. I'll try to figure this out Probably a way around it some how.
Re: Print one or multiple sheets based on checkbox values and then clear checkboxes
Dave
This wont un-check my checkboxes when returning from the printpreview-screen. I have tride to put this code inside the sub and also outside in a Initialize Private Sub without results.
Re: Find one or multiple unique numbers, create table and do sum on category for that
Because I'm new at this. Never mind then.
Right now I have a UserForm with multiple pages on. The different multipages are used to input different kinds of data onto different sheets in the workbook.
When completed all data will be consolidated onto two sheets for printing.
On first page of multipage I have a frame with printing options.
Checkbox “cbSammanfattandeB”
Checkbox “cbAlkoholP”
1. I want the user to be able to chose what sheets to print, one or both.
2. After printpreview I also want the checkboxes to be cleared (not checked). I have tried to use the “.Valus = False” but it wont clear the box…
3. Can I set the button cmdPrintEvent to actually print the selected sheets without them being previewed? If so, can anybody hint about the code for that?
Private Sub cmdPrintEvent_Click()
If cbSammanfattandeB = True And cbAlkoholP = True Then
Me.Hide
Sheets(Array("Mastersheet", "2BPrinted")).PrintPreview
Me.Show
ElseIf cbSammanfattandeB = True Then
Me.Hide
Sheets("2BPrinted").PrintPreview
Me.Show
ElseIf cbAlkoholP = True Then
Me.Hide
Sheets("Mastersheet").PrintPreview
Me.Show
cbAlkoholP.Value = False
End If
End SubRe: Find one or multiple unique numbers, create table and do sum on category for that
forum.ozgrid.com/index.php?attachment/44419/Yup, that was amost all I wanted to fix!
1. Also, row 19, 26 and 33; I want to change the row height to 4.
2. Also I want to change the way the cell borders are drawn. Check attached file findandfill04, sheet 2BPrinted, and then look at how the cell borders are drawn. Is that possible to do with VBA code?
When this is done you have answerd all my questions for me!
I am very greatful for all your work!
THANK YOU! :yourock:
Re: Find one or multiple unique numbers, create table and do sum on category for that
forum.ozgrid.com/index.php?attachment/44393/
The code from your post 11 works just as you describe!
It wont delete any cells below on sheet 2BPrinted, and including, the cell that has a value and the font is set to bold.
I don't eaven know if I dare to ask of you to help me out more with this sub anymore, and if you feal that you've done enough please dont answer this next question;
I am trying to understand my self how to format the cells of the generated tables but right now its a whole new world to me.
Im attaching an example of how the goal of the formatting should be.
I didnt focus on this in the beginning of this thread because I didnt even think that I would get an answer for the issue of sorting and generating new tables...
Re: Find one or multiple unique numbers, create table and do sum on category for that
Below the summary tables created by sub test that you coded there will always be one part static text but also more tables that other sheets will generate. These tables will have number in them that are dynamic (cell references or values comming from a userform that I have made).
The example text and example tables that are in the sheet NOW are only examples and not how it will acctually look in the end...
I cannot send you any more, and better, example files until monday because the files are at work.... sorry.
I hope that if you can figure a way around the issue of everything below B16 is being deleted when running sub test that you are willing to share your brilliant sollution with me I am very greatful for your help! Best regards from Sweden
Re: Find one or multiple unique numbers, create table and do sum on category for that
forum.ozgrid.com/index.php?attachment/44341/
Here I have inserted some expamples of how test could be placed already in sheet "2BPrinted".
The key question is, as I see it;
1. How to not delete the text and tables already present in the sheet "2BPrinted" or
2. How to after sub test in run insert the text and tables one or two rows below the last summary table created by sub test
Re: Find one or multiple unique numbers, create table and do sum on category for that
Jindon; I have tried your sub with changes to font size and it all works perfectly.
Thank you.
The one thing that might be an issue for me now is the fact that below the tables you helped me create on sheet "2BPrinted" are more tables, and more text and everytime I run the sub "test" that you made for me everything below row B16 is being removed.
- Maybe you know how to keep cell values below B16 and just "insert new rows" or maybe the answer would be to write additional code that after sub test has finshed will paste from another sheet (lets call it 2BPasted) the remaining text that needs to be on 2BPrinted?
Also, and this for you will be an easy question, I need to reduce the number of rows inbetween the summary tables from four to one row.
I am very greatfull for your help!
Re: Find one or multiple unique numbers, create table and do sum on category for that
Thank. Will test tomorrow when at work.
Next thing for me is to learn how to format the table that your code generates on the Reportsheet.
I.e. the red lines wont be there in the end, and row height and font size must be corrected. I'll try to google it and hopefully find a good answer.
If you have any tips for where to learn formatting through code it would be much appreciated. Especially row height and font size...
Re: Find one or multiple unique numbers, create table and do sum on category for that
Holy excel guru. Ok, I thought it might take a week or so, but your sub worked right out of the box.
I am so greatly impressed.
- Thank you!
I think im gonna love this forum for the rest of my excel-life!
I'm trying to develop a workbook that can take "raw" input data and then filter it into a predefined report sheet that will make the "raw data" understandable and make for allot easier reading for the recipient of that report.
The raw input data should always contain one RefNo, a category and a total sum of that specific row inserted. That is right now not an issue.
One sheet of this “raw” data usually contains one up to five different RefNo’s.
I want to;
1. Identify the different unique RefNo’s
2. For each RefNo do SUM based on what category there are specified
3. On a different sheet ("Report sheet") create one table for each unique RefNo defined in the "raw-data" sheet
4. Insert the category based sums into corresponding RefNo table
These category sums, all with the same RefNo, should then be inserted into a “Report sheet” and into a simplified table; a table of content so to speak. In my attached file the "simplified table" is marked with red outlines.
Because of the fact that the “raw data”-sheet can contain one up to a multiple unique RefNo’s I can never build “empty” simplified tables on the report sheet to be filled, but instead I want to create one “table” for each unique RefNo from the “raw-data”-sheet.
I have tried to implement the pivot table functions to do this but right now I am not aware of any way of exporting specific data to a specific cell and the issue with how many tables that should be created on the “report-sheet” still remains.
I have learned allot during the last couple of weeks on this forum and I hope that someone with better knowledge of excel and/or VBA could give me a helping hand here.
Please se attached file for further description of my problem.