I'm new to VBA, but have been trying to teach myself the basics. I was able to copy and paste from multiple workbooks onto on macro-enabled workbook. I need to transfer all data, even duplicated. I want a unique identifier for each of the workbooks that were pasted into my master. Here is my...
I have large amount of data to sort and to assign id for database bulk upload. It is really hard to manually assign its own id for each data. So if anybody knows ,can you please tell me how to do this in excel.
The data is shown as below
I am trying to create a formula that will identify unique ID's and pull them into a list in one cell that shows each unique ID separated by semi colons.
I have a spreadsheet with the following layout
<TABLE style="WIDTH: 402pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=536><COLGROUP><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 64pt; mso-width-source: userset...
I have created a form that when printed will be used as a rejection tag for isolating damaged or on-hold parts. Each tag that is printed must have a unique ID number. Is there a way to have excel automatically populate a field, giving each saved/printed tag a unique ID?
For example, I open...
Hey everyone - This one's rattling my brain knackered - so I thought I'd repost this in clearer english to try and bring about an answer...
What I need is for column X in Sheet2! to have a number plopped in it everytime this macro is run. The hard part has been done - it already identifies the...
I have a sumproduct formula in a cell that returns a count of the number of times several columns satisfy certain conditions.
One column referred to in the formula contains a unique identifier.
How can I tweak the sumproduct formula so that it will ignore any repeat instances in...