I have created a garden bed planting chart in excel. I made each cell a square where each cell will be equal to 1 square foot and simply typed in the plant name that will be planted in that spot. The planting beds will be on each side of a sidewalk. I want a mirror image of the layout for the opposite side of the sidewalk. How do I do this in excel?
View 9 RepliesI would like to mirror a range of cells between two sheets in the same workbook, so that if the data is manually input into one of the cells in range (E5:H11) in 'Sheet 1', it is automatically updated in the corresponding cell in (H33:K39) of 'Sheet 2', and vice versa.
Using Office 2013. T
What's the easiest way to take columns of cells with a number followed by a space and then text, and switch the order to text/space/number? (my columns look like this "8 piscataway", "14 dayton", "42 mason", and I'd like them to read "piscataway 8" etc).
View 5 Replies View RelatedI have the following macro
Sub UpdataMainTables()
'
' UpdataMainTables Macro
'
'
Sheets(" Table ").Select
Sheets("Main Data").Range("B2:B1048576").AdvancedFilter Action:=xlFilterCopy _
, CopyToRange:=Range("B2"), Unique:=True
[Code] ......
I have 2 questions
First one about avoid the movement of this macro, as you can see it starts at one sheet but the job is in other sheet when i run it it goes to the second sheet to do the job,, how i can avoid showing the movement.
Second question about th last part of the macro,, it most replace words with no thing,, if these words are not available it givs me alert,, how i can eliminate this alert.
I have used VBA to copy data from a sheet into some shapes. Some of these shapes are upside down and therefore the text is upside down. Is there a way to flip the text without having to flip the shape?
View 1 Replies View RelatedI need to link an image to a cell value and display the selected image in a new sheet of the same excel. I am attaching samplefile for easy reference. The requirement is, from the workout sheet when I select from drop down list, then the corresponding cell value appears in Parameter sheet in C9 cell.
There are four images copied in Parameter excel. The given image has to be selected and linked to the C9 cell value. Based on the selection that particular image should be shown on Sample Picture sheet. Here based on the selection only the image should reflect here.
I need to find an easy way to locate an image on my server and upon selection rather than inserting the actual image I need to insert the image path. e.g. "s:imageshighresgreen1234.jpg"
View 3 Replies View RelatedMy workbook simply has multiple columns of data which will be summarized visually in a tag cloud (I have the tag cloud part taken care of already creating either a jpg or png, I simply have to change the extension within a batch file to change between picture formats)
I need to have the tag cloud image display and update depending on which column the user would like to summarize (for now I have simplified the issue by only having one of the data columns in my workbook, and will worry about the user selection of the data column to be summarized later).
My Main Question:
Focusing on the image display and updating now, whether it be an ActiveX Image Control or any other way. I've been playing around manually before I try and code it and I can not get either a jpg or png file to attach to the ActiveX control (both of which cause an Invalid Picture Message).
The file name can stay the same if need be and for now I think/assume that'd be easiest (I have my Tag cloud generator just replacing the previously existing image file of the same name).
Would ActiveX control be the way to go for this dynamically changing image?
I am looking for a way to take the picture name associated with an image ie: (picture 571) and place that picture name in the cell next to the image.
I can see the picture name - it registers in the top left box that usually indicates the cell the cursor is on... and I could manually type that name next to each image.
However my spreadsheet has several thousand rows- each with several columns of information and an image..
I am looking for a way "formula?" to automatically read the image in cell J4 and populate cell K4 with the image name... and so on.
The reason for my request... is I am importing products into a web based shopping cart... to do so I have to export the products to a csv and import that csv into the shopping cart. The process of exporting to a csv- strips away all the images and leaves just data.
I found that I can save the document as an html and that process creates a folder with all the images- saved as (picture 571.jpg) if the resulting csv had the image name... the shopping cart would then look for that image name in my image file and it would populate into the shopping cart appropriately.
This seemed on it's face like a really simple thing to do, I have plenty experience with excel & I thought I'd be able to make cell k4= j4 and tada it would glean the image name & I could simply copy that formula all the way down the sheet & it would be done... but I just cant find the magic button that freely gives up the image name...
I have a dataset that includes the path and optionally an HTTPS URL to an image. Is it possible to embed this image in a cell?
Short of that what might be some other options?
is there a way to load an image out when u type the image name in the textfield.
Example when I type in my name it load my image out beside the name.
I have a number of image controls on a user form, each being loaded with an image from file.
Image1 being loaded with a picture of a bus image2 being loaded with a picture of a school
And so on
Now what I am trying to do is when that image is clicked the name of that image is passed to a textbox
So the action would be
1 image of bus loaded into image control1 , the name of that image being bus.jpg
2 image is clicked
3 the name bus.jpg appears in a text box
Here is what I have so far
Code:
Private Sub Image1_Click()
DataInput.TextBoxItem.Value = bus.jpg
DataInput.TextBoxItem.Value= Image1.Name - this does not work
End Sub
Which works but as you can see this is static, as I have supplied the value , were as I would like the clicking action to pick up the name of the jpeg being displayed
So expanding upon this if say image1 is loaded with say a picture of a car instead of a bus
LValue4 = "E:Car.jpg"
Image1.Picture = LoadPicture(LValue4)
Now when it is clicked the name of the image being displayed in image control1 would be Car.jpg
And it is this value I wish to transfer to a text box for now will do more with it later
In addition to this I am not sure if the best idea is to have a number of image controls and load each with an individual picture or have one image control and swap the picture by clicking a command button
Is there a way to have image box display an image with a name matching data from a cell? example: if I type "hello" in cell a1, Image box will load image named "hello". And display new images by changing the name in cell a1. Note: the images will be located in a permanent folder.
View 3 Replies View RelatedI Want to copy some part of an excel sheet and paste it exactly as an image on to another excel sheet.
View 3 Replies View Relatedl want to change picture according to the cell. For example. İf cell is "car", it will be 1.Picture. İf cell is "plane", it will be 2.picture. But Pictures will not be in the excel file folder. Picture was copied into excel file. I've added a sample file.
View 2 Replies View RelatedI would like to take cells from sheet 2 and have them copied into sheet 3 automatically. How do I do this? So as I am updating information in my sheet two, I don't have to manually input the information into sheet 3.
I would like Sheet 2 cells O:3, O:4, O:5, O:6 quantities to automatically be updated in Sheet 3 cells A:2, A:3, A:4, A:5.
I would like to instantly mirror any selected cell within a specific column into another specified cell.
Example:
If A1 has the value 4, A2 has the value 6, A3 has 7, A4 has 9, and I click on those cells in the order above, I would like to see the cell I specify show the same value when I've selected (clicked on) them.
A macro was submitted in a similar thread, but I have a slightly different problem. I have empty cells, A1:A10, and in cells C1:C10 I have data. If A1 is selected, I would like to be able to click on any cell in colum C and that info then appears in A1. Then I will select A2, and again, click on any cell in C1:C10 and that appears in A2 and so on. I do not want cells A1 etc. to
change once populated. This can be a macro as well.
I gather data and several sheets within a workbook and sort the data regularly. I have a tally sheet that references these sheets. My problem is that if I make a cell bold or red in the main sheet it does not show bold or red on the tally sheet. Is there a way to get the format to carry over to the tally sheet?
View 2 Replies View RelatedI need to set a background as an image, but retain the cells so I can type in them individually (not using text boxes). This template will be used for automatically generated daily reports, so the cells have to be present. How can I retain the rows and cells as they are, but set an image behind them? Note: This isn't the header part of the header and footer, but the top of the document.
View 7 Replies View Relatedin ROW 1 I have columns A thru AD populated with a number in each cell. what I need to do is take that number and fill the below cell with the number times a set character. for instance, A1 has "4" in it, so I want A2 to look like "----"
View 3 Replies View RelatedI want to make a mirror copy of worksheet so that i can use filter option more than one names for the same column and for same sheet.
View 5 Replies View RelatedUsing Office 2011 for mac, but felt this question was best suited for general.
Here is the situation.
I have a workbook with three sheets. It's a price/invoice/labor workbook.
Sheet 1 has all the data, including my cost and loss/gain fields
Sheet 2 has labor costs and the totals are linked to Sheet1
Sheet 3 is the customer copy of the first sheet. It does not include wholesale and profit info.
I'm trying to link the cells so that when info changes in Sheet 1, it's reflected, in real time on Sheet3
Right now I'm using a formula per cell ='Sheet1'!XXX (where XXX = the cell/column location, ie D15). The first column I started has this formula in every cell, about 100 in all, copied by hand and changed to reflect. It works, but it seems like there has to be an easier way to mirror or link the data. I tried pasting special with links, but continue to get errors as the link pather includes the entire file data path from the local machine.
I still have about 200 cells left and I'm dreading doing this all by hand. Also, If I add a new row to sheet1, this will not reflect in sheet 3.
I have some software that was written for me that scrapes data. It has a file in it that mirrors the web pages that it is scraping.
I would like to actually import those web pages one at a time based on a condition in the browser. The code of the web page is html. When one of the 35 mirror web page's "MTP" = "POST", I would like for all the web page to be loaded into a sheet called WPS. I would want that to stay loaded until "MTP" = "OFF". There may be more that one of the mirrored web pages with "MTP" = "POST". In that case, only one can be loaded at a time and that is fine. Once the "MTP" = "OFF", I want it to go to the next mirrored web pages with "MTP" = "POST" and load that web page from the mirror file.
Here are 4 of the 35 web pages that are mirrored and their paths
C:TotearkmantotemirrorWPSAQU.HTM
C:TotearkmantotemirrorWPSBEY.HTM
C:TotearkmantotemirrorWPSCTN.HTM
C:TotearkmantotemirrorWPSDDN.HTM
How do I copy a range of cells containing formulas to another range of cells without chaning any of the letter or numbers from the original. I want a mirror copy of whats in A3:B10 to got to D3:E10..
View 3 Replies View RelatedIs there a way to mirror two ranges of data on different sheets - i.e. if I update one sheet, it updates on the second, without using formulas, macros.
View 3 Replies View RelatedHow can I write a macro to mirror x data that will be charted using xy scatter? The original data is entered into excel using measuring equipment with a footswitch. I need excel to automatically mirror the incoming data as it comes in. It should look like my example only with 2 more columns to the right with mirrored x data in the 1st and the same Y data in the second. Example.xls
View 9 Replies View RelatedHello, what I would like to do is take a portion of a sheet..... So the cells I want to mirror are in the proposal sheet cells B32 x F51. And then mirror the exact duplicate copy to another sheet. The other sheet should have those same values at A20 X G39. What I am trying to do is have a sheet that has skus, prices, and so forth and then when I add,delete, merge, color, or do anything to the cell on the "proposal creation" sheet I want it to mirror only a specific cells to another sheet that is "salesman copy" that we will print to clients. So this way ont he proposal copy a salesman can insert rows or even change the color of the cells and then have it mirror exactly the same on the "salesman copy" which is what we will print for clients.
View 9 Replies View RelatedI have a list of names on my first sheet, and I want to mirror these on a second sheet, but at the start of a repeating table containing data releating to each named person. eg. I want a Name in
'Sheet 1'!A4
to display in
'Sheet 2'!A5
, and then the name in
'Sheet 1'!A5
to display in
'Sheet 2'!A32
I am trying to display an image ("image") on an image control ("Image1") placed in a worksheet ("Sheet1"). The problem is that I want this action to take place when I press a button in a user form. I am trying to use the following code, but it seems that VBA does not recognize the image control ("Image1") in the worksheet.
Private Sub cmdDisplayImage_Click()
Dim image As Variant
image = ThisWorkbook.Path & "sun.jpg"
Sheets("Sheet1").Activate
Image1.Picture = LoadPicture(image)
End Sub