If a range of cells = to a name
Closed
Stormdronk
-
11 Apr 2011 à 10:26
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Apr 2011 à 00:41
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Apr 2011 à 00:41
Related:
- If a range of cells = to a name
- How to increase wifi range - Guide
- Excel vba range find - Guide
- How to delete cells in word - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Excel arrow keys not moving cells - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
12 Apr 2011 à 00:41
12 Apr 2011 à 00:41
I have given sheet1 and sheet2 in html format. I hope it will come on your reply correctly. see formals in column B in sheet 2 confirm whether you get the data correctly.
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:185px;" /><col style="width:145px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Company Contact Info</td><td > 6 R 350 R 2100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Google Map</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Submit Enquire</td><td > 5 R 350 R 175</td></tr></table><br /><br /><b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:231px;" /><col style="width:151px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=VLOOKUP(A1,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B2</td><td >=VLOOKUP(A2,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B3</td><td >=VLOOKUP(A3,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B4</td><td >=VLOOKUP(A4,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B5</td><td >=VLOOKUP(A5,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B6</td><td >=VLOOKUP(A6,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B7</td><td >=VLOOKUP(A7,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B8</td><td >=VLOOKUP(A8,Sheet1!$A$1:$B$11,2,0)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:185px;" /><col style="width:145px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Company Contact Info</td><td > 6 R 350 R 2100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Google Map</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Submit Enquire</td><td > 5 R 350 R 175</td></tr></table><br /><br /><b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:231px;" /><col style="width:151px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=VLOOKUP(A1,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B2</td><td >=VLOOKUP(A2,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B3</td><td >=VLOOKUP(A3,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B4</td><td >=VLOOKUP(A4,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B5</td><td >=VLOOKUP(A5,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B6</td><td >=VLOOKUP(A6,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B7</td><td >=VLOOKUP(A7,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B8</td><td >=VLOOKUP(A8,Sheet1!$A$1:$B$11,2,0)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>
