I have a name list of my student with images using comment box. The problem is i want to put numbers on the right side of comment box automatically according the names list which makes easier to me to recognize them.
Files given... commentbox.jpgcommentboxnumbers.xlsx
I have an excel spread sheet and on the last column on the right hand side I have some comment boxes but when I hover over them they pop up to the right of the cell, and then they are off the screen.
Can I alter it to make the comment box pop up to the left side of the cell.
[Code] ....
Is it possible to adapt this code to get me the desired results or will it have to be a separate one.
Also i'm not sure if I have the code right because if I run the macro then open a comment box in the (M) column as in the code the comment box is the default size then if I run the macro again once I have the little red tick in the corner of the it changes to what the code says.
Is it possible to compare two columns side by side to highlight/change color of difference between the two cells
I need to compare and show the changes to the record from previous version and generate a report which will highlight the changes (Rather than just saying that record has changed It should tell what has changed)
For example if the
Column 1 (Previous Version) :The structure contains Wire, Bolt, Stmaps etc
Column 2 (Current Version) : The structure contains Wire, Bolt, Stamps etc
Data Changed: YES
In report is should show two columns side by side and in Column 2 it should highlight "Stamps"
Is there a way to have separate Report Filters for each column in a pivot table?
I am trying to create a pivot table with 3 columns - 1: account code 2.current year (2011) 3. prior year (2010)
My Row Label is an account code field - each row is a different account code that sums up dollar amounts for the two financial years. The problem is that I need Columns 2 and 3 to have separate Report Filter criteria. So in Column 2 - I need the filter to weed out anything that is not 'Financial Year 2011'. In Column 3, I need the filter to weed out anything that is not 'Financial Year 2010'. Setting up a filter for one screws up the second, and vice versa.
Alternatively, how can I make two side-side-pivot tables that each have their own Report Filters?
I have two sheets that need to have unique partial matches aligned side by side. My first sheet is my database. The righter most column of this sheet contains a unique combination of letters and numbers.
My second sheet contains a single column which I export each month from our CMS and is a list of URLs. Within each of these URLs appears the unique set of letters and numbers from sheet 1 (and only appears once).
There are about thrice as many URLs in sheet 2 as there are entries in my sheet 1 database.
Ideally, I would like the URL from sheet 2 that contains the unique combination from sheet 1 to be pasted in the cell immediately to the right of the given unique combination.
However, I will settle for a list of trues and falses next to the URLs in sheet two that I can erase the falses, sort and paste next to the sorted list from sheet 1.
i have 2 excel worksheets. One of them contains over 20,000 rows of entries (old side) and the other contains about 900 rows of entries (new side). Both contain the same 9 column headings. I've shortened the list in my workbook example.
What i need to do is excel to delete any row on the old side that is not contained on the new side. I don't need the rows to match fully but the column A's (Doc number) are what i want it to check against. I've included a summarised version of the database and the old and new are separated by a heavy blue line. Need to be left with the same rows on either side of that blue line at the end.
I'm trying to figure out how some conditional formating and I cant get it to work.
What I want is for column H to be highlighted based on the value of column I.
So... If I2<721, then H2 will highlight green. If I2 is between 721&780, then H2 will be highlighted yellow. And if I2>780, then H2 will be red.
I know how to do it one cell at a time, but I need it to apply to the entire column based on the cell next to it.
Also, I dont have access to visual basic.
I need function that swaps text from side to side. Text at the left of "x" should be placed at the right side of the "x" and from right to left side:
6x15 -> 15x6 plaah plaah xsomething -> somethingxplaah plaah How to do this?
I have a sheet with a number of repeating blocks copied down.
I would like a macro that when I select the first block, say range "A1:D30", the macro will cut the blocks below and put them side by side, so that I can compare them across.
i.e cut "A31:D60" and put it in "F1:I30" and so on ...
I have created a spreadsheet that has information about networks, subnets etc..
The top header for both companies in (CSV format) reads:
Network Namenet_addr1net_addr2net_addr3mask_lengthorg_idcidrlast_upd_dt
I basically split the spreadsheet to show both side by side.
I have this information for both networks that I am trying to compare what subnets, names, IP address etc... over-lap.
We are merging two companies into one, and I need to identify or highlight what information on both companies over-lap.
why a person such as myself cannot have two or more Excel Docs on the screen side by side at the same time? And if it can be done, how do you do it?
View 9 Replies View Relatedon the attached workbook i have date on the left jand side and some info from this data will be produced on the right hand side.
Can i have the worksheet so that if the user scrolls down the data on the left the info on the right is still in view?
i have a sheet that contains side-by-side,below two formatted colums which has continuous weeks appearance(named PE sheet). i wanna to rearrange the colums to be a single top-down colums according to continuous weeks(named sheet2.are there any easier and faster techniques?a macro probably or a function? arrange(english).xlsm
View 1 Replies View RelatedHow do I add a "comment" to an item of a drop-down list? I've got several items and every item has its own comment. I dont know how to do this.
View 1 Replies View RelatedMy goal is to have a picture pop up (preferably for a set amount of time), when a user selects a certain option from a data validation drop down list.
I have seen that you can add a picture to a comment, bu I can't combine comments with data validation lists.
Is there any way to get a comment to be part of a data validation list?
how to copy the contents of multiple comment boxes and paste in a single comment box.
The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.
I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.
Say column A has either numbers or text in each cell, I need a macro to only get each number in each cell that is not a duplicate of a number in any previous cell and list each number found down column B.
View 5 Replies View RelatedI'm trying to create a staff rota which will populate a rota randomly when prompted - I have been trying to find some way of connecting the random lists and the staff names, though this has proved difficult (to say the least!). How best to proceed? I'm also fully aware of the possibility that my present design will also double book people (place then on reception and telephone duty simultaneously).
View 3 Replies View RelatedIs it posible and how to create a list of barcodes from a list of numbers on the worksheet?
Strokescribe seems to have some ind of solution but the data can't come from the worksheet.
Does excel 2013 have a fence way to sort a list of alpha numeric numbers and alphabetize in this order A - Z and then 0 - 9.
Ex) Apple, Greg, Rob, Sand, 123, 126, 1000, 2001
[URL] .... If you take a look at the picture, what I'm trying to do is add the list of Prices up so that I can differentiate the amount received in $ and in £.
I need to add up all the numbers that don't have a $ in front into the 1 cell, and all the ones with the $ in front into another cell.
FEdLkuj.jpg
Is there any script that I generate 6 numbers of these numbers from the list? so they do not recur after another example 7,12,13,19,26,33
View 2 Replies View RelatedA
B
c
d
[Code]....
So the data I put in Is Cells A to D the reast are calculated for me. so for example E2 is looking down column D to see if the number matches the number in A2, If any of them do it will put the name in the corresponding cell in E2 (Or you ca use a different cell if you prefer) so in this case D3=A2 so B3 is the answer also in the cell next to it I need whatever number is the cell next to the answer so in this case C3
1- I have a list full with numbers in a column. And I want to count how many digits are there in every cells. If digit of the number is less than 7, macro will complete it to 7 digits by adding 0 (zero) at the beginning of the number.
Example: A1 = 85468... A1 value is 5 < 7 in this case our number will be 0085468 (total 7 digits)
PS: sometime, when numbers start with 0 (zero), excel delete all 0 value at the beginning of the numbers. Macro should prevent this error.
2- I have another list with 2 columns which arranged in order. I mean:
A1=xx1, B1=xx2, A2=xx3, B2=xx4, A3=xx5, B3=xx6... etc. One is at A column, next number in B column.
My request is I want to make this list 1 column as arranged.
A1=xx1, A2= xx2, A3=xx3, A4=xx4... etc.
3- Macro will add a new line to the end of the above list with this format:
Z00001xxxx
Z00001 is static
xxxx is number of the full cells of A column plus 1. It will be 4 digits. If count is less than 4, it will complete it to 4 digits.
Example: if there are 15 cells in the list, last line will Z00010016 (15 + 1)
Let me see if I can explain my question in an understandable fashion....
I have a table containing data for about 2000 ID numbers. Some of these numbers are unique and some are duplicates. I would like to convert the ID numbers into a consecutive list of integers while preserving the unique numbers. For example, if the first column of my table is currently:
ID#
18578
19644
19644
20247
20974
21361
21361
21419
I would like to change that to something like:
ID#
1
2
2
3
4
5
5
6
I need to know which records (i.e. which rows of data) are from the same ID# but want to remove the actual ID#.
i try do function, which will be search/monitoring in selected cell (colored – yellow, orange, blue) and display (in green/results column) the last value in row colored/selected cell (first value from right side – results will be only for row).
View 14 Replies View RelatedI have to create lists of data in the following format:
123121321,12321215,121351213 (numbers with , with no spaces)
These numbers are sent to me in excel in columns and I need to convert the columns into rows using the format above.
The formula I have been given:
=INDIRECT(ADDRESS(((ROW()-1)*10)+2,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+3,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+4,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+5,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+6,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+7,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+8,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+9,1,1,TRUE,"SSOs")) & "," & INDIRECT(ADDRESS(((ROW()-1)*10)+10,1,1,TRUE,"SSOs")) & "," &
INDIRECT(ADDRESS(((ROW()-1)*10)+11,1,1,TRUE,"SSOs"))
currently I only get 10 numbers per row
I need at times for up to 500 numbers to be listed on a row. However even when I try to extend the formula it still only gives me 10 numbers per row and breaks up the 500 numbers to 10 per row.
Is there another way to combine up to 500 numbers in one row?
From a list of numbers I would like to delete values that have cents so only those transactions with a .00 amount are displayed
For example
34.95
21.88
21.00
56.00
45.77
Only those valaues ending in .00 will list. I tried filtering but I think there most be a function(s) string that might work or at least filter out the values with cents
I have created "front page" which allow user to enter their enquiry.
The formula will be as per below.
Issuing
World Bank -->if amount less then 500,000 = amount x 0.03125%; if amount from 500,000 - 2.5mil = amount x 0.015625%
Royal Bank -->amount x 0.0625% x no. of month (min charges 100)
Deutsche Bank -->0.025% per 3 months (min. S$50)
Stand By LC
World Bank -->0.02% per quarterly (3mths) - Amount X Rate X 1 (1 to 3mths) or X 2(4 to 6 mths) or X3 (7 to 9 mths) or X4 (10-12 mths)
Royal Bank -->0.25%p.a by day (Principal x Rate x Day divide by 360 day x 100)
Am I able to set a formula for example:-
1. When I click on Mode of payment - Issuing
2. On my right hand side under column "Bank Name" will list down all bank available
3. On my right hand side under column "Estimate cost" will auto calc the cost base on the bank's formula.
Is it possible to have table headers that are down the side instead of going across the top?
I have searched but have not found an answer so far.