Re: Macro to copy cell content and paste into 'Find' box
Solved!
Re: Macro to copy cell content and paste into 'Find' box
Solved!
Hi
I need a macro which will select the 'current cell content' and copy to clipboard... (I would start the macro using keypress).
I then want to select an area of cells on another sheet and when the "Find" box pops up (per the script below), to focus on the "Find" input and PASTE the copied cell content into the "Find" and press ENTER (so the find takes place).
Sub Macro1()
'
' Macro1 Macro
'
Application.Goto Reference:="a_All"
Application.SendKeys "^f"
End Sub
Display More
Many thanks in anticipation.
Hi
I have a big SS containing 500+ individual products. I need to be able to select individual items on my main worksheet, and then those selected items appear on another worksheet that has my label template graphics set up as grouped objects, the data will appear in specific cells in each label.
I have set up a simple example of what I am trying to do, with a 'datasample' and 'label' worksheet
Thank you in anticipation.
Re: Display images automatically according to data in table
Hi thanks again. I could use some guidance on how to use this, I click 'update' on the new pivot2 page and the images just vanish and don't come back?
Thanks
Re: Display images automatically according to data in table
Hi
Thank you for your efforts, what you have achieved is neat. However I need the images to be all visible in the 'location report' because I print it as a hard copy and also PDF in iPhone for archive reference record.
Many thanks
Hi
I have a long table (2000 lines and growing) that I use to manage several hundred different pieces of art. The main table records all details of each painting and I use Pivot Tables to create seperate 'location reports' (on individual worksheets) that lists the particular paintings currently displayed in a specific location (i.e. venue).
Attached is a sample of a 'location report' I currently use - which contains a pivot table populated from the main table listing the paintings currently displayed in 'SanLeo' art gallery.
Also you will see corresponding images, these are pasted-in manually from the main table, which is a labourous task I have to keep repeating.
I need the 'location report' to automatically the display thumbnail images to match the 'Ref' appearing in the particular Pivot Table. The images will be named with the unique 'Ref No' (there will be several 100) and can be stored in a local folder?
Can this be done? Any help will be much appreciated.
Thank you
Re: Increment Cell Reference.
Hi Glenn
Thank you, I think that's really clever!
Much appreciated.
Re: Increment Cell Reference.
Hi Glenn
Thanks for your speedy reply. I am not a complete novice and do use some formulaes (with help from this forum) but I apologise for my ignorance as I can't make sense of this. Maybe if you could show my in my sample SS?
Many thanks Rob
Hi
I need to create a form from a long Excel list containing specific cell data (i.e. a follow-up form for a marketing list).
When I copy/paste my form the Row jumps 8 rows, when I need it to go to the next row in my original list.
My data is on sheet1 and my form will be on another sheet.
Please refer to my attached representative sample.
Any assistance gratefully received.
Many thanks!
Re: Populate Table Based On Data In First Column
Thank you for your help, I have achieved my desired result...
Re: Populate Table Based On Data In First Collumn.
Hi
I have managed to replicate your example, however I am trying to achieve the same result with my 'actual live' data which has more fields than the simple sample.
I have created pivot tables from my 'live data', however for some reason the data does not appear on the same row...
I have copied a sample into the attachment sheet3.
Thanks
Re: Populate Table Based On Data In First Collumn.
Hi
I don't know anything about pivot tables, I haven't seen one before. Will it do what I need?
I don't now how you created the sample you sent me. Could you give me some hints/directions on the sample you created?
Thank you for your help!
Hi
I have a long table containing product data (1200+ lines and growing).
I have attached a simplified sample of what I need to achieve.
Column 'A' contains the 'current location'. I need to be able to populate seperate tables for each specific 'current location'.
The 'current location' changes regularly and I need the corresponding tables to remain current and reflect the changes.
I do not want blank rows in the new tables.
Thanks in advance!
Re: Count Items Repeated In A List
Hi AAE
Many thanks that worked great!
Regards Rob
Also, thanks Stan for for your reply but used AAE's suggestion.
Hi
I have a table of data, from which I have created lists for “items created within a period” (the items are paintings on canvasses).
Each list displays which canvasses were completed within 2 dates.
My main data table is large (over 1000 lines and growing) and I need to extract the total quantity of each canvas size that appears in each period list.
My sample attached shows sample data, with corresponding lists of canvasses created within each time period, together with the result I am looking for ([COLOR="Red"]shown in red[/COLOR]).
Many thanks
Re: Fill Table Based On Another Within Date Range & Cut Off Date
Hi
This has worked great, many thanks!
Re: Fill Table Based On Another Within Date Range & Cut Off Date
QuoteI have broken the date out of the text in cell N5, placing it into P5. This date does not match the end date in Q6, so we need a clear date value to test against per your stated requirement.
Apologies my typo, but I understand what you mean.
Sorry it isn't working yet, eg. 1st 5 lines of your new table;
Ref 0098 - appears - OK
Ref 0110 - blank - item wasn't sold until 13/9/08 so is still 'unsold' @ 05/4/08 and should appear in the list.
Ref 0097 - blank - item wasn't sold until 10/5/09 so is still 'unsold' @ 05/4/08 and should appear in the list.
Ref 0107 - appears - item was sold on 20/12/07 which is within the date range > 05/4/08 so should not appear in the list
Ref 0099 - blank - item wasn't sold until 30/11/08 so is still 'unsold' @ 05/4/08 and should appear in the list.
Thanks.
Re: Fill Table Based On Corresponding Table Within Date Range And With Cut Off Date
Hi, Apologies if unclear... (this project is a sample I have created to explain a section from a large SS I need help with)...
QuoteWhat, then, constitutes "unsold" other than a blank in the either the Date Sold field or the Sold Status field?.
Nothing, you are correct.
QuoteMoreover, I don't see any date of 06/04/08 in any of the tables in your sample workbook
The date 06/04/08 is the end of date range, it doesn't happen to appear in my sample.
I hope this explains it adequately...
I have amended my sample per attachment to show 2 'tax years' [Green for 07/08, Pink for 08/09];
1. Existing Results Table - is updated as time goes by, eg. a piece created in 2007 will eventually be sold and the 'Date Sold'/'sold status' is then added.
2. The 'Sold List' for period 06/04/07>05/04/08 is the UK tax year, and this lists any items sold within that time period.
3. This system start-up was 1/1/07. The 'Unsold List' for period 01/01/07>05/04/08 displays any pieces created from start-up to the end of that tax period (i.e. 05/04/08) that haven't been sold as of 05/04/08.
The 'sold list' and 'unsold list' will be repeated for each tax year going forwards, the only difference being that the 'unsold list' will always start from 1/1/07 - because a piece created in 2007 might not be sold for several years.
Thanks for your assistance, I hope this clarifies it...
Re: Fill Table Based On Corresponding Table Within Date Range And With Cut Off Date.
Hi
Thanks but its not quite right... the 'unsold list at 06/04/08' should appear per my sample in red (aprt frm typo Q15); these are goods created before 05/04/08 (i.e. the date range) that have not been sold as of 05/04/08 per the 'date sold' in col F.
Thanks again.
I have an 'existing results table' as per my attached sample.
I have had help previously from this forum to create lists of 'sold' stock within date ranges (tax year periods) and these are represented as 'sold list' in my attached sample.
I now need to create a list of 'unsold stock' for each annual tax year end date; i.e. populate my table with items that have been created before the end of the date range and that have not been sold by the end of the date range.
Please can someone show me the formula on my attached sample?
Please see my example in red.
*Please Note. I am working with Excel07 however my attached sample is in Excel03 because I couldn't upload an XLSX file.
Thanks